Changes between Version 3 and Version 4 of RelationalDesign

Timestamp:

09/14/26 15:19:33 (2 weeks ago)

Author:

201165

Comment:

--

RelationalDesign

@@ -1 +1 @@
 = Nutritioneer | Логички и физички дизајн - DDL
 
-== Номенклатура и легенда на записите
+== Номенклатура и нотација на записите
 
-тест тест
+1. **Примарните клучеви** се //[заградени]//
+2. **Надворешните клучеви** се со суфикс '*' и проследени од нивната релациска точка
 
-== SQL DDL Queries 
+
+== Табели
+
+**user** ( [email], username, password, role )
+
+**ingredient** ( [name], description, energy, kcal, type )
+
+**nutrient** ( [id], quantity, description, unit, type )
+
+**restriction** ( [id], description, type )
+
+**recipe** ( [id], user_email* (user), name, guide, kcal_sum, servings )
+
+**post** ( [id], created_by* (user), recipe_id* (recipe), media, media_type, media_name, is_private, is_favourite, status, created_at )
+
+**comment** ( [id], post_id* (post), created_by* (user), description, created_at )
+
+**grocery_list** ( [id], user_email* (user), date_time, notes, is_bought, kcal )
+
+**intake_planner** ( [id], user_email* (user), date_time, notes, kcal, is_consumed )
+
+**biometrics** ( [id], user_email* (user), date, weight, height, age, muscle_fat_ratio )
+
+**recipe_contains_ingredient** ( [recipe_id* (recipe), ingredient_name* (ingredient)], ingredient_quantity )
+
+**ingredient_contains_nutrient** ( [ingredient_name* (ingredient), nutrient_id* (nutrient)], quantity )
+
+**recipe_contains_restriction** ( [recipe_id* (recipe), restriction_id* (restriction)] )
+
+**grocery_list_bulk_add_ingredient** ( [list_id* (grocery_list), recipe_id* (recipe)] )
+
+**grocery_list_single_add_ingredient** ( [list_id* (grocery_list), ingredient_name* (ingredient)], buy_quantity )
+
+**intake_planner_save_to_list_post** ( [planner_id* (intake_planner), post_id* (post)] )
+
+== DDL Queries 
 
 S Q L
+
+== DML Queries
 
 == Релационен дијаграм