flightID | departureTime | arrivalTime | aircraftID | terminalID |
---|---|---|---|---|
(→ Aircraft.aircraftID) | (→ Terminal.terminalID) | |||
1 | 2023-01-01 07:00:00 | 2023-01-01 10:00:00 | 1 | 1 |
2 | 2023-01-01 09:00:00 | 2023-01-01 11:00:00 | 2 | 1 |
3 | 2023-01-01 11:00:00 | 2023-01-01 13:00:00 | 3 | 2 |
4 | 2023-01-01 14:00:00 | 2023-01-01 16:00:00 | 4 | 1 |
5 | 2023-01-01 16:00:00 | 2023-01-01 18:00:00 | 5 | 2 |
passengerID | firstName | lastName | flightID | loungeID |
---|---|---|---|---|
(→ Flight.flightID) | (→ Lounge.loungeID) | |||
1 | John | Doe | 1 | 1 |
2 | Jane | Smith | 2 | 1 |
3 | Alice | Brown | 3 | 2 |
4 | Michael | Johnson | 4 | 1 |
5 | Emily | White | 5 | 2 |
aircraftID | model | capacity |
---|---|---|
1 | Airbus A320 | 200 |
2 | Boeing 737 | 180 |
3 | Embraer E190 | 100 |
4 | Airbus A380 | 500 |
5 | Boeing 777 | 350 |
terminalID | location |
---|---|
1 | Terminal 1 |
2 | Terminal 2 |
loungeID | name | exclusiveArea | amenities | capacity | terminalID |
---|---|---|---|---|---|
(→ Terminal.terminalID) | |||||
1 | Business Class Lounge | Frequent Flyer Lounge | Complimentary Wi-Fi | 100 | 1 |
2 | Premium Economy Lounge | Frequent Flyer Lounge | Not Complimentary Wi-Fi | 80 | 1 |
3 | First Class Lounge | VIP Lounge | Complimentary Wi-Fi | 50 | 2 |
4 | Golden Wings Lounge | VIP Lounge | Not Complimentary Wi-Fi | 60 | 2 |
5 | Silver Stars Lounge | 40 | 1 |
amenityID | description |
---|---|
1 | Free high-speed internet access |
2 | Power outlets at every seat |
3 | Quiet zones for relaxation |
4 | Children's play area |
5 | Showers facilities |