Changes between Version 6 and Version 7 of ERD


Ignore:
Timestamp:
01/13/25 17:20:56 (41 hours ago)
Author:
211585
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ERD

    v6 v7  
    2020            Contact_Details - String data, mandatory.
    2121
    22 - Entity **SocialMediaProfile** - information about the users linked social media profiles.
     22- Entity **Social Media Profile** - information about the users linked social media profiles.
    2323
    2424    Primary Key: ProfileID
     25
    2526        Attributes:
    26      
    2727             Platform - String data, mandatory
    2828
    … …  
    4848             Comments_Count - Integer data, mandatory
    4949
    50 - Entity **Marketing Request** - information about the user created request to market a specific profile/post
     50- Entity **Profile Marketing Request** - information about the user created request to market a specific profile/post
     51
    5152    Primary Key: RequestID
     53
    5254        Attributes:
    53              Target_Followers - Integer data, optional
    54              Target_Likes - Integer data, optional
    55              Target_Comments - Integer data, optional
    56              
     55             Target_Followers - Integer data, mandatory
     56
     57             Timeline - DateTime data, mandatory
     58
     59             Profile_Id - Foreign Key, mandatory
     60
     61             Date_Created - DateTime data, mandatory
     62
     63             Status - String data, mandatory
     64
     65- Entity **Post Marketing Request** - information about the user created request to market a specific profile/post
     66
     67    Primary Key: RequestID
     68
     69        Attributes:
     70             Target_Likes - Integer data, mandatory
     71
     72             Target_Comments - Integer data, mandatory
     73
     74             Timeline - DateTime data, mandatory
     75
     76             Post_ID - Foreign Key, mandatory
     77
     78             Date_Created - DateTime data, mandatory
     79
     80             Status - String data, mandatory
     81
     82- Entity **Service Provider** - information about social media marketing service providers
     83
     84    Primary Key: providerID
     85
     86        Attributes:
     87             Name: String data, mandatory
     88
     89             Availability_Status: Boolean data, mandatory
     90
     91             Pricing: Float data, mandatory
     92
     93             Services_Offered: String data, mandatory
     94
     95             Contact_Email: String data, mandatory