Changes between Version 18 and Version 19 of RelationalDesign


Ignore:
Timestamp:
05/19/26 13:26:05 (9 days ago)
Author:
233062
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v18 v19  
    1010
    1111=== Табели
    12 1. User ('''__user_id__, email, password, username''')
    13 2. !FinanceUser ('''__user_id*(User)__, spending_budget, saving_budget, investing_budget, donation_budget, credit''')
    14 3. Income ('''__income_id__, __user_id*(!FinanceUser)__, date, amount''')
    15 4. !TrainingUser ('''__user_id*(User)__, gender, age, weight''')
    16 5. !WeightUser ('''__user_id*(User)__, weight, height, goal_weight, goal_calories''')
    17 6. !DailyIntake ('''__daily_intake_id__, __user_id*(!WeightUser)__, calories, date''')
    18 7. !DisciplineUser ('''__user_id*(User)__''')
    19 8. !CustomTrackingCategory ('''__custom_tracking_id__, __user_id*(User)__, name''')
    20 9. !TrainingSession ('''__training_id__, __training_user_id*(!TrainingUser)__, duration, calories, date, type''')
    21 10. Task ('''__task_id__, name, is_finished, discipline_user_id*(!DisciplineUser), custom_tracking_id*(!CustomTrackingCategory)''')
    22 11. !DailyCompletion ('''__daily_completion_id__, __user_id*(User)__, date, procent''')
    23 12. !TaskDailyCompletion ('''__task_id*(Task)__, __daily_completion_id*(!DailyCompletion)__''')
    24 13. !InvestorUser ('''__user_id*(User)__''')
    25 14. Asset ('''__asset_id__, __user_id*(!InvestorUser)__, ticker_symbol, buy_price, buy_date, quantity''')
     121. User (__user_id__, **email**, **password**, **username**)
     13
     142. !FinanceUser (__user_id**(User)**__, spending_budget, saving_budget, investing_budget, donation_budget, credit)
     15
     163. Income (__income_id__, **user_id*(FinanceUser)***, **date**, **amount**)
     17
     184. !TrainingUser (__user_id**(User)**__, gender, age, weight)
     19
     205. !WeightUser (__user_id**(User)**__, **weight**, **height**, **goal_weight**, **goal_calories**)
     21
     226. !DailyIntake (__daily_intake_id__, **user_id*(WeightUser)***, **calories**, **date**)
     23
     247. !DisciplineUser (__user_id**(User)**__)
     25
     268. !CustomTrackingCategory (__custom_tracking_id__, **user_id*(User)***, **name**)
     27
     289. !TrainingSession (__training_id__, **training_user_id*(TrainingUser)***, duration, calories, date, type)
     29
     3010. Task (__task_id__, **name**, is_finished, discipline_user_id*(DisciplineUser)*, custom_tracking_id*(CustomTrackingCategory)*)
     31
     3211. !DailyCompletion (__daily_completion_id__, **user_id*(User)***, date, procent)
     33
     3412. !TaskDailyCompletion (__task_id*(Task)*__, __daily_completion_id*(DailyCompletion)*__)
     35
     3613. !InvestorUser (__user_id**(User)**__)
     37
     3814. Asset (__asset_id__, **user_id*(InvestorUser)***, **ticker_symbol**, buy_price, buy_date, quantity)
    2639
    2740=== DDL скрипта за бришење на табелите и креирање на табелите ===