Terminal

idnamelocation
1Terminal AGate 1-20
2Terminal BGate 21-39
3Terminal CGate 40-60
4Terminal DGate 61-80
5Terminal EGate 81-100

Gate

idterminal_idgate_number
(→ Terminal.id)
117
2114
3225
4238
5350

AircraftType

idtypeName
1Boeing 737
2Airbus A320
3Embraer E190
4Bombardier Q400
5De Havilland Canada Dash 8

Flight

flightNumberaircraftTypeIddepartureTimearrivalTimeoriginTerminalIddestinationTerminalId
(→ AircraftType.id)(→ Terminal.id)(→ Terminal.id)
112022-01-01 06:00:002022-01-01 08:00:0014
222022-01-01 08:30:002022-01-01 10:30:0023
332022-01-01 11:00:002022-01-01 13:00:0035
442022-01-01 13:30:002022-01-01 15:30:0042
552022-01-01 16:00:002022-01-01 18:00:0051

ExclusiveArea

areaIdterminalIdexclusiveAreaValue
(→ Terminal.id)
11Frequent Flyer Lounge
22Business Class Lounge
33First Class Lounge
44Frequent Flyer Lounge
55VIP Lounge

Amenity

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

AreaAmenityMap

areaIdamenityId
(→ ExclusiveArea.areaId)(→ Amenity.amenityId)
11
12
23
34
45
51