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 |
id | terminal_id | gate_number |
---|---|---|
(→ Terminal.id) | ||
1 | 1 | 7 |
2 | 1 | 14 |
3 | 2 | 25 |
4 | 2 | 38 |
5 | 3 | 50 |
id | typeName |
---|---|
1 | Boeing 737 |
2 | Airbus A320 |
3 | Embraer E190 |
4 | Bombardier Q400 |
5 | De Havilland Canada Dash 8 |
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 |
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 |
amenityId | amenityValue |
---|---|
1 | Complimentary Wi-Fi |
2 | Power Outlets |
3 | Charging Stations |
4 | Restrooms |
5 | Luggage Storage |
areaId | amenityId |
---|---|
(→ ExclusiveArea.areaId) | (→ Amenity.amenityId) |
1 | 1 |
1 | 2 |
2 | 3 |
3 | 4 |
4 | 5 |
5 | 1 |