Changes between Version 11 and Version 12 of ERModel
- Timestamp:
- 09/21/26 18:03:06 (8 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ERModel
v11 v12 5 5 6 6 User – сите корисници на целиот систем 7 • email (PK, text, not nullable) 7 • id (PK, bigint, not nullable) 8 • email (text, not nullable) 8 9 • username (text, not nullable) 9 10 • password (text, not nullable) … … 18 19 19 20 Ingredient – сите намирници и состојки 20 • name (PK, text, not nullable) 21 • id (PK, bigint, not nullable) 22 • name (text, not nullable) 21 23 • description (text, not nullable) 22 24 • energy (numeric, not nullable) … … 84 86 Recipe_Contains_Ingeredient 85 87 • recipe_id (FK, bigint, non nullable) 86 • ingredient_ name(FK, text, non nullable)88 • ingredient_id (FK, text, non nullable) 87 89 • ingredient_quantity (numeric, non nullable) 88 • PK (recipe_id, ingredient_ name)90 • PK (recipe_id, ingredient_id) 89 91 90 92 Ingredient_Contains_Nutrient 91 • ingredient_ name(FK, text, non nullable)93 • ingredient_id (FK, text, non nullable) 92 94 • nutrient_id (FK, bigint, non nullable) 93 95 • quantitiy (numeric, non nullable) 94 • PK (ingredient_ name, nutrient_id)96 • PK (ingredient_id, nutrient_id) 95 97 96 98 Recipe_Contains_Restriction … … 106 108 Grocery_List_Single_Add_Ingredient 107 109 • list_id (FK, bigint, non nullable) 108 • ingredient_ name(FK, text, non nullable)110 • ingredient_id (FK, text, non nullable) 109 111 • buy_quantity (numeric, non nullable) 110 • PK (list_id, ingredient_ name)112 • PK (list_id, ingredient_id) 111 113 112 114 Intake_Planner_save_to_list_Post … … 117 119 === Релации 118 120 119 USER createsPOST | 1:N121 RECIPE posts_on POST | 1:N 120 122 121 123 POST has COMMENT | 1:N 122 124 123 USER posts_onCOMMENT | 1:N125 USER add COMMENT | 1:N 124 126 125 127 INTAKE_PLANER save_to_list POST | M:N
