Changes between Version 10 and Version 11 of ERD


Ignore:
Timestamp:
01/20/25 23:42:08 (35 hours ago)
Author:
211585
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ERD

    v10 v11  
    22
    33== ERD ==
    4 [[Image(ERD.png)]]
     4[[Image(growbridgeERD2.jpg)]]
    55
    66== Data Requirements ==
    … …  
    9797=== 1-1 Relations ===
    9898
    99 - **Targets** - Relation between Profile Marketing Request and Social Media Profile. Every ProfileMarketingRequest targets a single SocialMediaProfile, and every SocialMediaProfile can be targeted by only one ProfileMarketingRequest. Total Participation of ProfileMarketingRequest and partial participation of SocialMediaProfile.
     99- **targetsProfile** - Relation between Profile Marketing Request and Social Media Profile. Every ProfileMarketingRequest targets a single SocialMediaProfile, and every SocialMediaProfile can be targeted by only one ProfileMarketingRequest. Total Participation of ProfileMarketingRequest and partial participation of SocialMediaProfile.
    100100
    101 - **Targets** - Relation between Post Marketing Request and Post. Every PostMarktingRequest targets a single Post, and every Post can be targeted by only one PostMarketingRequest. Total Participation of PostMarketingRequest and partial participation of Post
     101- **targetsPost** - Relation between Post Marketing Request and Post. Every PostMarktingRequest targets a single Post, and every Post can be targeted by only one PostMarketingRequest. Total Participation of PostMarketingRequest and partial participation of Post
    102102
    103103=== 1-N Relations ===
    104 - **Creates** - Relation between User and ProfileMarketingRequest. One User can create many ProfileMarketingRequests, and a specific ProfileMarketing Request is always created by only one User. Total participation of ProfileMarketing Request and partial participation of User.
     104- **createsProfileMarketingRequest** - Relation between User and ProfileMarketingRequest. One User can create many ProfileMarketingRequests, and a specific ProfileMarketing Request is always created by only one User. Total participation of ProfileMarketing Request and partial participation of User.
    105105
    106 - **Creates** - Relation between User and PostMarketingRequest. One User can create many PostMarketingRequests, and a specific PostMarketingRequest is always created by only one User. Total participation of PostMarketingRequest and partial participation of User.
     106- **createsPostMarketingRequest** - Relation between User and PostMarketingRequest. One User can create many PostMarketingRequests, and a specific PostMarketingRequest is always created by only one User. Total participation of PostMarketingRequest and partial participation of User.
    107107
    108 - **Has** - Relation between SocialMediaProfile and Post. Each SocialMediaProfile can have many Posts, but each Post only belongs to one SocialMediaProfial. Total participation of Post and partial participation of SocialMediaProfile.
     108- **has** - Relation between SocialMediaProfile and Post. Each SocialMediaProfile can have many Posts, but each Post only belongs to one SocialMediaProfial. Total participation of Post and partial participation of SocialMediaProfile.
    109109
    110 - **Handled by** - Relation between ProfileMarketingRequest and ServiceProvider. Each ProfileMarketingRequest can be handled by one ServiceProvider, while a ServiceProvider can handle many ProfileMarketingRequests. Total participation of ProfileMarketingRequest, partial participation of ServiceProvider.
     110- **handlesProfileRequest** - Relation between ProfileMarketingRequest and ServiceProvider. Each ProfileMarketingRequest can be handled by one ServiceProvider, while a ServiceProvider can handle many ProfileMarketingRequests. Total participation of ProfileMarketingRequest, partial participation of ServiceProvider.
    111111
    112 - **Handled by** - Relation between PostMarketingRequest and ServiceProvider. Each PostMarketingRequest can be handled by one ServiceProvider, while a ServiceProvider can handle many PostMarketingRequests. Total participation of PostMarketingRequest, partial participation of ServiceProvider.
     112- **handlesPostRequest** - Relation between PostMarketingRequest and ServiceProvider. Each PostMarketingRequest can be handled by one ServiceProvider, while a ServiceProvider can handle many PostMarketingRequests. Total participation of PostMarketingRequest, partial participation of ServiceProvider.
    113113
    114 - **Links** - Relation between User and SocialMediaProfile. Each User can link many SocialMediaProfiles, while each SocialMediaProfile can be linked to only one user. Total Participation of SocialMediaProfile, partial participation of User
     114- **links** - Relation between User and SocialMediaProfile. Each User can link many SocialMediaProfiles, while each SocialMediaProfile can be linked to only one user. Total Participation of SocialMediaProfile, partial participation of User