Terminals
Id | Name |
1 | Terminal 1 |
2 | Terminal 2 |
Aircraft
Id | Type | Seats |
1 | Boing 737 | 200 |
2 | Airbus A380 | 500 |
3 | Fokker F28 | 60 |
Jet_bridge
Id | Length | Capacity | Terminal_id |
| | | (→ Terminals.Id) |
1 | 90.0 | 100 | 1 |
2 | 100.0 | 120 | 2 |
Staircar
Id | Number_of_Cars | Capacity | Terminal_id |
| | | (→ Terminals.Id) |
1 | 10 | 50 | 1 |
2 | 5 | 30 | 2 |
Flight
Id | Aircraft_id | Terminal_id | Departure_time | Arrival_time |
| (→ Aircraft.Id) | (→ Terminals.Id) | | |
1 | 1 | 1 | 2022-12-01 09:00:00 | 2022-12-01 11:00:00 |
2 | 2 | 1 | 2022-12-02 10:00:00 | 2022-12-02 12:00:00 |
3 | 3 | 2 | 2022-12-01 14:00:00 | 2022-12-01 16:00:00 |
4 | 4 | 2 | 2022-12-02 15:00:00 | 2022-12-02 17:00:00 |
5 | 5 | 1 | 2022-12-01 18:00:00 | 2022-12-01 20:00:00 |