Passengers

passengerIDfirstNamelastNameage
1JohnDoe30
2JaneSmith28
3AliceBrown65
4BobWhite72
5EmmaGreen19

Flights

flightNumberdepartureAirportarrivalAirportscheduledDepartureactualDeparturescheduledArrivalactualArrival
1LAXNYC10:00 AMNone11:30 AMNone
2SFOMIA1:00 PMNone4:30 PMNone
3ORDATL5:00 PMNone7:30 PMNone
4IADSEA8:00 PMNone10:30 PMNone
5DFWPHX11:00 PMNone1:30 AMNone

WheelchairAssistanceRequests

requestIDpassengerIDpickUpDropOffLocationrequestedTimestatus
(→ Passengers.passengerID)
11Entrance A2022-10-01 09:00:00Pending
22Gate B2022-10-01 10:00:00Completed
33Exit C2022-10-01 11:00:00In Progress
44Entrance A2022-10-01 12:00:00Canceled
55Gate D2022-10-01 13:00:00Pending

MobilityScooterRequests

requestIDpassengerIDpickUpDropOffLocationrequestedTimestatus
(→ Passengers.passengerID)
11Entrance A2022-10-01 08:00:00Pending
22Gate E2022-10-01 09:00:00Completed
33Exit F2022-10-01 10:00:00In Progress
44Entrance A2022-10-01 11:00:00Canceled
55Gate G2022-10-01 12:00:00Pending