Model

idmanufacturer_namecountry
1BoeingUSA
2AirbusFrance
3EmbraerBrazil
4BombardierCanada
5ComacChina

Airport

idairport_codenamecitycountry
1LAXLos Angeles International AirportLos AngelesUSA
2CDGCharles de Gaulle AirportParisFrance
3GRUGuarulhos–Governador André Franco Montoro International AirportSão PauloBrazil
4PEKCapital International AirportBeijingChina
5PVGShanghai Pudong International AirportShanghaiChina

Runway

idrunway_lengthrunway_widthairport_id
(→ Airport.id)
110000.0150.01
22800.045.02
32400.045.03
43000.045.04
52800.045.05

Flight

idflight_datedeparture_airport_idarrival_airport_idplane_id
(→ Airport.id)(→ Airport.id)(→ Plane.id)
12022-01-01 08:00:00121
22022-01-01 12:00:00232
32022-01-01 16:00:00343
42022-01-01 20:00:00454
52022-01-01 22:00:00515

Plane

idmanufacturer_idregistration_numberaircraft_typecurrent_location
(→ Model.id)
11N123ABPassengerLos Angeles
22F-HSBNPassengerParis
33PP-XXXRegional PassengerSão Paulo
44B-HLDYRegional PassengerBeijing
55B-HLEUBusiness JetShanghai