Changes between Version 16 and Version 17 of Conceptual Design – ER Diagram and Data Requirements
- Timestamp:
- 08/28/25 18:17:44 (5 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Conceptual Design – ER Diagram and Data Requirements
v16 v17 5 5 == Data Requirements 6 6 === Entities === 7 **1. User** - Entity for all users in the system\\7 **1. App User** - Entity for all users in the system\\ 8 8 * user_id – primary key, numeric, required 9 * administrator_id - foreign key, required 9 10 * first_name – text type, required 10 11 * last_name - text type, required … … 24 25 **5. Order**\\ 25 26 * order_id – primary key, numeric, required 27 * user_id - foreign key, required 28 * address_id - foreign key, required 29 * restaurant_id - foreign key, required 30 * deliveryman_id - foreign key, required 26 31 * order_date – date, required 27 * status - text type, required 28 * comment- text type, required 32 * order_status - text type, required 33 * comment - text type, required 34 * total_amount - numeric type 29 35 30 36 … … 46 52 **8. Menu**\\ 47 53 * menu_id- primary key, numeric, required 54 * restaurant_id - foreign key, required 48 55 * name- text type, required 49 56 * created_at - date, required … … 53 60 **9. Restaurant**\\ 54 61 * restaurant_id - primary key, numeric, required 62 * address_id - foreign key, required 55 63 * name - text type, required 56 64 * email - text type, required … … 79 87 **13. Earnings**\\ 80 88 * earning_id - primary key, numeric, required 89 * restaurant_id - foreign key, required 81 90 * date - date, required 82 91 * source - text type, required 83 92 * amount - numeric type, required 84 93 85 86 94 **14. Costs**\\ 87 95 * cost_id- primary key, numeric, required 96 * restaurant_id - foreign key, required 88 97 * date - date, required 89 98 * type - text type, required … … 110 119 111 120 **19. Category**\\ 112 * category_id - primary key, numeric, required121 * category_id - primary key, numeric, required 113 122 * name - text type, required 114 123 * description - text type, required … … 118 127 * category_id - foreign key, required 119 128 120 **21. ItemCategory**\\129 **21. Restaurant Category**\\ 121 130 * restaurant_id - foreign key, required 122 131 * category_id - foreign key, required 132 133 **22. Administrator**\\ 134 * user_id - primary key, numeric, required 135 * authorized_from - date, required 136 * authorized_to - date, required 137 138 **23. Menu Item**\\ 139 * menu_id - foreign key, required 140 * item_id - foreign key, required 123 141 124 142 === Relations===
