Changes between Version 35 and Version 36 of ERModel


Ignore:
Timestamp:
05/27/26 23:15:22 (7 hours ago)
Author:
232012
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ERModel

    v35 v36  
    2626   * __wishlist_id__ (bigint)
    2727
    28 **5. !WishlistItem** - A specific product added to a wishlist
    29    * __wishlist_id*__ (bigint)
    30    * __product_id*__ (bigint)
    31    * added_at (date, required)
    32 
    33 **6. Product** - A purchasable item with price, stock, and format
     28**5. Product** - A purchasable item with price, stock, and format
    3429   * __product_id__ (bigint)
    3530   * format (enum, required)
    … …  
    3833   * stock (bigint, required)
    3934
    40 **7. Release** - A musical work that groups different product formats
     35**6. Release** - A musical work that groups different product formats
    4136   * __release_id__ (bigint)
    4237   * title (text, required)
    … …  
    4641   * cover_photo (text, required)
    4742
    48 **8. Album** - A type of release consisting of multiple songs
     43**7. Album** - A type of release consisting of multiple songs
    4944   * __release_id*__ (bigint)
    5045
    51 **9. Single** - A type of release typically representing a single track
     46**8. Single** - A type of release typically representing a single track
    5247   * __release_id*__ (bigint)
    5348   * duration (text, required)
    5449
    55 **10. Artist** - A creator or performer associated with releases and songs
     50**9. Artist** - A creator or performer associated with releases and songs
    5651   * __artist_id__ (bigint)
    5752   * artist_name(text, required)
    … …  
    5954   * artist_photo (text, optional)
    6055
    61 **11. Song** - An individual track that can belong to albums
     56**10. Song** - An individual track that can belong to albums
    6257   * __song_id__ (bigint)
    6358   * song_name(text, required)
    6459   * song_duration (text, required)
    6560
    66 **12. !OrderItem ** - A specific product entry within an order
    67    * __order_id*__ (bigint)
    68    * __product_id*__ (bigint)
    69    * price_at_purchase (numeric, required)
    70    * quantity (bigint, required)
    71 
    72 **13. Order ** - A transaction made by a user containing purchased products
     61**11. Order ** - A transaction made by a user containing purchased products
    7362   * __order_id__ (bigint)
    7463   * payment_method (enum, required)
    … …  
    7867   * status (enum, required)
    7968
    80 **14. Modification** - An action performed by an admin that changes or creates one or more products
     69**12. Modification** - An action performed by an admin that changes or creates one or more products
    8170   * __modification_id__ (bigint)
    8271   * date_modified (date, required)
    … …  
    10291 Each Product represents a specific format of one Release, while a Release can have multiple Products.
    10392
    104 **5. refers** (!OrderItem ↔ Product, N:1)\\
    105  Each !OrderItem refers to one Product, while a Product can appear in multiple !OrderItems.
     93**5. contains** (Order ↔ Product, N:M)\\
     94 Each Order contains multiple Products, while each Product can belong to multiple Orders.
    10695
    107 **6. contains** (Order ↔ !OrderItem, 1:N)\\
    108  Each Order contains multiple !OrderItems, while each !OrderItem belongs to exactly one Order.
     96**Attributes:** quantity, price_at_purchase
    10997
    110 **7. creates** (User ↔ Order, 1:N)\\
     98**6. creates** (User ↔ Order, 1:N)\\
    11199 Each User can create multiple Orders, while each Order is created by exactly one User.
    112100
    113 **8. performs** (Admin ↔ Modification, 1:N)\\
     101**7. performs** (Admin ↔ Modification, 1:N)\\
    114102 Each Admin can perform multiple Modifications, while each Modification is performed by exactly one Admin.
    115103
    116 **9. refers **(Modification ↔ Product, M:N)\\
     104**8. refers **(Modification ↔ Product, M:N)\\
    117105 Each Modification can affect multiple Products, while each Product can be affected by multiple Modifications.
    118106
    119 **10. has **(User ↔ Wishlist, 1:1)\\
     107**9. has **(User ↔ Wishlist, 1:1)\\
    120108 Each User has exactly one Wishlist, and each Wishlist belongs to exactly one User.
    121109
    122 **11. has ** (Wishlist ↔ !WishlistItem, 1:N)\\
    123  Each Wishlist contains multiple !WishlistItems, while each !WishlistItem belongs to exactly one Wishlist.
     110**10. contains** (Whishlist ↔ Product, N:M)\\
     111 Each Whislist contains multiple Products, while each Product can belong to multiple Wishlists.
    124112
    125 **12. refers ** (!WishlistItem ↔ Product, N:1)\\
    126  Each !WishlistItem refers to one Product, while a Product can appear in multiple !WishlistItems.
     113**Attributes:** quantity, price_at_purchase
    127114
    128115== Entity-Relationship Model History