Changes between Version 5 and Version 6 of RelationalDesign

Timestamp:

12/28/24 22:10:43 (4 weeks ago)

Author:

226026

Comment:

--

RelationalDesign

@@ -27 +27 @@
 9. **tag_threads** (__**thread_id#(thread)**__, __**tag_name#(tag)**__)  
 
-10. **topic_thread** (__***id#(thread)***__, **title**, guidelines, next_discussion_id, parent_topic_id#(thread))  
+10. **topic_thread** (__***id#(thread)***__, **title**, guidelines, parent_topic_id#(thread))  
 
 11. **topic_belongs_to_project** (__**topic_id#(thread)**__, __**project_id#(thread)**__)  
 
-12. **topic_blacklist** (__**topic_id#(thread)**__, __**user_id#(users)**__, __**moderator_id#(users)**__, __**start_date**__, end_date)  
+12. **blacklisted_user** (__**topic_id#(thread)**__, __**user_id#(users)**__, __**moderator_id#(users)**__, __**start_date**__, end_date, reason)  
 
 13. **project_thread** (__***id#(thread)***__, **title**, repo_url)  
 
-14. **discussion_thread** (__***id#(thread)***__, **user_id#(users)**, reply_discussion_id#(thread), topic_id#(thread))  
+14. **discussion_thread** (__***id#(thread)***__, **user_id#(users)**, reply_discussion_id#(thread), **topic_id#(thread)**)  
 
 15. **developer_associated_with_project** (__**project_id#(thread)**__, __**developer_id#(users)**__, __**started_at**__, ended_at)  
@@ -49 +49 @@
 20. **project_request** (__**id**__, description, **status**, **user_id#(users)**, **project_id#(thread)**)  
 
-21. **report** (__**id**__, created_at, description, status, **thread_id#(thread)**, **for_user_id#(users)**, **by_user_id#(users)**)  
+21. **report** (__**id**__, created_at, **description**, status, **thread_id#(thread)**, **for_user_id#(users)**, **by_user_id#(users)**)  
 
-22. **channel** (__**name**__, description, logo_url, __***project_id#(thread)***__, **developer#(users)**)  
+22. **channel** (__**name**__, description, __***project_id#(thread)***__, **developer#(users)**)  
 
-23. **messages** (__**sent_at**__, content, __***sent_by#(users)***__, __***project_id#(thread)***__, __***channel_name#(channel)***__)  
+23. **messages** (__**sent_at**__, **content**, __***sent_by#(users)***__, __***project_id#(thread)***__, __***channel_name#(channel)***__)  
 
 
 == DDL скрипта за бришење и креирање на табелите
 [attachment:buildboard-ddl.sql]
+== DML скрипта за полнење на табелите за податоци 
+== Историјат 
 
 
+