City

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

Coordinates

idlatitudelongitude
1-73.985428-109.136635
251.507223-0.127503
335.689501139.691699
448.85662.352222
525.2743955.29888

Airport

idnamecity_idcoordinates_id
(→ City.id)(→ Coordinates.id)
1John F. Kennedy International Airport11
2Heathrow Airport22
3Narita International Airport33
4Charles de Gaulle Airport44
5Dubai International Airport55

Airline

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

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