Changes between Version 17 and Version 18 of RelationalDesign

Timestamp:

05/19/26 13:24:50 (9 days ago)

Author:

233062

Comment:

--

RelationalDesign

@@ -11 +11 @@
 === Табели
 1. User ('''__user_id__, email, password, username''')
-
 2. !FinanceUser ('''__user_id*(User)__, spending_budget, saving_budget, investing_budget, donation_budget, credit''')
-
-3. Income ('''__user_id*(!FinanceUser)__, date, amount, income_id''')
-
+3. Income ('''__income_id__, __user_id*(!FinanceUser)__, date, amount''')
 4. !TrainingUser ('''__user_id*(User)__, gender, age, weight''')
-
-5. !WeightUser ('''__user_id*(User)__, weight , height , goal_weight, goal_calories''')
-
-6. !DailyIntake ('''__user_id*(!WeightUser)__, daily_intake_id, calories, date''')
-
-7. !DisciplineUser ('''__user_id*(User)__, num_tasks, tasks''')
-
-8. !CustomTrackingCategory ('''custom_tracking_id, name, __user_id*(User)__, num_tasks, tasks ''')
-
-9. !TrainingUser ('''__user_id*(User)__, gender, age, weight''')
-
-10. Task ('''__discipline_user_id*(!DisciplineUser)__, __custom_tracking_id*(!CustomTrackingCategory)__, is_finished, name, task_id''')
-
-11. !DailyCompletion ('''daily_completion_id, __user_id*(User)__, date ,procent''')
-
+5. !WeightUser ('''__user_id*(User)__, weight, height, goal_weight, goal_calories''')
+6. !DailyIntake ('''__daily_intake_id__, __user_id*(!WeightUser)__, calories, date''')
+7. !DisciplineUser ('''__user_id*(User)__''')
+8. !CustomTrackingCategory ('''__custom_tracking_id__, __user_id*(User)__, name''')
+9. !TrainingSession ('''__training_id__, __training_user_id*(!TrainingUser)__, duration, calories, date, type''')
+10. Task ('''__task_id__, name, is_finished, discipline_user_id*(!DisciplineUser), custom_tracking_id*(!CustomTrackingCategory)''')
+11. !DailyCompletion ('''__daily_completion_id__, __user_id*(User)__, date, procent''')
 12. !TaskDailyCompletion ('''__task_id*(Task)__, __daily_completion_id*(!DailyCompletion)__''')
-
 13. !InvestorUser ('''__user_id*(User)__''')
-
-14. Asset ('''asset_id, __user_id*(!InvestorUser)__, ticker_symbol, buy_price, buy_date, quantity''')
-
+14. Asset ('''__asset_id__, __user_id*(!InvestorUser)__, ticker_symbol, buy_price, buy_date, quantity''')
 
 === DDL скрипта за бришење на табелите и креирање на табелите ===
-[[html(<a href="https://develop.finki.ukim.mk/projects/trekr/attachment/wiki/RelationalDesign/ddl.2.sql">ddl.sql</a>)]]
+[[html(<a href="https://develop.finki.ukim.mk/projects/trekr/attachment/wiki/RelationalDesign/ddl.sql">ddl.sql</a>)]]
 === DML скрипта за полнење на табелите со податоци
-[[html(<a href="https://develop.finki.ukim.mk/projects/trekr/attachment/wiki/RelationalDesign/dml.2.sql">dml.sql​</a>)]]
+[[html(<a href="https://develop.finki.ukim.mk/projects/trekr/attachment/wiki/RelationalDesign/dml.sql">dml.sql​</a>)]]
 
 == Релациски дијаграм ===