Changes between Version 3 and Version 4 of AdvancedDatabaseDevelopment

Timestamp:

07/02/26 21:12:04 (4 days ago)

Author:

233062

Comment:

--

AdvancedDatabaseDevelopment

@@ -103 +103 @@
     END IF;
 
-    -- FIX: table name daily_completion (not daily_completions)
+   
     SELECT dc.daily_completion_id, dc.procent INTO dc_id, pct
     FROM trekr.daily_completion dc
@@ -114 +114 @@
     END IF;
 
-    -- FIX: discipline_users has no surrogate discipline_user_id; use user_id directly
-    -- FIX: column is is_finished (not finished)
     SELECT COUNT(*) INTO total_count
     FROM trekr.tasks t
@@ -131 +129 @@
     END IF;
 
-    -- FIX: table name daily_completion (not daily_completions)
+    
     INSERT INTO trekr.daily_completion (user_id, date, procent)
     VALUES (user_id, day, pct)
     RETURNING daily_completion_id INTO dc_id;
 
-    -- FIX: table name task_daily_completion (not task_daily_completions)
-    -- FIX: column is is_finished (not finished)
-    -- FIX: use user_id directly instead of subquery for discipline_user_id
+   
     FOR finished_tasks IN
         SELECT t.task_id FROM trekr.tasks t
@@ -149 +145 @@
     END LOOP;
 
-    -- FIX: column is is_finished (not finished)
-    -- FIX: use user_id directly instead of subquery for discipline_user_id
     UPDATE trekr.tasks t SET is_finished = false
     WHERE t.discipline_user_id = user_id;
@@ -266 +260 @@
 Поглед за месечен приход по корисник — прикажува вкупен приход по корисник, месец и година.
 {{{
--- FIX: incomes uses user_id as FK (not finance_user_id)
+
 CREATE OR REPLACE VIEW trekr.vw_finance_monthly_summary AS
 SELECT
@@ -279 +273 @@
 Поглед за вкупниот приход на секој корисник во тековниот месец.
 {{{
--- FIX: incomes uses user_id as FK (not finance_user_id)
+
 CREATE OR REPLACE VIEW trekr.vw_finance_current_month AS
 SELECT