Changes between Version 28 and Version 29 of DatabaseProgramming
- Timestamp:
- 06/16/26 01:33:28 (10 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DatabaseProgramming
v28 v29 470 470 end if; 471 471 472 if (select company_id from employmenthistory where employee_user_id = dispatcher_user_id and end_date is null) !=473 (select company_id from employmenthistory where employee_user_id = driver_user_id and end_date is null) then474 raise exception 'Dispatcher and driver company mismatch';475 end if;476 477 472 insert into offer(status, created_at, request_id, dispatcher_user_id, driver_user_id, price, currency_catalog_id, 478 473 eta, customer_user_id)
