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-010
2JaneSmith1985-02-020
3EmilyJohnson1991-03-030
4MichaelWilliams1988-04-040
5DavidBrown1992-05-050
6AliceMorgan2005-07-151
7BrianCase2002-11-201
8CathyLee1995-05-220
9DerekWoods1998-03-300

Requirements

requirementIdpassengerIddescriptionassistant
(→ Passengers.passengerId)
11Wheelchair assistance requiredAlice Brown
22Oxygen tank needed on boardBob Johnson
33Diabetic meal requestCharlie White
44Special dietary needsDaniel Green
55Hearing aid supportEva Black
66Unaccompanied minorClare Allen
77Unaccompanied minorMark Taylor
88Tailored assistance requestClare Allen
99Tailored assistance requestNancy Davis