Airports

idnamecitycountry
1John F. Kennedy InternationalNew YorkUSA
2Los Angeles InternationalLos AngelesUSA
3Dubai InternationalDubaiUAE
4Heathrow AirportLondonUK
5Charles de Gaulle AirportParisFrance

Airlines

idairline_nameheadquarters_cityheadquarters_country
1American AirlinesFort WorthUSA
2Delta Air LinesAtlantaUSA
3EmiratesDubaiUAE
4British AirwaysLondonUK
5Air FranceParisFrance

Routes

idsource_airport_iddestination_airport_idairline_iddeparture_timearrival_time
(→ Airports.id)(→ Airports.id)(→ Airlines.id)
11212022-01-01 12:00:002022-01-01 16:00:00
22332022-01-01 14:00:002022-01-01 20:00:00
34None42022-01-01 10:00:002022-01-01 14:00:00
45152022-01-01 16:00:002022-01-01 10:00:00
51222022-01-01 15:00:002022-01-01 19:00:00

Flights

idroute_idplane_idflight_numberdeparture_datescheduled_departure_timeactual_departure_time
(→ Routes.id)(→ Planes.id)
111AA1232022-01-0112:00:00None
222EK1232022-01-0114:00:00None
3None2BA1232022-01-0110:00:00None
442AF1232022-01-0116:00:00None
55NoneDL1232022-01-0115:00:00None

Pilots

idfirst_namelast_namelicense_numberrating_leveltotal_flight_hours
1JohnDoeABCD1234ATPL5000
2JaneSmithEFGH5678ATPL7000
3MichaelJohnsonIJKL9012ATPL6000
4SarahWilliamsLMNO3456ATPL4500
5DavidBrownPQRS7890ATPL5500

AssignsPilotToFlight

pilot_idflight_idassignment_date
(→ Pilots.id)(→ Flights.id)
112022-01-01
222022-01-01
332022-01-01
442022-01-01
552022-01-01

Planes

idModelplane_typemax_passenger_capacityrange_km
1BoeingPassenger28013600.0
2AirbusPassenger44014800.0
3Bombardier AerospaceBusiness Jet197700.0
4Gulfstream AerospaceBusiness Jet187500.0
5Embraer Executive JetsBusiness Jet126000.0