Countries

CountryIDName
1USA
2UK
3France
4Germany
5Japan

Cities

CityIDNameCountryId
(→ Countries.CountryID)
1New York1
2London2
3Paris3
4Berlin4
5Tokyo5

Airports

AirportIdNameCityIdStructureRunwayLength
(→ Cities.CityID)
1JFK International1Terminal Building9000.0
2Heathrow Airport2Terminal Building8000.0
3Charles de Gaulle Airport3Terminal Building6000.0
4Tegel Airport4Cargo Terminal4000.0
5Haneda Airport5Terminal Building8500.0

Flights

FlightIdSourceAirportIdDestinationAirportIdDepartureTimeArrivalTimeAircraftId
(→ Airports.AirportId)(→ Airports.AirportId)(→ Planes.PlaneId)
1122022-01-01 08:00:002022-01-01 12:00:001
2212022-01-02 08:00:002022-01-02 12:00:001
3342022-01-03 08:00:002022-01-03 12:00:002
4432022-01-04 08:00:002022-01-04 12:00:002
5552022-01-05 08:00:002022-01-05 12:00:003

Planes

PlaneIdModelSeats
1Boeing 747400
2Airbus A380800
3Bombardier CRJ1000100

Runways

RunwayIdLengthWidthAirportId
(→ Airports.AirportId)
110000.0150.01
29000.0150.02
37000.0150.03
46000.0150.04
59500.0150.05