Changes between Version 3 and Version 4 of RelationalDesign


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

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v3 v4  
    11= !Trekr
    2 == Релациско мапирање ===
     2== Релациско мапирање ==
    33
    44=== Ознаки ===
    … …  
    1010
    1111=== Табели ===
    12 1. User ('''user_id, email, username, password''')
     121. User('''user_id, email, username, password''')
    1313
    14 2. FinanceUser ('''user_id*(User), spending_budget, saving_budget, investing_budget, donation_budget, credit''')
     142. FinanceUser('''user_id*(User), spending_budget, saving_budget, investing_budget, donation_budget, credit''')
    1515
    16 3. Income ('''income_id, user_id*(FinanceUser)__, date, amount''')
     163. Income('''income_id, user_id*(FinanceUser)__, date, amount''')
    1717
    18 4. TrainingUser ('''user_id*(User), gender, age, weight''')
     184. TrainingUser('''user_id*(User), gender, age, weight''')
    1919
    20 5. TrainingSession ('''training_id, training_user_id*(TrainingUser), weight_user_id*(WeightUser), duration, calories, date, type''')
     205. TrainingSession('''training_id, training_user_id*(TrainingUser), weight_user_id*(WeightUser), duration, calories, date, type''')
    2121
    22 6. WeightUser ('''user_id*(User), weight, height, goal_weight, goal_calories''')
     226. WeightUser('''user_id*(User), weight, height, goal_weight, goal_calories''')
    2323
    24 7. DailyIntake ('''daily_intake_id, user_id*(WeightUser)__, calories, date''')
     247. DailyIntake('''daily_intake_id, user_id*(WeightUser)__, calories, date''')
    2525
    26 8. DisciplineUser ('''user_id*(User), num_tasks, tasks''')
     268. DisciplineUser('''user_id*(User), num_tasks, tasks''')
    2727
    28 9. CustomTrackingCategory ('''custom_tracking_id, user_id*(User)__, name, num_tasks, tasks''')
     289. CustomTrackingCategory('''custom_tracking_id, user_id*(User)__, name, num_tasks, tasks''')
    2929
    30 10. Task ('''task_id, name, discipline_user_id*(DisciplineUser), custom_tracking_id*(CustomTrackingCategory)''')
     3010. Task('''task_id, name, discipline_user_id*(DisciplineUser), custom_tracking_id*(CustomTrackingCategory)''')
    3131
    32 11. DailyCompletion ('''daily_completion_id, user_id*(User)__, date, procent''')
     3211. DailyCompletion('''daily_completion_id, user_id*(User)__, date, procent''')
    3333
    34 12. TaskDailyCompletion ('''task_id*(Task), daily_completion_id*(DailyCompletion)''')
     3412. TaskDailyCompletion('''task_id*(Task), daily_completion_id*(DailyCompletion)''')
    3535
    36 13. InvestorUser ('''user_id*(User)''')
     3613. InvestorUser('''user_id*(User)''')
    3737
    38 14. Asset ('''asset_id, user_id*(InvestorUser)__, ticker_symbol, buy_price, buy_date''')
     3814. Asset('''asset_id, user_id*(InvestorUser)__, ticker_symbol, buy_price, buy_date''')
    3939
    4040=== DDL скрипта за бришење на табелите и креирање на табелите ===