Geographical_Position

idnamecountry
1New YorkUSA
2LondonUK
3TokyoJapan
4ParisFrance
5DubaiUAE

Flight

idairport_from_idairport_to_idairline_iddeparture_timearrival_time
(→ Airport.id)(→ Airport.id)(→ Airline.id)
11212022-01-01 12:00:002022-01-01 18:00:00
23422022-01-01 08:00:002022-01-01 14:00:00
35132022-01-02 12:00:002022-01-02 18:00:00
42342022-01-02 08:00:002022-01-02 14:00:00
54552022-01-03 12:00:002022-01-03 18:00:00

Runway

idairport_idlengthwidthsurface_type
(→ Airport.id)
1110000200Asphalt
2210000200Concrete
339000200Asphalt
449000200Concrete
5512000200Asphalt

Airport

idnamecity_id
(→ Geographical_Position.id)
1John F. Kennedy International Airport1
2Heathrow Airport2
3Narita International Airport3
4Charles de Gaulle Airport4
5Dubai International Airport5

Airline

idnameheadquarter_city_id
(→ Geographical_Position.id)
1American Airlines1
2British Airways2
3All Nippon Airways3
4Air France-KLM4
5Emirates5