## airports

id | name | location
--- | --- | ---
1 | JFK | New York
2 | LAX | Los Angeles
3 | ORD | Chicago
4 | ATL | Atlanta
5 | SEA | Seattle

## terminal_buildings

id | airport_id | building_name
--- | --- | ---
| (→ airports.id) |
1 | 1 | Terminal A
2 | 1 | Terminal B
3 | 2 | Terminal 6
4 | 2 | Terminal 8
5 | 3 | Terminal 2

## cargo_terminals

id | airport_id | terminal_building_id
--- | --- | ---
| (→ airports.id) | (→ terminal_buildings.id)
1 | 1 | 1
2 | 1 | 2
3 | 2 | 3
4 | 2 | 4
5 | 3 | 5

## aircrafts

id | type | model
--- | --- | ---
1 | Commercial | Boeing 747
2 | Private | Gulfstream V
3 | Military | Lockheed C-130 Hercules
4 | Regional | Embraer E-Jet
5 | Helicopter | AgustaWestland AW139

## flights

id | departure_time | arrival_time | airport_id | aircraft_id | cargo_terminal_id
--- | --- | --- | --- | --- | ---
|  |  | (→ airports.id) | (→ aircrafts.id) | (→ cargo_terminals.id)
1 | 2022-01-01 10:00:00 | 2022-01-01 12:00:00 | 1 | 1 | 1
2 | 2022-01-01 12:30:00 | 2022-01-01 14:30:00 | 1 | 2 | 2
3 | 2022-01-01 13:00:00 | 2022-01-01 15:00:00 | 2 | 3 | 3
4 | 2022-01-01 14:30:00 | 2022-01-01 16:30:00 | 2 | 4 | 4
5 | 2022-01-01 15:00:00 | 2022-01-01 17:00:00 | 3 | 5 | 5