Changes between Version 13 and Version 14 of ERModel
- Timestamp:
- 05/04/26 03:14:14 (2 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ERModel
v13 v14 6 6 7 7 **1. User** - Represents any registered person in the system with personal information 8 * __user_id__ (bigint , required)8 * __user_id__ (bigint) 9 9 * email (text, required, unique) 10 10 * username (text, required, unique) … … 15 15 16 16 **2. Admin** - A type of user responsible for managing products and performing modifications 17 * __user_id*__ (bigint) 17 18 * type (enum, required) 18 19 * discount_percentage (numeric, required) 19 20 20 21 **3. Consumer** - A type of user who can purchase products and collect loyalty points 22 * __user_id*__ (bigint) 21 23 * points_collected (bigint, required) 22 24 … … 76 78 * status (enum, required) 77 79 78 **14. Modification** - An action performed by an admin that changes o ne or more products80 **14. Modification** - An action performed by an admin that changes or creates one or more products 79 81 * __modification_id__ (bigint) 80 82 * date_modified (date, required)
