Airports

idnamelocationairport_structuresaircraft
1JFKNew York City, USATerminal BuildingBoeing 747
2LAXLos Angeles, USATerminal BuildingAirbus A380
3ORDChicago, USATerminal BuildingBoeing 737
4DXBDubai, UAETerminal BuildingAirbus A380
5PEKBeijing, ChinaCargo TerminalBoeing 747
6HNDTokyo, JapanCargo TerminalBoeing 767

Flights

flight_iddeparture_airport_namearrival_airport_namedatedurationaircraft_type
(→ Airports.name)(→ Airports.name)
1JFKLAX2021-09-01 07:00:00120Boeing 747
2LAXORD2021-09-01 11:00:00180Airbus A380
3ORDDXB2021-09-01 17:00:00240Boeing 737
4DXBHND2021-09-01 22:00:00150Airbus A380
5LHRYVR2021-09-02 06:00:00120Boeing 767

Airlines

airline_idnamecountryfleet_sizeheadquartersflight_number
1American AirlinesUSA900Fort Worth, TexasNone
2United AirlinesUSA800Chicago, IllinoisNone
3Delta AirlinesUSA700Atlanta, GeorgiaNone
4EmiratesUAE200Dubai, UAENone
5Qatar AirwaysQatar100Doha, QatarNone

Pilots

pilot_idfirst_namelast_namelicense_datetotal_hoursairline_id
(→ Airlines.airline_id)
1JohnSmith2010-01-0150001
2JaneDoe2012-02-0140002
3MichaelJackson2014-03-0130003
4SusanWilson2016-04-0125004
5DavidMartin2018-05-0135005

Passengers

passenger_idfirst_namelast_namepassport_numberticket_numberseat_numberflight_id
(→ Flights.flight_id)
1AliceSmithA1234567TIC123451A1
2BobJonesB6789012TIE678902A2
3CarolWilliamsC3456789TIM987653A3
4DanielBrownD0987654TID012344A4
5ElizabethGreenE4567890TIE987655A5