Changes between Version 4 and Version 5 of RelationalDesign


Ignore:
Timestamp:
02/04/26 19:49:49 (6 days ago)
Author:
233062
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v4 v5  
    99Задолжителните атрибути се '''болдирани.'''
    1010
    11 === Табели ===
    12 1. User('''user_id, email, username, password''')
     11=== Табели
    1312
    14 2. FinanceUser('''user_id*(User), spending_budget, saving_budget, investing_budget, donation_budget, credit''')
     13!User ('''user_id, email, username, password''')
    1514
    16 3. Income('''income_id, user_id*(FinanceUser)__, date, amount''')
     15FinanceUser ('''user_id*(!User), spending_budget, saving_budget, investing_budget, donation_budget, credit''')
    1716
    18 4. TrainingUser('''user_id*(User), gender, age, weight''')
     17Income ('''income_id, user_id*(FinanceUser)__, date, amount''')
    1918
    20 5. TrainingSession('''training_id, training_user_id*(TrainingUser), weight_user_id*(WeightUser), duration, calories, date, type''')
     19TrainingUser ('''user_id*(!User), gender, age, weight''')
    2120
    22 6. WeightUser('''user_id*(User), weight, height, goal_weight, goal_calories''')
     21TrainingSession ('''training_id, training_user_id*(TrainingUser), weight_user_id*(WeightUser), duration, calories, date, type''')
    2322
    24 7. DailyIntake('''daily_intake_id, user_id*(WeightUser)__, calories, date''')
     23WeightUser ('''user_id*(!User), weight, height, goal_weight, goal_calories''')
    2524
    26 8. DisciplineUser('''user_id*(User), num_tasks, tasks''')
     25DailyIntake ('''daily_intake_id, user_id*(WeightUser)__, calories, date''')
    2726
    28 9. CustomTrackingCategory('''custom_tracking_id, user_id*(User)__, name, num_tasks, tasks''')
     27DisciplineUser ('''user_id*(!User), num_tasks, tasks''')
    2928
    30 10. Task('''task_id, name, discipline_user_id*(DisciplineUser), custom_tracking_id*(CustomTrackingCategory)''')
     29CustomTrackingCategory ('''custom_tracking_id, user_id*(!User)__, name, num_tasks, tasks''')
    3130
    32 11. DailyCompletion('''daily_completion_id, user_id*(User)__, date, procent''')
     31!Task ('''task_id, name, discipline_user_id*(DisciplineUser), custom_tracking_id*(CustomTrackingCategory)''')
    3332
    34 12. TaskDailyCompletion('''task_id*(Task), daily_completion_id*(DailyCompletion)''')
     33DailyCompletion ('''daily_completion_id, user_id*(!User)__, date, procent''')
    3534
    36 13. InvestorUser('''user_id*(User)''')
     35TaskDailyCompletion ('''task_id*(!Task), daily_completion_id*(DailyCompletion)__''')
    3736
    38 14. Asset('''asset_id, user_id*(InvestorUser)__, ticker_symbol, buy_price, buy_date''')
     37InvestorUser ('''user_id*(!User)''')
     38
     39Asset ('''asset_id, user_id*(InvestorUser)__, ticker_symbol, buy_price, buy_date''')
    3940
    4041=== DDL скрипта за бришење на табелите и креирање на табелите ===