## Terminal

id | name | location
--- | --- | ---
1 | Terminal A | Gate 1-20
2 | Terminal B | Gate 21-39
3 | Terminal C | Gate 40-60
4 | Terminal D | Gate 61-80
5 | Terminal E | Gate 81-100

## Gate

id | terminal_id | gate_number
--- | --- | ---
| (→ Terminal.id) |
1 | 1 | 7
2 | 1 | 14
3 | 2 | 25
4 | 2 | 38
5 | 3 | 50

## AircraftType

id | typeName
--- | ---
1 | Boeing 737
2 | Airbus A320
3 | Embraer E190
4 | Bombardier Q400
5 | De Havilland Canada Dash 8

## Flight

flightNumber | aircraftTypeId | departureTime | arrivalTime | originTerminalId | destinationTerminalId
--- | --- | --- | --- | --- | ---
| (→ AircraftType.id) |  |  | (→ Terminal.id) | (→ Terminal.id)
1 | 1 | 2022-01-01 06:00:00 | 2022-01-01 08:00:00 | 1 | 4
2 | 2 | 2022-01-01 08:30:00 | 2022-01-01 10:30:00 | 2 | 3
3 | 3 | 2022-01-01 11:00:00 | 2022-01-01 13:00:00 | 3 | 5
4 | 4 | 2022-01-01 13:30:00 | 2022-01-01 15:30:00 | 4 | 2
5 | 5 | 2022-01-01 16:00:00 | 2022-01-01 18:00:00 | 5 | 1

## ExclusiveArea

areaId | terminalId | exclusiveAreaValue
--- | --- | ---
| (→ Terminal.id) |
1 | 1 | Frequent Flyer Lounge
2 | 2 | Business Class Lounge
3 | 3 | First Class Lounge
4 | 4 | Frequent Flyer Lounge
5 | 5 | VIP Lounge

## Amenity

amenityId | amenityValue
--- | ---
1 | Complimentary Wi-Fi
2 | Power Outlets
3 | Charging Stations
4 | Restrooms
5 | Luggage Storage

## AreaAmenityMap

areaId | amenityId
--- | ---
(→ ExclusiveArea.areaId) | (→ Amenity.amenityId)
1 | 1
1 | 2
2 | 3
3 | 4
4 | 5
5 | 1