Changes between Version 3 and Version 4 of ERModel

Timestamp:

05/04/26 00:32:18 (3 days ago)

Author:

231241

Comment:

--

ERModel

@@ -17 +17 @@
 DESCREPTION OF THE ENTITY/RELATIONSHIP
 
- * **Candidate Keys:**
-   * NAME_OF_KEY (TYPE OF KEY)
+ * **1.User:**
+   * user_id (bigint) - primary key
+   * email (text)
+   * username (bigint)
+   * password (bigint)
+   * date_created (date)
+
+ * **2.Admin:**
+   * type (text)
+   * employee_id (bigint)
+
+ * **3.Consumer:**
+   * telephone_number (text)
+   * shipping_address (text)
+   * points_collected (bigint)
+
+ * **4.Wishlist:**
+   * wishlist_id (bigint) - primary key
+
+ * **5.WishlistItem:**
+   * wishlist_id (bigint) - foreign key(Wishlist)
+   * product_id (bigint) - foreign key(Product)
+   * added_at (date)
+
+ * **6.Product:**
+   * product_id (bigint) - primary key
+   * format (enum)
+   * price (bigint)
+   * description (text)
+   * stock (bigint)
+
+ * **7.Release:**
+   * release_id (bigint) - primary key
+   * title (text)
+   * record_label (text)
+   * genre (text)
+   * release_date (date)
+   * cover_photo (text)
+
+ * **8.Album:**
+
+ * **9.Single:**
+   * duration (text)
+
+ * **10.Artist:**
+   * artist_id (bigint) - primary key
+   * artist_name(text)
+   * description(text)
+   * photo (text)
+
+ * **11.Song:**
+   * song_id(bigint) - primary key
+   * song_name(text)
+   * featured_artist (text)
+   * duration (text)
+
+ * **12.OrderItem:**
+   * order_id (bigint) - foreign key(Order)
+   * product_id (bigint) - foreign key(Product)
+   * price_at_purchase (bigint)
+   * quantity (bigint)
+
+ * **13.Order:**
+   * order_id (bigint) - primary key
+   * payment_method (enum)
+   * purchase_date (date)
+   * points (bigint)
+
+
+
+
  * **Attributes:**
    * NAME_OF_ATTRIBUTE (TYPE, Required/Optional) - DESCREPTION
 
 
+
 == Relationships
+
+ * **1.contains** (Album ↔ Song, M:N)
+   Each Album contains Songs, while the same Song can be in multiple albums.
+
+ * **2.has** (Release ↔ Artist, M:N)
+   Each Artist has multiple releases.
+
+ * **3.version of ** (Release ↔ Product, 1:N)
+   Each Release can be a different Product.
+
+ * **4.refers** (Product ↔ OrderItem, 1:N)
+   Each Product can be an OrderItem multiple times.
+
+ * **5.contains** (OrderItem ↔ Order, N:1)
+   Each Order contains atleast one OrderItem.
+
+ * **6.creates** (Order ↔ User, N:1)
+   Each User can create multiple Orders.
+
+ * **7.creates** (Admin ↔ Product, 1:N)
+   Each Admin can create multiple Products.
+
+ * **8.modifies** (Admin ↔ Product, M:N)
+   Each Admin can modify multiple Products.
+
+ * **9.has** (Consumer ↔ Wishlist, 1:1)
+   Each Consumer can have a Wishlist
+
+ * **10.has** (Wishlist ↔ WishlistItem, 1:N)
+   Each Wishlist can contain multiple WishlistItems.
+
+ * **11.refers** (Wishlist ↔ Product, M:N)
+   Every Product can be a WishlistItem.
+
 
 List all entities and relationships with the following information for each of them
@@ -33 +137 @@
 List of entity attributes, for each of them: the data type (numeric/text/date/…) and whether there are any restrictions in the input form/format (required/optional, special format, value interval, …)
 
+
+
 == Entity-Relationship Model History