Flight
flightID | departureTime | destination | duration |
1 | 2023-03-17 09:00 | Paris | 8 |
2 | 2023-03-17 11:00 | London | 6 |
Gate
gateID | gateNumber | terminal | capacity |
1 | 101 | 1 | 20 |
2 | 102 | 1 | 25 |
Passenger
passengerID | firstName | lastName | mobilityAids | pickUpDropOffLocation |
1 | John | Doe | Wheelchair Assistance | Entrance A |
2 | Jane | Smith | Wheelchair Assistance | Exit C |
3 | Alice | Brown | Mobility Scooter | Entrance A |
4 | Bob | White | Mobility Scooter | Gate F |
ServiceRequest
requestID | flightID | passengerID | serviceType |
| (→ Flight.flightID) | (→ Passenger.passengerID) | |
1 | 1 | 1 | Assisted Boarding |
2 | 1 | 2 | Meal Request |
3 | 2 | 3 | Extra Luggage Space |
4 | 2 | 4 | Special Meal |