Changes between Version 4 and Version 5 of ERModel


Ignore:
Timestamp:
05/04/26 02:09:46 (3 days ago)
Author:
232012
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ERModel

    v4 v5  
    1717DESCREPTION OF THE ENTITY/RELATIONSHIP
    1818
    19  * **1.User:**
     19 * **Attributes:**
     20   * NAME_OF_ATTRIBUTE (TYPE, Required/Optional) - DESCREPTION
     21
     22
     23
     24**1.User:**
    2025   * user_id (bigint) - primary key
    2126   * email (text)
    … …  
    2429   * date_created (date)
    2530
    26  * **2.Admin:**
     31**2.Admin:**
    2732   * type (text)
    2833   * employee_id (bigint)
    2934
    30  * **3.Consumer:**
     35**3.Consumer**
     36* **Candidate Keys**
    3137   * telephone_number (text)
    3238   * shipping_address (text)
    3339   * points_collected (bigint)
    3440
    35  * **4.Wishlist:**
     41**4.Wishlist:**
     42* **Candidate Keys**
    3643   * wishlist_id (bigint) - primary key
    3744
    38  * **5.WishlistItem:**
     45**5.WishlistItem:**
     46* **Candidate Keys**
    3947   * wishlist_id (bigint) - foreign key(Wishlist)
    4048   * product_id (bigint) - foreign key(Product)
    4149   * added_at (date)
    4250
    43  * **6.Product:**
     51**6.Product:**
     52* **Candidate Keys**
    4453   * product_id (bigint) - primary key
    4554   * format (enum)
    … …  
    4857   * stock (bigint)
    4958
    50  * **7.Release:**
     59**7.Release:**
     60* **Candidate Keys**
    5161   * release_id (bigint) - primary key
    5262   * title (text)
    … …  
    5666   * cover_photo (text)
    5767
    58  * **8.Album:**
     68**8.Album:**
     69* **Candidate Keys**
    5970
    60  * **9.Single:**
     71**9.Single:**
     72* **Candidate Keys**
    6173   * duration (text)
    6274
    63  * **10.Artist:**
     75**10.Artist:**
     76* **Candidate Keys**
    6477   * artist_id (bigint) - primary key
    6578   * artist_name(text)
    … …  
    6780   * photo (text)
    6881
    69  * **11.Song:**
     82**11.Song:**
     83* **Candidate Keys**
    7084   * song_id(bigint) - primary key
    7185   * song_name(text)
    … …  
    7387   * duration (text)
    7488
    75  * **12.OrderItem:**
     89**12.OrderItem:**
     90* **Candidate Keys**
    7691   * order_id (bigint) - foreign key(Order)
    7792   * product_id (bigint) - foreign key(Product)
    … …  
    7994   * quantity (bigint)
    8095
    81  * **13.Order:**
     96**13.Order**
     97* **Candidate Keys**
    8298   * order_id (bigint) - primary key
     99* **Attributes:**
    83100   * payment_method (enum)
    84101   * purchase_date (date)
    85102   * points (bigint)
    86 
    87 
    88 
    89 
    90  * **Attributes:**
    91    * NAME_OF_ATTRIBUTE (TYPE, Required/Optional) - DESCREPTION
    92 
    93 
    94103
    95104== Relationships
    … …  
    128137   Every Product can be a WishlistItem.
    129138
    130 
    131 List all entities and relationships with the following information for each of them
    132 
    133 Entity/relationship name: one paragraph of explanation, what does the entity/relationship represent, why it is needed, why is it modeled the way it is
    134 
    135 Candidate keys: If you have multiple candidates for the primary key, list them and explain which one you chose as the primary key and why you chose it as the primary key
    136 
    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, …)
    138 
    139 
    140 
    141139== Entity-Relationship Model History
    142140