Changes between Version 3 and Version 4 of ERD

Timestamp:

01/13/25 17:04:34 (41 hours ago)

Author:

211585

Comment:

--

ERD

@@ -1 +1 @@
 = Diagram = 
 
+== ERD ==
 [[Image(growbridgeERD.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 **SocialMediaProfile** - 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 **Marketing Request** - information about the user created request to market a specific profile/post
+    Primary Key: RequestID
+        Attributes:
+             Target_Followers - Integer data, optional
+             Target_Likes - Integer data, optional
+             Target_Comments - Integer data, optional
+