Changes between Version 2 and Version 3 of AdvancedReports

Timestamp:

05/25/26 15:34:19 (9 hours ago)

Author:

181201

Comment:

--

AdvancedReports

@@ -29 +29 @@
 ),
 
-sitter_financials AS (
+sitter_reports AS (
     SELECT 
         b.sitter_id,
@@ -83 +83 @@
 JOIN pet_sitters ps ON u.user_id = ps.user_id
 LEFT JOIN sitter_stats ss ON ss.sitter_id = ps.user_id
-LEFT JOIN sitter_financials sf ON sf.sitter_id = ps.user_id
+LEFT JOIN sitter_reports sf ON sf.sitter_id = ps.user_id
 LEFT JOIN sitter_ratings sr ON sr.sitter_id = ps.user_id
 WHERE COALESCE(ss.total_bookings, 0) > 0
@@ -106 +106 @@
 )
 
-SitterFinancials <-
+SitterReports <-
 γ
   sitter_id := b.sitter_id;
@@ -135 +135 @@
   (
     (SitterBase ⟕ (u.user_id = ss.sitter_id) SitterStats ss)
-    ⟕ (u.user_id = sf.sitter_id) SitterFinancials sf
+    ⟕ (u.user_id = sf.sitter_id) SitterReports sf
   )
   ⟕ (u.user_id = sr.sitter_id) SitterRatings sr
@@ -195 +195 @@
 ),
 
-owner_financials AS (
+owner_reports AS (
     SELECT 
         b.owner_id,
@@ -263 +263 @@
 FROM users u
 JOIN pet_owners po ON u.user_id = po.user_id
-LEFT JOIN owner_financials ofin ON po.user_id = ofin.owner_id
+LEFT JOIN owner_reports ofin ON po.user_id = ofin.owner_id
 LEFT JOIN owner_activity oa ON po.user_id = oa.owner_id
 LEFT JOIN favorite_service fs ON po.user_id = fs.owner_id
@@ -276 +276 @@
 Params <- {(start_date, end_date)}
 
-OwnerFinancials <-
+OwnerReports <-
 γ
   owner_id := b.owner_id;
@@ -338 +338 @@
   (
     (
-      (OwnerBase ⟕ (u.user_id = ofin.owner_id) OwnerFinancials ofin)
+      (OwnerBase ⟕ (u.user_id = ofin.owner_id) OwnerReports ofin)
       ⟕ (u.user_id = oa.owner_id) OwnerActivity oa
     )