airports

idnamelocation
1JFKNew York
2LAXLos Angeles
3ORDChicago
4ATLAtlanta
5SEASeattle

terminal_buildings

idairport_idbuilding_name
(→ airports.id)
11Terminal A
21Terminal B
32Terminal 6
42Terminal 8
53Terminal 2

cargo_terminals

idairport_idterminal_building_id
(→ airports.id)(→ terminal_buildings.id)
111
212
323
424
535

aircrafts

idtypemodel
1CommercialBoeing 747
2PrivateGulfstream V
3MilitaryLockheed C-130 Hercules
4RegionalEmbraer E-Jet
5HelicopterAgustaWestland AW139

flights

iddeparture_timearrival_timeairport_idaircraft_idcargo_terminal_id
(→ airports.id)(→ aircrafts.id)(→ cargo_terminals.id)
12022-01-01 10:00:002022-01-01 12:00:00111
22022-01-01 12:30:002022-01-01 14:30:00122
32022-01-01 13:00:002022-01-01 15:00:00233
42022-01-01 14:30:002022-01-01 16:30:00244
52022-01-01 15:00:002022-01-01 17:00:00355