Airports

idnamecitycountry
1New York JFKNew YorkUSA
2London HeathrowLondonUK
3Tokyo HanedaTokyoJapan
4Dubai InternationalDubaiUAE
5Frankfurt AirportFrankfurtGermany

Flights

flightNumberdepartureAirportIdarrivalAirportIddepartureTimearrivalTime
(→ Airports.id)(→ Airports.id)
1122023-06-01 10:00:002023-06-01 18:00:00
2342023-07-01 12:00:002023-07-01 20:00:00
3522023-08-01 14:00:002023-08-01 22:00:00
4352023-09-01 16:00:002023-09-01 23:00:00
5142023-10-01 08:00:002023-10-01 16:00:00

Passengers

passengerIdfirstNamelastNamedateOfBirthisMinor
1JohnDoe1990-01-011
2JaneSmith1985-02-020
3EmilyJohnson1991-03-031
4MichaelWilliams1988-04-040
5DavidBrown1992-05-051

SpecialRequirements

requirementIddescriptionassistant
1Wheelchair assistance requiredAlice Brown
2Oxygen tank needed on boardBob Johnson
3Diabetic meal requestCharlie White
4Special dietary needsDaniel Green
5Hearing aid supportEva Black
6Unaccompanied MinorClare Allen
7Unaccompanied MinorMark Taylor
8Special Needs PassengerClare Allen
9Special Needs PassengerNancy Davis