Changes between Version 8 and Version 9 of Design

Timestamp:

02/07/25 17:32:13 (2 weeks ago)

Author:

163080

Comment:

--

Design

@@ -38 +38 @@
 SELECT 
     client_id, 
-    name, 
+    client_name, 
     contact_person, 
-    email, 
+    client_email, 
     phone, 
     city, 
@@ -63 +63 @@
     Invoice i ON cl.client_id = i.client_id AND i.status = 'Unpaid'
 WHERE 
-    cl.client_id = 5  -- Replace 5 with the specific client ID
+    cl.client_id = X
 GROUP BY 
     cl.client_id;
@@ -76 +76 @@
 SELECT 
     i.invoice_id, 
-    c.name AS client_name, 
+    c.client_name, 
     i.issue_date, 
     i.due_date, 
@@ -106 +106 @@
     status = 'Paid'
 WHERE 
-    invoice_id = 2; -- Replace 2 with the actual invoice ID
+    invoice_id = X;
 
 }}}