Changes between Version 13 and Version 14 of Conceptual Design – ER Diagram and Data Requirements
- Timestamp:
- 08/26/25 14:51:32 (7 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Conceptual Design – ER Diagram and Data Requirements
v13 v14 10 10 * last_name - text type, required 11 11 * phone - text type, required 12 * email - text type, required12 * email - text type, required 13 13 * password - text type, required 14 14 … … 81 81 * date - date, required 82 82 * source - text type, required 83 * amount - numeric type, required83 * amount - numeric type, required 84 84 85 85 … … 88 88 * date - date, required 89 89 * type - text type, required 90 * amount - numeric type, required90 * amount - numeric type, required 91 91 92 92 **15. Item Ingredient**\\ … … 107 107 **18. User Addresses**\\ 108 108 * address_id - foreign key, required 109 * user_id- foreign key, required 110 109 * user_id - foreign key, required 110 111 **19. Category**\\ 112 * category_id - primary key, numeric,required 113 * name - text type, required 114 * description - text type, required 115 116 **20. Item Category**\\ 117 * item_id - foreign key, required 118 * category_id - foreign key, required 119 120 **21. Item Category**\\ 121 * restaurant_id - foreign key, required 122 * category_id - foreign key, required 111 123 112 124 === Relations===
