Changes between Version 24 and Version 25 of RelationalDesign

Timestamp:

09/23/25 00:28:27 (9 hours ago)

Author:

225144

Comment:

--

RelationalDesign

@@ -45 +45 @@
 
 13. **tag**  
-   (__**name**__, **creator_id#(moderator)**__)  
+   (__**name**__, **creator_id#(users)**__)  
 
 14. **tag_threads**  
@@ -51 +51 @@
 
 15. **blacklisted_user**  
-   (__**user_id#(users)**__, __**moderator_id#(moderator)**__, __**topic_id#(topic_thread)**__, __**start_date**__, end_date, reason)  
+   (__**id**__, **user_id#(users)**, **moderator_id#(moderator)**, **topic_id#(topic_thread)**, **start_date**, end_date, reason)  
 
 16. **developer_associated_with_project**  
@@ -57 +57 @@
 
 17. **permissions**  
-   (__**name**__)  
+   (__**name**__)   
 
-18. **project_resource**  
-   (__**id**__)  
-
-19. **project_role**  
+18. **project_role**  
    (__**id**__, **name**, **project_id#(project_thread)**, **override_type**)  
 
-20. **role_permissions**  
+19. **role_permissions**  
    (__**permission_name#(permissions)**__, __**role_id#(project_role)**__)  
 
-21. **role_permissions_overrides**  
-   (__**role_id#(project_role)**__, __**permission_name#(permissions)**__, __**project_resource_id#(project_resource)**__)  
+20. **role_permissions_overrides**  
+   (__**role_id#(project_role)**__, __**permission_name#(permissions)**__, __**channel_id#(channel)**__)  
 
-22. **users_project_roles**  
+21. **users_project_roles**  
    (__**user_id#(developer)**__, __**role_id#(project_role)**__)  
 
-23. **submission**  
+22. **submission**  
    (__**id**__, **created_at**, **description**, **status**, **created_by#(users)**)  
 
-24. **project_request**  
+23. **project_request**  
    (__**id#(submission)**, **project_id#(thread)**__)  
 
-25. **feedback**  
+24. **feedback**  
    (__**submission_id#(submission)**, description, **submission_type**, **created_at**, **created_by#(users)**)  
 
-26. **report**  
+25. **report**  
    (__**id#(submission)**, **thread_id#(topic_thread)**__, **for_user_id#(users)**__)  
 
-27. **channel**  
-   (__**name**, __**project_id#(project_thread)**__, description, **project_resource_id#(project_resource)**, **developer_id#(developer)**)  
+26. **channel**  
+   (__**id**__, **name**, **project_id#(project_thread)**, description, **project_resource_id#(project_resource)**, **developer_id#(developer)**)  
 
-28. **messages**  
+27. **messages**  
    (__**channel_name#(channel)**__, __**project_id#(project_thread)**__, __**sent_at**__, __**sent_by#(developer)**__, **content**)