Changes between Version 20 and Version 21 of RelationalDesign

Timestamp:

09/21/25 20:41:08 (37 hours ago)

Author:

225144

Comment:

--

RelationalDesign

@@ -8 +8 @@
 
 === Табели
-1. **users** (__**id**__, **username**, **email**, **name**, **is_activate**, **password**, description, **registered_at**, **sex**)
+1. **users**  
+   (__**id**__, **username**, **email**, **name**, **is_activate**, **password**, description, **registered_at**, **sex**)  
 
-2. **moderator** (__**id#(users)**__)
+2. **moderator**  
+   (__**id#(users)**__)  
 
-3. **developer** (__**id#(users)**__)
+3. **developer**  
+   (__**id#(users)**__)  
 
-4. **project_manager** (__**id#(users)**__)
+4. **project_manager**  
+   (__**id#(users)**__)  
 
-5. **thread** (__**id**__, content, **user_id#(users)**, **created_at**)
-6. **embeddable_thread** (**__id__**#(thread))
+5. **thread**  
+   (__**id**__, content, **created_at**, **user_id#(users)**)  
 
-7. **topic_thread** (**title**, parent_id#(project_thread), __**id#(embeddable_thread)**__)
+6. **project_thread**  
+   (__**id#(thread)**, **title**, repo_url)  
 
-8. **topic_guidelines** (__**id**__, __**topic_id#(topic_thread)**__, description)
+7. **embeddable_thread**  
+   (__**id#(thread)**)  
 
-9. **discussion_thread** (**parent_id**#(embeddable_thread), __**id#(embeddable_thread)**__)
+8. **topic_thread**  
+   (__**id#(embeddable_thread)**, **title**, parent_id#(project_thread))  
 
-10. **project_thread** (**title**, repo_url, __**id#(thread)**__)
+9. **topic_guidelines**  
+   (__**id**__, __**topic_id#(topic_thread)**__, description)  
 
-11. **likes** (__**user_id#(users)**__, __**thread_id#(thread)**__)
+10. **discussion_thread**  
+   (__**id#(embeddable_thread)**, **parent_id#(embeddable_thread)**__)  
 
-12. **topic_threads_moderators** (__**thread_id#(thread)**__, __**user_id#(users)**__,**started_at**)
+11. **likes**  
+   (__**user_id#(users)**__, __**thread_id#(thread)**__)  
 
-13. **tag** (__**name**__,**creator_id**#(moderator))
+12. **topic_threads_moderators**  
+   (__**thread_id#(topic_thread)**__, __**user_id#(moderator)**__, **started_at**)  
 
-14. **tag_threads** (__**thread_id#(thread)**__, __**tag_name#(tag)**__)
+13. **tag**  
+   (__**name**__, **creator_id#(moderator)**__)  
 
-15. **topic_belongs_to_project** (__**topic_id#(thread)**__, __**project_id#(thread)**__)
+14. **tag_threads**  
+   (__**thread_id#(thread)**__, __**tag_name#(tag)**__)  
 
-16. **blacklisted_user** (__**topic_id#(thread)**__, __**user_id#(users)**__, __**moderator_id#(users)**__, __**start_date**__, end_date, reason)
+15. **blacklisted_user**  
+   (__**user_id#(users)**__, __**moderator_id#(moderator)**__, __**topic_id#(topic_thread)**__, __**start_date**__, end_date, reason)  
 
-17. **developer_associated_with_project** (__**project_id#(thread)**__, __**developer_id#(users)**__, __**started_at**__, ended_at)
+16. **developer_associated_with_project**  
+   (__**project_id#(project_thread)**__, __**developer_id#(developer)**__, __**started_at**__, ended_at)  
 
-18. **permissions** (__**name**__)
+17. **permissions**  
+   (__**name**__)  
 
-19. **project_roles** (__**name**__, __**project_id#**__(thread), description)
+18. **project_resource**  
+   (__**id**__)  
 
-20. **users_project_roles** (__**user_id#(users)**__, __**project_id#(project_roles)**__, __**role_name#(project_roles)**__)
+19. **project_role**  
+   (__**id**__, **name**, **project_id#(project_thread)**, **override_type**)  
 
-21. **project_roles_permissions** (__**permission_name#(permissions)**__, __**role_name#(project_roles)**__, __**project_id#(project_roles)**__)
+20. **role_permissions**  
+   (__**permission_name#(permissions)**__, __**role_id#(project_role)**__)  
 
-22. **submission** (__**id**__,**created_at**,description,**status**,**created_by#(users)**)
+21. **role_permissions_overrides**  
+   (__**role_id#(project_role)**__, __**permission_name#(permissions)**__, __**project_resource_id#(project_resource)**__)  
 
-22. **project_request** (__**id**#(submission)__, **project_id#(thread)**))
+22. **users_project_roles**  
+   (__**user_id#(developer)**__, __**role_id#(project_role)**__)  
 
-23. **feedback** (description, **submission_type**, created_by#(users), **created_at**, __**submission_id#(submission)**__)
+23. **submission**  
+   (__**id**__, **created_at**, **description**, **status**, **created_by#(users)**)  
 
-24. **report** (__**id**#(submission)__,  __**thread_id**#(thread)__, __**for_user_id**#(users))
+24. **project_request**  
+   (__**id#(submission)**, **project_id#(thread)**__)  
 
-25. **channel** (__**name**__, description, __**project_id#(thread)**__, **developer_id**#(users))
+25. **feedback**  
+   (__**submission_id#(submission)**, description, **submission_type**, **created_at**, **created_by#(users)**)  
 
-26. **messages** (__**sent_at__**, **content**, __**sent_by#(users)**__, __**project_id#(channel)**__, __**channel_name#(channel)**__)
+26. **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)**)  
+
+28. **messages**  
+   (__**channel_name#(channel)**__, __**project_id#(project_thread)**__, __**sent_at**__, __**sent_by#(developer)**__, **content**)  
+
 
 == DDL скрипта за бришење и креирање на табелите