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