Changes between Version 35 and Version 36 of UseCaseModel/AddingShipment

Timestamp:

01/08/25 19:34:26 (7 days ago)

Author:

153093

Comment:

--

UseCaseModel/AddingShipment

@@ -52 +52 @@
 select
     v.vehicle_id as Id,
-    CONCAT(v.make, ' ', v.model, ' (', v.registration, ')') AS Name,
+    CONCAT(vd.make, ' ', vd.model, ' (', v.registration, ')') AS Name,
     edv.employee_id as EmployeeId,
-    v.capacity as Capacity
+    vd.capacity as Capacity
 from employee_drives_vehicle edv
 join vehicle v on edv.vehicle_id = v.vehicle_id
+join vehicle_details vd on v.vehicle_details_id = vd.vehicle_details_id
 }}}
         * Приказ на Клиенти