Changes between Version 1 and Version 2 of RelationalDesign
- Timestamp:
- 01/14/25 19:17:36 (15 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v1 v2 5 5 - Mandatory attributes are marked in bold 6 6 - Foreign keys are indicated by a # followed by the name of the referenced table, wrapped in (). - attb#(table) 7 - Inheritance is indicated by the inherited primary key wrapped with "*" only in the first occurrence of the table, then in subsequent occurrences the primary key of the base class is referenced.8 7 9 8 = Tables = 10 9 11 == users == 12 (**__UserID__**, **Username**, **Email**, **Password**, **Contact_Details**) 10 user (**__UserID__**, **Username**, **Email**, **Password**, **Contact_Details**) 13 11 14 == social_media_profile == 15 (*ProfileID#(users)*, **Platform**, **User_Name**, **Account_Type**, **Followers_Count**) 12 social_media_profile (**__ProfileID__**, **Platform**, **User_Name**, **Account_Type**, **Followers_Count**, **UserID#(user)**) 16 13 17 == post == 18 (*PostID#(social_media_profile)*, Content, Post_Date, **URL**, **Likes_Count**, **Comments_Count**) 14 post (**__PostID__**, Content, Post_Date, **URL**, **Likes_Count**, **Comments_Count**, **ProfileID#(social_media_profile)**) 19 15 20 == profile_marketing_request == 21 (RequestID, **Target_Followers**, **Timeline**, *ProfileID#(social_media_profile)*, **Date_Created**, **Status**, ProviderID#(service_provider)) 16 profile_marketing_request (**__RequestID__**, **Target_Followers**, **Timeline**, **Date_Created**, **Status**, **ProfileID#(social_media_profile)**, **ProviderID#(service_provider)**) 22 17 23 == post_marketing_request == 24 (RequestID, **Target_Likes**, **Target_Comments**, **Timeline**, *PostID#(post)*, **Date_Created**, **Status**, ProviderID#(service_provider)) 18 post_marketing_request (**__RequestID__**, **Target_Likes**, **Target_Comments**, **Timeline**, **Date_Created**, **Status**, **PostID#(post)**, **ProviderID#(service_provider)**) 25 19 26 == service_provider == 27 (ProviderID, **Name**, **Availability_Status**, **Pricing**, **Services_Offered**, **Contact_Email**) 20 service_provider (**__ProviderID__**, **Name**, **Availability_Status**, **Pricing**, **Services_Offered**, **Contact_Email**)
