Passengers

PassengerIDNameFlightID
1John Doe1
2Jane Smith2
3Mike Johnson3
4Emily Davis4
5David Brown5

Flights

FlightIDDepartureTimeDestinationAvailableSeats
12023-01-01 10:00:00New York100
22023-01-02 10:00:00Los Angeles80
32023-01-03 10:00:00Chicago70
42023-01-04 10:00:00Dallas60
52023-01-05 10:00:00Houston50

LuggageRequests

RequestIDPassengerIDAssistanceTypeLocationRequestDate
(→ Passengers.PassengerID)
11Luggage TrolleyEntrance B2023-01-01 09:00:00
21Luggage TrolleyExit A2023-01-01 09:00:00
32Porter ServiceEntrance B2023-01-02 09:00:00
42Porter ServiceExit A2023-01-02 09:00:00

Locations

LocationIDLocationName
1Entrance B
2Exit A

Bookings

BookingIDLuggageRequestIDLocationIDSlotStartSlotEndBookingStatus
(→ LuggageRequests.RequestID)(→ Locations.LocationID)
1112023-01-01 08:30:002023-01-01 09:00:00Confirmed
2222023-01-01 08:30:002023-01-01 09:00:00Confirmed
3312023-01-02 08:30:002023-01-02 09:00:00Pending
4422023-01-02 08:30:002023-01-02 09:00:00Pending