Changes between Version 8 and Version 9 of RelationalDesign
- Timestamp:
- 09/21/26 16:56:05 (8 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v8 v9 9 9 == Табели 10 10 11 **user** ( [ email], username, password, role )11 **user** ( [id], email, username, password, role ) 12 12 13 **ingredient** ( [ name], description, energy, kcal, type )13 **ingredient** ( [id], name, description, energy, kcal, type ) 14 14 15 15 **nutrient** ( [id], quantity, description, unit, type ) … … 17 17 **restriction** ( [id], description, type ) 18 18 19 **recipe** ( [id], user_ email* (user), name, guide, kcal_sum, servings )19 **recipe** ( [id], user_id* (user), name, guide, kcal_sum, servings ) 20 20 21 **post** ( [id], created_by* (user), recipe_id* (recipe), media, media_type, media_name, is_private, is_favourite, status, created_at )21 **post** ( [id], user_id* (user), recipe_id* (recipe), media, media_type, media_name, is_private, is_favourite, status, created_at ) 22 22 23 **comment** ( [id], post_id* (post), created_by* (user), description, created_at )23 **comment** ( [id], post_id* (post), user_id* (user), description, created_at ) 24 24 25 **grocery_list** ( [id], user_ email* (user), date_time, notes, is_bought, kcal )25 **grocery_list** ( [id], user_id* (user), date_time, notes, is_bought, kcal ) 26 26 27 **intake_planner** ( [id], user_ email* (user), date_time, notes, kcal, is_consumed )27 **intake_planner** ( [id], user_id* (user), date_time, notes, kcal, is_consumed ) 28 28 29 **biometrics** ( [id], user_ email* (user), date, weight, height, age, muscle_fat_ratio )29 **biometrics** ( [id], user_id* (user), date, weight, height, age, muscle_fat_ratio ) 30 30 31 **recipe_contains_ingredient** ( [recipe_id* (recipe), ingredient_ name* (ingredient)], ingredient_quantity )31 **recipe_contains_ingredient** ( [recipe_id* (recipe), ingredient_id* (ingredient)], ingredient_quantity ) 32 32 33 **ingredient_contains_nutrient** ( [ingredient_ name* (ingredient), nutrient_id* (nutrient)], quantity )33 **ingredient_contains_nutrient** ( [ingredient_id* (ingredient), nutrient_id* (nutrient)], quantity ) 34 34 35 35 **recipe_contains_restriction** ( [recipe_id* (recipe), restriction_id* (restriction)] ) … … 37 37 **grocery_list_bulk_add_ingredient** ( [list_id* (grocery_list), recipe_id* (recipe)] ) 38 38 39 **grocery_list_single_add_ingredient** ( [list_id* (grocery_list), ingredient_ name* (ingredient)], buy_quantity )39 **grocery_list_single_add_ingredient** ( [list_id* (grocery_list), ingredient_id* (ingredient)], buy_quantity ) 40 40 41 41 **intake_planner_save_to_list_post** ( [planner_id* (intake_planner), post_id* (post)] ) … … 44 44 45 45 1. Примарна верзија: [attachment:ddl_nutritioneer_0.0.sql] 46 2. Финална верзија: [attachment:ddl_nutritioneer_1.0.sql] 46 2. Прва верзија: [attachment:ddl_nutritioneer_1.0.sql] 47 3. Втора верзија: [attachment:ddl_nutritioneer_2_0.sql] 47 48 48 49 == DML Queries 49 50 === Популирање 50 51 1. Примарна верзија: [attachment:dml_nutritioneer_populating_0.1.sql] 51 2. Финална верзија: [attachment:dml_nutritioneer_populating_1.0.sql] 52 2. Прва верзија: [attachment:dml_nutritioneer_populating_1.0.sql] 53 3. Втора верзија: [attachment:dml_nutritioneer_populating_2_0.sql] 52 54 === Калкулации 53 55 1. Примарна верзија: [attachment:dml_nutritioneer_calculations_0.1.sql] 54 2. Финална верзија: [attachment:dml_nutritioneer_calculations_1.0.sql] 56 2. Прва верзија: [attachment:dml_nutritioneer_calculations_1.0.sql] 57 3. Втора верзија: [attachment:dml_nutritioneer_calculations_2_0.sql] 55 58 56 59 == Релационен дијаграм
