Changes between Version 14 and Version 15 of RelationalDesign

Timestamp:

01/29/25 19:18:41 (28 hours ago)

Author:

226026

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)
+5. **thread** (__**id**__, content, **user_id#(users)**, **created_at**)
 
-6. **topic_thread** (**title**, parent_id#(thread), *id#(thread)*)
+6. **topic_thread** (**title**, parent_id#(thread), __**id#(thread)**__)
 
-7. **topic_guidelines** (id, topic_id, description)
+7. **topic_guidelines** (__**id**__, __**topic_id#(topic_thread)**__, description)
 
-8. **discussion_thread** (**parent_id**, *id#(thread)*)
+8. **discussion_thread** (**parent_id**, __**id#(thread)**__)
 
-9. **project_thread** (**title**, repo_url, *id#(thread)*)
+9. **project_thread** (**title**, repo_url, __**id#(thread)**__)
 
-10. **likes** (user_id#(users), thread_id#(thread))
+10. **likes** (__**user_id#(users)**__, __**thread_id#(thread)**__)
 
-11. **topic_threads_moderators** (thread_id#(thread), user_id#(users))
+11. **topic_threads_moderators** (__**thread_id#(thread)**__, __**user_id#(users)**__)
 
 12. **tag** (__**name**__)
 
-13. **tag_threads** (thread_id#(thread), tag_name#(tag))
+13. **tag_threads** (__**thread_id#(thread)**__, __**tag_name#(tag)**__)
 
-14. **topic_belongs_to_project** (topic_id#(thread), project_id#(thread))
+14. **topic_belongs_to_project** (__**topic_id#(thread)**__, __**project_id#(thread)**__)
 
-15. **blacklisted_user** (topic_id#(thread), user_id#(users), moderator_id#(users), start_date, end_date, reason)
+15. **blacklisted_user** (__**topic_id#(thread)**__, __**user_id#(users)**__, __**moderator_id#(users)**__, __**start_date**__, end_date, reason)
 
-16. **developer_associated_with_project** (project_id#(thread), developer_id#(users), started_at, ended_at)
+16. **developer_associated_with_project** (__**project_id#(thread)**__, __**developer_id#(users)**__, __**started_at**__, ended_at)
 
 17. **permissions** (__**name**__)
 
-18. **project_roles** (name, project_id#(thread), description)
+18. **project_roles** (__**name**__, __**project_id#**__(thread), description)
 
-19. **users_project_roles** (user_id#(users), project_id, role_name)
+19. **users_project_roles** (__**user_id#(users)**__, __**project_id#(project_roles)**__, __**role_name#(project_roles)**__)
 
-20. **project_roles_permissions** (permission_name#(permissions), role_name, project_id)
+20. **project_roles_permissions** (__**permission_name#(permissions)**__, __**role_name#(project_roles)**__, __**project_id#(project_roles)**__)
 
-21. **submission** (id)
+21. **submission** (__**id**__)
 
-22. **project_request** (__**id**__, description, **status**, **user_id#(users)**, **project_id#(thread)**, created_at, submission_id)
+22. **project_request** (__**id**__, description, **status**, **user_id#(users)**, **project_id#(thread)**, **created_at**, submission_id#(submission))
 
-23. **feedback** (description, submission_type, created_by, created_at, __**submission_id**__)
+23. **feedback** (description, **submission_type**, created_by#(users), **created_at**, __**submission_id#(submission)**__)
 
-24. **report** (__**id**__, created_at, **description**, status, __**thread_id#(thread)**__, __**for_user_id#(users)**__, __**by_user_id#(users)**__, submission_id)
+24. **report** (__**id**__, **created_at**, **description**, status, __**thread_id#(thread)**__, __**for_user_id#(users)**__, __**by_user_id#(users)**__, submission_id#(submission))
 
 25. **channel** (__**name**__, description, __**project_id#(thread)**__, developer_id#(users))
 
-26. **messages** (__**sent_at__**, **content**, __**sent_by#(users)**__, __**project_id**__, __**channel_name**__)
+26. **messages** (__**sent_at__**, **content**, __**sent_by#(users)**__, __**project_id#(channel)**__, __**channel_name#(channel)**__)
 
 == DDL скрипта за бришење и креирање на табелите