= Diagram = 

== ERD ==
[[Image(growbridgeERD2.jpg)]]

== Data Requirements ==

=== Entities ===
- Entity **User**- information about users

    Primary Key: UserID.

        Attributes:
            Username - String data, mandatory.

            Email - String data, mandatory.

            Password - String data, mandatory.

            Contact_Details - String data, mandatory.

- Entity **Social Media Profile** - information about the users linked social media profiles.

    Primary Key: ProfileID

        Attributes:
             Platform - String data, mandatory

             User_Name - String data, mandatory

             Account_Type - String data, mandatory (ex. public, private..)

             Followers_Count - Integer data, mandatory

- Entity **Post** - information about the post from a certain social media profile.
    
    Primary Key: PostID
        Attributes:

             Content - String data, optional

             Post_Date - DateTime data, optional

             URL - String data, mandatory

             Likes_Count - Integer data, mandatory

             Comments_Count - Integer data, mandatory

- Entity **Profile Marketing Request** - information about the user created request to market a specific profile/post

    Primary Key: RequestID

        Attributes:
             Target_Followers - Integer data, mandatory

             Timeline - DateTime data, mandatory

             Profile_Id - Foreign Key, mandatory

             Date_Created - DateTime data, mandatory

             Status - String data, mandatory

- Entity **Post Marketing Request** - information about the user created request to market a specific profile/post

    Primary Key: RequestID

        Attributes:
             Target_Likes - Integer data, mandatory

             Target_Comments - Integer data, mandatory

             Timeline - DateTime data, mandatory

             Post_ID - Foreign Key, mandatory

             Date_Created - DateTime data, mandatory

             Status - String data, mandatory

- Entity **Service Provider** - information about social media marketing service providers

    Primary Key: providerID

        Attributes:
             Name: String data, mandatory

             Availability_Status: Boolean data, mandatory

             Pricing: Float data, mandatory

             Services_Offered: String data, mandatory

             Contact_Email: String data, mandatory