Changes between Version 4 and Version 5 of RelationalDesign
- Timestamp:
- 02/04/26 19:49:49 (6 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v4 v5 9 9 Задолжителните атрибути се '''болдирани.''' 10 10 11 === Табели === 12 1. User('''user_id, email, username, password''') 11 === Табели 13 12 14 2. FinanceUser('''user_id*(User), spending_budget, saving_budget, investing_budget, donation_budget, credit''')13 !User ('''user_id, email, username, password''') 15 14 16 3. Income('''income_id, user_id*(FinanceUser)__, date, amount''')15 FinanceUser ('''user_id*(!User), spending_budget, saving_budget, investing_budget, donation_budget, credit''') 17 16 18 4. TrainingUser('''user_id*(User), gender, age, weight''')17 Income ('''income_id, user_id*(FinanceUser)__, date, amount''') 19 18 20 5. TrainingSession('''training_id, training_user_id*(TrainingUser), weight_user_id*(WeightUser), duration, calories, date, type''')19 TrainingUser ('''user_id*(!User), gender, age, weight''') 21 20 22 6. WeightUser('''user_id*(User), weight, height, goal_weight, goal_calories''')21 TrainingSession ('''training_id, training_user_id*(TrainingUser), weight_user_id*(WeightUser), duration, calories, date, type''') 23 22 24 7. DailyIntake('''daily_intake_id, user_id*(WeightUser)__, calories, date''')23 WeightUser ('''user_id*(!User), weight, height, goal_weight, goal_calories''') 25 24 26 8. DisciplineUser('''user_id*(User), num_tasks, tasks''')25 DailyIntake ('''daily_intake_id, user_id*(WeightUser)__, calories, date''') 27 26 28 9. CustomTrackingCategory('''custom_tracking_id, user_id*(User)__, name, num_tasks, tasks''')27 DisciplineUser ('''user_id*(!User), num_tasks, tasks''') 29 28 30 10. Task('''task_id, name, discipline_user_id*(DisciplineUser), custom_tracking_id*(CustomTrackingCategory)''')29 CustomTrackingCategory ('''custom_tracking_id, user_id*(!User)__, name, num_tasks, tasks''') 31 30 32 11. DailyCompletion('''daily_completion_id, user_id*(User)__, date, procent''')31 !Task ('''task_id, name, discipline_user_id*(DisciplineUser), custom_tracking_id*(CustomTrackingCategory)''') 33 32 34 12. TaskDailyCompletion('''task_id*(Task), daily_completion_id*(DailyCompletion)''')33 DailyCompletion ('''daily_completion_id, user_id*(!User)__, date, procent''') 35 34 36 13. InvestorUser('''user_id*(User)''')35 TaskDailyCompletion ('''task_id*(!Task), daily_completion_id*(DailyCompletion)__''') 37 36 38 14. Asset('''asset_id, user_id*(InvestorUser)__, ticker_symbol, buy_price, buy_date''') 37 InvestorUser ('''user_id*(!User)''') 38 39 Asset ('''asset_id, user_id*(InvestorUser)__, ticker_symbol, buy_price, buy_date''') 39 40 40 41 === DDL скрипта за бришење на табелите и креирање на табелите ===
