Cities

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

Airports

IdCityIdCodeRunwayCount
(→ Cities.Id)
11JFK3
22LHR2
33CDG2
44HND4
55DXB6

Runways

IdLengthWidthSurfaceTypeAirportId
(→ Airports.Id)
19000.0150.0Asphalt1
28000.0170.0Concrete2
39500.0200.0Grass3
48800.0180.0Asphalt4
512000.0220.0Tarmac5

Flights

FlightIdDepartureAirportIdArrivalAirportIdScheduledDepartureActualDepartureEstimatedArrivalStatusAircraftModel
(→ Airports.Id)(→ Airports.Id)
1122023-03-25 12:00:002023-03-25 12:15:002023-03-25 13:45:00On TimeBoeing 747
2232023-03-25 15:00:002023-03-25 15:30:002023-03-25 18:30:00DelayedAirbus A380
3342023-03-25 18:00:002023-03-25 18:30:002023-03-25 22:15:00On TimeBoeing 787
4452023-03-25 21:00:002023-03-25 21:30:002023-03-25 23:15:00DelayedBoeing 777
5512023-03-26 02:00:002023-03-26 02:30:002023-03-26 04:15:00On TimeEmirates A380