= Relational Design =

== Signs == 
- Primary keys are indicated by bold and underlined letters
- Mandatory attributes are marked in bold
- Foreign keys are indicated by a # followed by the name of the referenced table, wrapped in (). - attb#(table)
- 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.

= Tables =

== users ==
(**__UserID__**, **Username**, **Email**, **Password**, **Contact_Details**)

== social_media_profile ==
(*ProfileID#(users)*, **Platform**, **User_Name**, **Account_Type**, **Followers_Count**)

== post ==
(*PostID#(social_media_profile)*, Content, Post_Date, **URL**, **Likes_Count**, **Comments_Count**)

== profile_marketing_request ==
(RequestID, **Target_Followers**, **Timeline**, *ProfileID#(social_media_profile)*, **Date_Created**, **Status**, ProviderID#(service_provider))

== post_marketing_request ==
(RequestID, **Target_Likes**, **Target_Comments**, **Timeline**, *PostID#(post)*, **Date_Created**, **Status**, ProviderID#(service_provider))

== service_provider ==
(ProviderID, **Name**, **Availability_Status**, **Pricing**, **Services_Offered**, **Contact_Email**)