Changes between Version 31 and Version 32 of RelationalDesign


Ignore:
Timestamp:
09/25/25 20:35:55 (3 weeks ago)
Author:
225144
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v31 v32  
    2121
    22225. **thread** 
    23    (__**id**__, content, **created_at**, **user_id#(users)**) 
     23   (__**id**__, content, **created_at**, **is_created_by#(users)**) 
    2424
    25256. **project_thread** 
     
    3030
    31318. **topic_thread** 
    32    (__**id#(embeddable_thread)**, **title**, parent_id#(project_thread)) 
     32   (__**id#(embeddable_thread)**, **title**, referenced_by#(project_thread)) 
    3333
    34349. **topic_guidelines** 
     
    3636
    373710. **discussion_thread** 
    38    (__**id#(embeddable_thread)**, **parent_id#(embeddable_thread)**__) 
     38   (__**id#(embeddable_thread)**, **contained_in#(embeddable_thread)**__) 
    3939
    404011. **likes** 
     
    5151
    525215. **blacklisted_user** 
    53    (__**id**__, **user_id#(users)**, **moderator_id#(moderator)**, **topic_id#(topic_thread)**, **start_date**, end_date, reason) 
     53   (__**id**__, **refers_to#(users)**, **blacklisted_by#(moderator)**, **blacklisted_from#(topic_thread)**, **start_date**, end_date, reason) 
    5454
    555516. **developer_associated_with_project** 
    56    (__**project_id#(project_thread)**__, __**developer_id#(developer)**__, __**started_at**__, ended_at) 
     56   (__**in_project#(project_thread)**__, __**about_dev#(developer)**__, __**started_at**__, ended_at) 
    5757
    585817. **permissions** 
     
    6060
    616118. **project_role** 
    62    (__**id**__, **name**, **project_id#(project_thread)**, **override_type**) 
     62   (__**id**__, **name**, **valid_in#(project_thread)**, **override_type**) 
    6363
    646419. **role_permissions** 
    65    (__**permission_name#(permissions)**__, __**role_id#(project_role)**__) 
     65   (__**for_permission#(permissions)**__, __**for_role#(project_role)**__) 
    6666
    676720. **role_permissions_overrides** 
    68    (__**role_id#(project_role)**__, __**permission_name#(permissions)**__, __**channel_id#(channel)**__) 
     68   (__**for_role_permission_role_id#(project_role)**__, __**for_role_permission_permission_name#(permissions)**__, __**for_resource#(channel)**__) 
    6969
    707021. **project_role_is_assigned_to_developer** 
     
    7272
    737322. **submission** 
    74    (__**id**__, **created_at**, **description**, **status**, **created_by#(users)**) 
     74   (__**id**__, **created_at**, **description**, **status**, **submitted_by#(users)**) 
    7575
    767623. **project_request** 
    77    (__**id#(submission)**, **project_id#(project_thread)**__) 
     77   (__**id#(submission)**, **project_recieves#(project_thread)**__) 
    7878
    797924. **feedback** 
    80    (__**submission_id#(submission)**, description, **submission_type**, **created_at**, **created_by#(users)**) 
     80   (__**submitted_for#(submission)**, description, **submission_type**, **created_at**, **written_by#(users)**) 
    8181
    828225. **report** 
    83    (__**id#(submission)**, **thread_id#(topic_thread)**__, **for_user_id#(users)**__) 
     83   (__**id#(submission)**, **for_misconduct_in#(topic_thread)**__, **about#(users)**__) 
    8484
    858526. **channel** 
    86    (__**id**__, **name**, **project_id#(project_thread)**, description, **project_resource_id#(project_resource)**, **developer_id#(developer)**) 
     86   (__**id**__, **name**, **project_has#(project_thread)**, description, **constructed_by#(developer)**) 
    8787
    888827. **messages** 
    89    (__**channel_name#(channel)**__, __**project_id#(project_thread)**__, __**sent_at**__, __**sent_by#(developer)**__, **content**) 
     89   (__**sent_in(channel)**,__**sent_at**__, __**sent_by#(developer)**__, **content**) 
    9090 
    9191