Manufacturer_Name

idmanufacturer_namecountry
1BoeingUSA
2AirbusFrance
3EmbraerBrazil
4BombardierCanada
5ComacChina

Model_Name

idmodel_nameyear_introducedMAX_PASSENGERS
1737 Max2017220
2A320neo2016180
3ERJ-1902007100
4CRJ-900200085
5ARJ-21200990

Plane

idplane_model_idmanufacturer_idregistration_numberaircraft_typecurrent_location
(→ Model_Name.id)(→ Manufacturer_Name.id)
111N123ABPassengerLos Angeles
222F-HSBNPassengerParis
333PP-XXXRegional PassengerSão Paulo
444B-HLDYRegional PassengerBeijing
555B-HLEUBusiness JetShanghai

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