Changes between Version 1 and Version 2 of RelationalDesign

Timestamp:

02/04/26 19:42:52 (6 days ago)

Author:

233062

Comment:

--

RelationalDesign

@@ -10 +10 @@
 
 === Табели
-1. User ('''__user_id__, full_name, email, password, username, profile_photo''')
+1. User ('''user_id, email, username, password''')
 
-2. Non-Admin User ('''__user_id*(User)__''')
+2. FinanceUser ('''user_id*(User), spending_budget, saving_budget, investing_budget, donation_budget, credit''')
 
-3. Admin ('''__user_id*(User)__''')
+3. Income ('''income_id, user_id*(FinanceUser)__, date, amount''')
 
-4. Listener ('''__user_id*(User)__''')
+4. TrainingUser ('''user_id*(User), gender, age, weight''')
 
-5. !MusicalEntity ('''__id__, title , genre , release_date''')
+5. TrainingSession ('''training_id, training_user_id*(TrainingUser), weight_user_id*(WeightUser), duration, calories, date, type''')
 
-6. Song ('''__id*(!MusicalEntity)__, link''')
+6. WeightUser ('''user_id*(User), weight, height, goal_weight, goal_calories''')
 
-7. Artist ('''__user_id*(User)__''')
+7. DailyIntake ('''daily_intake_id, user_id*(WeightUser)__, calories, date''')
 
-8. Event ('''__event_id__, name, location, venue, date, time ''')
+8. DisciplineUser ('''user_id*(User), num_tasks, tasks''')
 
-9. Album ('''__id*(!MusicalEntity)__''')
+9. CustomTrackingCategory ('''custom_tracking_id, user_id*(User)__, name, num_tasks, tasks''')
 
-10. Playlist ('''__playlist_id__, cover, name''')
+10. Task ('''task_id, name, discipline_user_id*(DisciplineUser), custom_tracking_id*(CustomTrackingCategory)''')
 
+11. DailyCompletion ('''daily_completion_id, user_id*(User)__, date, procent''')
 
+12. TaskDailyCompletion ('''task_id*(Task), daily_completion_id*(DailyCompletion)''')
+
+13. InvestorUser ('''user_id*(User)''')
+
+14. Asset ('''asset_id, user_id*(InvestorUser)__, ticker_symbol, buy_price, buy_date''')
 
 === DDL скрипта за бришење на табелите и креирање на табелите 
@@ -43 +49 @@
 == Историјат
 [[html(<a href="https://develop.finki.ukim.mk/projects/finkwave/attachment/wiki/RelationalDesign/relational_schema_v1.jpeg" ">Верзија 1</a>)]] - Почетна верзија
-
-[[html(<a href="https://develop.finki.ukim.mk/projects/finkwave/attachment/wiki/RelationalDesign/relational_schema_v2.png" ">Верзија 2</a>)]]
-- Додавање на атрибути за име, време и датум за секој настан, во табелата **events**
-- Промена на полето `listen_count` во табелата **listens** со `timestamp`