Airports

idnamecitycountrylatitudelongitude
1John F Kennedy InternationalNew York CityUSA40.641987-73.778604
2Los Angeles InternationalLos AngelesUSA33.944826-118.405889
3Heathrow AirportLondonUK51.477025-0.461866
4Dubai InternationalDubaiUAE25.25964855.285619
5Tokyo HanedaTokyoJapan35.601194139.737522

Airlines

idairline_nametype_of_alliancehome_airport_id
(→ Airports.id)
1Alliance AirwaysAirline Alliance1
2Budget AirlinesAirline Alliance2
3Fly High IndependentIndependent Carrier3
4Global TravellersIndependent Carrier4
5Oceanic FlyersNo Alliance5

Flights

flight_numberdeparture_timearrival_timeairline_idaircraft_modelsource_airport_iddestination_airport_id
(→ Airlines.id)(→ Airports.id)(→ Airports.id)
12022-01-01 10:00:002022-01-01 14:00:001Airbus A32012
22022-01-01 12:00:002022-01-01 17:00:002Boeing B73734
32022-01-02 08:00:002022-01-02 12:00:003Airbus A32045
42022-01-02 10:00:002022-01-02 15:00:004Boeing B78751
52022-01-03 11:00:002022-01-03 16:00:005Airbus A32023

Pilots

pilot_license_numberfirst_namelast_namedate_of_birthrating_level
1JohnSmith1990-01-01A
2JaneDoe1985-05-05A
3AliceWright1989-02-12B
4BobJohnson1992-03-13C

Assignments

assignment_idflight_numberpilot_license_number
(→ Flights.flight_number)(→ Pilots.pilot_license_number)
111
212
323
424
531