Changes between Version 7 and Version 8 of Complex DB Reports

Timestamp:

02/07/26 17:07:05 (21 hours ago)

Author:

231035

Comment:

--

Complex DB Reports

@@ -122 +122 @@
   Period p
 )
+
 ReviewsByUser <-
 γ
@@ -132 +133 @@
   Period p
 )
+
 AppointmentsByUser <-
 γ
@@ -162 +164 @@
  ⟕ (u.user_id = f.user_id) FavoritesByUser f
 )
+
 ActivityWithDefaults <-
 π
@@ -186 +189 @@
   favorites_saved_all_time > 0
 (ActivityWithDefaults)
+
 ScoredUsers <-
 π
-  *,
+  user_id,
+  username,
+  email,
+  name,
+  surname,
+  listings_created,
+  reviews_left,
+  avg_rating_left,
+  appointments_total,
+  appointments_done,
+  appointments_no_show,
+  appointments_cancelled,
+  favorites_saved_all_time,
   activity_score :=
     listings_created * 5 +
@@ -205 +221 @@
       reviews_left DESC
 (ScoredUsers)
+
 Result <-
 topK_{K := 10}
@@ -229 +246 @@
   )
 )
-
 
 }}}