Changes between Version 11 and Version 12 of RelationalDesign

Timestamp:

01/29/25 14:13:34 (33 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**, 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_owner** (__***id#(users)***__)  
+5. **thread** (__**id**__, content, **user_id#(users)**, created_at)
 
-5. **thread** (__**id**__, content, __**user_id#(users)**__)  
+6. **topic_thread** (**title**, parent_id#(thread), *id#(thread)*)
 
-6. **likes** (__**user_id#(users)**__, __**thread_id#(thread)**__)  
+7. **topic_guidelines** (id, topic_id, description)
 
-7. **topic_threads_moderators** (__**thread_id#(thread)**__, __***user_id#(users)***__)  
+8. **discussion_thread** (**parent_id**, *id#(thread)*)
 
-8. **tag** (__**name**__)  
+9. **project_thread** (**title**, repo_url, *id#(thread)*)
 
-9. **tag_threads** (__**thread_id#(thread)**__, __**tag_name#(tag)**__)  
+10. **likes** (user_id#(users), thread_id#(thread))
 
-10. **topic_thread** (__***id#(thread)***__, **title**, guidelines, parent_topic_id#(thread))  
+11. **topic_threads_moderators** (thread_id#(thread), user_id#(users))
 
-11. **topic_belongs_to_project** (__**topic_id#(thread)**__, __**project_id#(thread)**__)  
+12. **tag** (__**name**__)
 
-12. **blacklisted_user** (__**topic_id#(thread)**__, __**user_id#(users)**__, __**moderator_id#(users)**__, __**start_date**__, end_date, reason)  
+13. **tag_threads** (thread_id#(thread), tag_name#(tag))
 
-13. **project_thread** (__***id#(thread)***__, **title**, repo_url)  
+14. **topic_belongs_to_project** (topic_id#(thread), project_id#(thread))
 
-14. **discussion_thread** (__***id#(thread)***__, **user_id#(users)**, reply_discussion_id#(thread), **topic_id#(thread)**)  
+15. **blacklisted_user** (topic_id#(thread), user_id#(users), moderator_id#(users), start_date, end_date, reason)
 
-15. **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)
 
-16. **permissions** (__**name**__)  
+17. **permissions** (__**name**__)
 
-17. **project_roles** (__**name**__, __**project_id#(thread)**__, description)  
+18. **project_roles** (name, project_id#(thread), description)
 
-18. **users_project_roles** (__**user_id#(users)**__, __**project_id#(thread)**__, __**role_name#(project_roles)**__)  
+19. **users_project_roles** (user_id#(users), project_id, role_name)
 
-19. **project_roles_permissions** (__**permission_name#(permissions)**__, __**role_name#(project_roles)**__, __**project_id#(thread)**__)  
+20. **project_roles_permissions** (permission_name#(permissions), role_name, project_id)
 
-20. **project_request** (__**id**__, description, **status**, **user_id#(users)**, **project_id#(thread)**)  
+21. **submission** (id)
 
-21. **report** (__**id**__, created_at, **description**, status, **thread_id#(thread)**, **for_user_id#(users)**, **by_user_id#(users)**)  
+22. **project_request** (__**id**__, description, **status**, **user_id#(users)**, **project_id#(thread)**, created_at, submission_id)
 
-22. **channel** (__**name**__, description, __***project_id#(thread)***__, **developer#(users)**)  
+23. **feedback** (description, submission_type, created_by, created_at, __**submission_id**__)
 
-23. **messages** (__**sent_at**__, **content**, __***sent_by#(users)***__, __***project_id#(thread)***__, __***channel_name#(channel)***__)  
+24. **report** (id, created_at, **description**, status, thread_id#(thread), for_user_id#(users), by_user_id#(users), submission_id)
 
+25. **channel** (name, description, project_id#(thread), developer_id#(users))
+
+26. **messages** (sent_at, **content**, sent_by#(users), project_id, channel_name)
 
 == DDL скрипта за бришење и креирање на табелите
-[attachment:buildboard-ddl.2.sql]
+[attachment:V1__init_ddl.sql]
 == DML скрипта за полнење на табелите за податоци 
-[attachment:test-data.sql]
+[attachment:V2__add_test_data.sql]
 == Релационен дијаграм
-[[Image(ddl-diagram-cmp.png)]]
+[[Image(ddl-diagram.png)]]