Changes between Version 31 and Version 32 of RelationalDesign
- Timestamp:
- 09/25/25 20:35:55 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v31 v32 21 21 22 22 5. **thread** 23 (__**id**__, content, **created_at**, ** user_id#(users)**)23 (__**id**__, content, **created_at**, **is_created_by#(users)**) 24 24 25 25 6. **project_thread** … … 30 30 31 31 8. **topic_thread** 32 (__**id#(embeddable_thread)**, **title**, parent_id#(project_thread))32 (__**id#(embeddable_thread)**, **title**, referenced_by#(project_thread)) 33 33 34 34 9. **topic_guidelines** … … 36 36 37 37 10. **discussion_thread** 38 (__**id#(embeddable_thread)**, ** parent_id#(embeddable_thread)**__)38 (__**id#(embeddable_thread)**, **contained_in#(embeddable_thread)**__) 39 39 40 40 11. **likes** … … 51 51 52 52 15. **blacklisted_user** 53 (__**id**__, ** user_id#(users)**, **moderator_id#(moderator)**, **topic_id#(topic_thread)**, **start_date**, end_date, reason)53 (__**id**__, **refers_to#(users)**, **blacklisted_by#(moderator)**, **blacklisted_from#(topic_thread)**, **start_date**, end_date, reason) 54 54 55 55 16. **developer_associated_with_project** 56 (__** project_id#(project_thread)**__, __**developer_id#(developer)**__, __**started_at**__, ended_at)56 (__**in_project#(project_thread)**__, __**about_dev#(developer)**__, __**started_at**__, ended_at) 57 57 58 58 17. **permissions** … … 60 60 61 61 18. **project_role** 62 (__**id**__, **name**, ** project_id#(project_thread)**, **override_type**)62 (__**id**__, **name**, **valid_in#(project_thread)**, **override_type**) 63 63 64 64 19. **role_permissions** 65 (__** permission_name#(permissions)**__, __**role_id#(project_role)**__)65 (__**for_permission#(permissions)**__, __**for_role#(project_role)**__) 66 66 67 67 20. **role_permissions_overrides** 68 (__** role_id#(project_role)**__, __**permission_name#(permissions)**__, __**channel_id#(channel)**__)68 (__**for_role_permission_role_id#(project_role)**__, __**for_role_permission_permission_name#(permissions)**__, __**for_resource#(channel)**__) 69 69 70 70 21. **project_role_is_assigned_to_developer** … … 72 72 73 73 22. **submission** 74 (__**id**__, **created_at**, **description**, **status**, ** created_by#(users)**)74 (__**id**__, **created_at**, **description**, **status**, **submitted_by#(users)**) 75 75 76 76 23. **project_request** 77 (__**id#(submission)**, **project_ id#(project_thread)**__)77 (__**id#(submission)**, **project_recieves#(project_thread)**__) 78 78 79 79 24. **feedback** 80 (__**submi ssion_id#(submission)**, description, **submission_type**, **created_at**, **created_by#(users)**)80 (__**submitted_for#(submission)**, description, **submission_type**, **created_at**, **written_by#(users)**) 81 81 82 82 25. **report** 83 (__**id#(submission)**, ** thread_id#(topic_thread)**__, **for_user_id#(users)**__)83 (__**id#(submission)**, **for_misconduct_in#(topic_thread)**__, **about#(users)**__) 84 84 85 85 26. **channel** 86 (__**id**__, **name**, **project_ id#(project_thread)**, description, **project_resource_id#(project_resource)**, **developer_id#(developer)**)86 (__**id**__, **name**, **project_has#(project_thread)**, description, **constructed_by#(developer)**) 87 87 88 88 27. **messages** 89 (__** channel_name#(channel)**__, __**project_id#(project_thread)**__,__**sent_at**__, __**sent_by#(developer)**__, **content**)89 (__**sent_in(channel)**,__**sent_at**__, __**sent_by#(developer)**__, **content**) 90 90 91 91