Changes between Version 11 and Version 12 of UseCaseModel/AddingShipment

Timestamp:

12/22/24 22:58:35 (3 weeks ago)

Author:

153093

Comment:

--

UseCaseModel/AddingShipment

@@ -16 +16 @@
 {{{
 select
-    s.shipment_id,
-    s.shipment_date,
+        s.shipment_id,
+        s.shipment_date,
     (
         SELECT STRING_AGG(DISTINCT c.customer_name, ', ')
@@ -24 +24 @@
         WHERE sl.shipment_id = s.shipment_id
     ) AS customer_names,
-    e.employee_name,
-    e.employee_surname,
-    v.make,
-    v.model,
-    v.registration
+        CONCAT(e.employee_name, ' ', e.employee_surname) AS employee_full_name,
+        CONCAT(v.make, ' ', v.model, ' (', v.registration, ')') AS vehicle_info
 FROM shipment s
 JOIN employee e ON s.employee_id = e.employee_id