Actors

• Transport Organizer

Steps

1. The transport organizer logs into the system.
2. The transport organizer selects the ‘Our Routes’ tab.

SELECT r.route_id, 
       l1.name AS from_location, 
       l2.name AS to_location, 
       tr.company_name AS organizer_name
FROM route r
JOIN location l1 ON r.from_location_id = l1.location_id
JOIN location l2 ON r.to_location_id = l2.location_id
JOIN transport_organizer tr ON r.transport_organizer_id = tr.transport_organizer_id
WHERE l1.name ILIKE '%from_location%'
  AND l2.name ILIKE '%to_location%'

3. The transport organizer selects a Route they want to add trip to.
4. The transport organizer clicks on the ‘Add Trip’ button.
5. The transport organizer fills out a form with the following details:
   • Time for the trip.
   • Stop locations along the route, including estimated time of arrival (ETA) for each stop.
6. The transport organizer submits the form.

INSERT INTO trip (route_id, transport_organizer_id, free_seats, date, status)
VALUES (selected_route_id, logged_in_transport_organizer_id, total_seats, 'trip_date', 'NOT_STARTED')
RETURNING trip_id

INSERT INTO trip_stops (trip_id, location_id, stop_time)
VALUES (returned_trip_id, stop_location_id, 'stop_time')

7. The transport organizer is redirected to the route page.