## Airport

id | name | city | country
--- | --- | --- | ---
1 | San Francisco International | San Francisco | USA
2 | London Heathrow | London | UK
3 | Dubai International | Dubai | UAE
4 | Tokyo Haneda | Tokyo | Japan
5 | New York JFK | New York | USA

## Terminal

id | number | capacity | airportId
--- | --- | --- | ---
|  |  | (→ Airport.id)
1 | 1 | 30 | 1
2 | 2 | 28 | 1
3 | 1 | 27 | 2
4 | 2 | 26 | 2
5 | 1 | 25 | 3

## Gate

id | gateNumber | terminalId
--- | --- | ---
|  | (→ Terminal.id)
1 | 1 | 1
2 | 2 | 1
3 | 3 | 2
4 | 4 | 2
5 | 5 | 1

## Flight

id | flightNumber | airlineName | departureTime | arrivalTime | originAirportId | destinationAirportId | gateId
--- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Airport.id) | (→ Airport.id) | (→ Gate.id)
1 | AA101 | American Airlines | 2022-12-10 09:00:00 | 2022-12-10 12:00:00 | 1 | 2 | 1
2 | BA202 | British Airways | 2022-12-11 11:00:00 | 2022-12-11 15:00:00 | 2 | 3 | 2
3 | EK310 | Emirates | 2022-12-12 08:00:00 | 2022-12-12 14:00:00 | 3 | 4 | 3
4 | UA888 | United Airlines | 2022-12-13 09:00:00 | 2022-12-13 12:00:00 | 1 | 2 | 4
5 | NH100 | All Nippon Airways | 2022-12-14 11:00:00 | 2022-12-14 15:00:00 | 4 | 1 | 5

## FlightOperation

id | operationType | details | facilities | flightId
--- | --- | --- | --- | ---
|  |  |  | (→ Flight.id)
1 | Departure | Check-in counters open at 6am | Lounge Access | 1
2 | Departure | Security checkpoint opens at 5:30am | Free WiFi | 2
3 | Arrival | Customs and immigration hall open at 6am | Lounge Access | 3
4 | Arrival | Baggage claim area opens at 5:30am | Free WiFi | 4
5 | Departure | Gates close at 8:45am |  | 5
6 | Arrival | Gates open at 7am |  | 6