Airports
id | name | city |
1 | JFK International | New York |
2 | LAX International | Los Angeles |
3 | ORD International | Chicago |
4 | ATL Hartsfield-Jackson | Atlanta |
5 | SEA Seattle/Tacoma | Seattle |
Terminals
id | airportId | terminalName |
| (→ Airports.id) | |
1 | 1 | Terminal 1 |
2 | 1 | Terminal 2 |
3 | 1 | Terminal 3 |
4 | 2 | Terminal A |
5 | 2 | Terminal B |
6 | 3 | Terminal C |
7 | 3 | Terminal D |
Gates
id | terminalId | gateNumber |
| (→ Terminals.id) | |
1 | 1 | 10 |
2 | 1 | 20 |
3 | 1 | 30 |
4 | 2 | 10 |
5 | 2 | 20 |
6 | 3 | 10 |
7 | 3 | 20 |
8 | 4 | 10 |
9 | 4 | 20 |
Flights
flightID | departureGateId | arrivalGateId | departureTime | arrivalTime | departureAirportId | arrivalAirportId |
| (→ Gates.id) | (→ Gates.id) | | | (→ Airports.id) | (→ Airports.id) |
1 | 1 | 1 | 2022-09-01 07:00:00 | 2022-09-01 08:00:00 | 1 | 2 |
2 | 2 | 2 | 2022-09-01 08:00:00 | 2022-09-01 09:00:00 | 1 | 2 |
3 | 3 | 3 | 2022-09-01 09:00:00 | 2022-09-01 10:00:00 | 1 | 2 |
4 | 4 | 4 | 2022-09-01 10:00:00 | 2022-09-01 11:00:00 | 1 | 2 |
5 | 5 | 5 | 2022-09-01 11:00:00 | 2022-09-01 12:00:00 | 1 | 2 |
RetailOutlets
id | type | location | terminalId |
| | | (→ Terminals.id) |
1 | Duty-Free Shop | Terminal 3 | 3 |
2 | Duty-Free Shop | Concourse E | 2 |
3 | Souvenir Store | Terminal 3 | 3 |
4 | Souvenir Store | Concourse F | 2 |
5 | Bookshop | Terminal 2 | 2 |
6 | Coffee Shop | Terminal 1 | 1 |
7 | Restaurant | Terminal 3 | 3 |