## 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