Changes between Version 5 and Version 6 of RelationalDesign

Timestamp:

02/04/26 20:06:37 (6 days ago)

Author:

233062

Comment:

--

RelationalDesign

@@ -11 +11 @@
 === Табели
 
-!User ('''user_id, email, username, password''')
+=== Табели
+1. User ('''__user_id__, email, password, username''')
 
-FinanceUser ('''user_id*(!User), spending_budget, saving_budget, investing_budget, donation_budget, credit''')
+2. FinanceUser ('''__user_id*(User)__, spending_budget, saving_budget, investing_budget, donation_budget, credit''')
 
-Income ('''income_id, user_id*(FinanceUser)__, date, amount''')
+3. Income ('''__user_id*(FinanceUser)__,date, amount, income_id''')
 
-TrainingUser ('''user_id*(!User), gender, age, weight''')
+4. TrainingUser ('''__user_id*(User)__, gender, age, weight''')
 
-TrainingSession ('''training_id, training_user_id*(TrainingUser), weight_user_id*(WeightUser), duration, calories, date, type''')
+5. WeightUser ('''__user_id*(User)__, weight , height , goal_weight, goal_calories''')
 
-WeightUser ('''user_id*(!User), weight, height, goal_weight, goal_calories''')
+6. DailyIntake ('''__user_id*(WeightUser)__, daily_intake_id, calories, date''')
 
-DailyIntake ('''daily_intake_id, user_id*(WeightUser)__, calories, date''')
+7. DisciplineUser ('''__user_id*(User)__, num_tasks, tasks''')
 
-DisciplineUser ('''user_id*(!User), num_tasks, tasks''')
+8. CustomTrackingCategory ('''custom_tracking_id, name, user_id*(User), num_tasks, tasks ''')
 
-CustomTrackingCategory ('''custom_tracking_id, user_id*(!User)__, name, num_tasks, tasks''')
+9. TrainingUser ('''__user_id*(User)__, gender, age, weight''')
 
-!Task ('''task_id, name, discipline_user_id*(DisciplineUser), custom_tracking_id*(CustomTrackingCategory)''')
+10. Task ('''__discipline_user_id*(DisciplineUser)__, __custom_tracking_id*(CustomTrackingCategory)__, name, task_id''')
 
-DailyCompletion ('''daily_completion_id, user_id*(!User)__, date, procent''')
+11. DailyCompletion ('''daily_completion_id, __user_id*(User)__, date ,procent''')
 
-TaskDailyCompletion ('''task_id*(!Task), daily_completion_id*(DailyCompletion)__''')
+12. TaskDailyCompletion ('''__task_id*(Task)__, __daily_completion_id*(DailyCompletion)__''')
 
-InvestorUser ('''user_id*(!User)''')
+13. InvestorUser ('''user_id*(User)''')
 
-Asset ('''asset_id, user_id*(InvestorUser)__, ticker_symbol, buy_price, buy_date''')
+14. Asset ('''asset_id, __user_id*(InvestorUser)__, ticker_symbol, buy_price, buy_date''')
+
 
 === DDL скрипта за бришење на табелите и креирање на табелите ===