Changes between Version 17 and Version 18 of RelationalDesign

Timestamp:

02/12/25 17:59:43 (10 days ago)

Author:

225144

Comment:

--

RelationalDesign

@@ -17 +17 @@
 
 5. **thread** (__**id**__, content, **user_id#(users)**, **created_at**)
+6. **embeddable_thread** (**__id__**#(thread))
 
-6. **topic_thread** (**title**, parent_id#(thread), __**id#(thread)**__)
+7. **topic_thread** (**title**, parent_id#(project_thread), __**id#(embeddable_thread)**__)
 
-7. **topic_guidelines** (__**id**__, __**topic_id#(topic_thread)**__, description)
+8. **topic_guidelines** (__**id**__, __**topic_id#(topic_thread)**__, description)
 
-8. **discussion_thread** (**parent_id**, __**id#(thread)**__)
+9. **discussion_thread** (**parent_id**#(embeddable_thread), __**id#(embeddable_thread)**__)
 
-9. **project_thread** (**title**, repo_url, __**id#(thread)**__)
+10. **project_thread** (**title**, repo_url, __**id#(thread)**__)
 
-10. **likes** (__**user_id#(users)**__, __**thread_id#(thread)**__)
+11. **likes** (__**user_id#(users)**__, __**thread_id#(thread)**__)
 
-11. **topic_threads_moderators** (__**thread_id#(thread)**__, __**user_id#(users)**__,started_at)
+12. **topic_threads_moderators** (__**thread_id#(thread)**__, __**user_id#(users)**__,**started_at**)
 
-12. **tag** (__**name**__,**creator_id**#(users))
+13. **tag** (__**name**__,**creator_id**#(moderator))
 
-13. **tag_threads** (__**thread_id#(thread)**__, __**tag_name#(tag)**__)
+14. **tag_threads** (__**thread_id#(thread)**__, __**tag_name#(tag)**__)
 
-14. **topic_belongs_to_project** (__**topic_id#(thread)**__, __**project_id#(thread)**__)
+15. **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)
+16. **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)
+17. **developer_associated_with_project** (__**project_id#(thread)**__, __**developer_id#(users)**__, __**started_at**__, ended_at)
 
-17. **permissions** (__**name**__)
+18. **permissions** (__**name**__)
 
-18. **project_roles** (__**name**__, __**project_id#**__(thread), description)
+19. **project_roles** (__**name**__, __**project_id#**__(thread), description)
 
-19. **users_project_roles** (__**user_id#(users)**__, __**project_id#(project_roles)**__, __**role_name#(project_roles)**__)
+20. **users_project_roles** (__**user_id#(users)**__, __**project_id#(project_roles)**__, __**role_name#(project_roles)**__)
 
-20. **project_roles_permissions** (__**permission_name#(permissions)**__, __**role_name#(project_roles)**__, __**project_id#(project_roles)**__)
+21. **project_roles_permissions** (__**permission_name#(permissions)**__, __**role_name#(project_roles)**__, __**project_id#(project_roles)**__)
 
-21. **submission** (__**id**__,**created_at**,description,**status**,**created_by#(users)**)
+22. **submission** (__**id**__,**created_at**,description,**status**,**created_by#(users)**)
 
 22. **project_request** (__**id**#(submission)__, **project_id#(thread)**))