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 |