FlightID | DepartureTime | ArrivalTime | AirplaneID |
---|---|---|---|
(→ Airplanes.AirplaneID) | |||
1 | 2023-04-10 10:00 | 2023-04-10 12:00 | 1 |
2 | 2023-04-10 14:00 | 2023-04-10 16:00 | 2 |
3 | 2023-04-10 18:00 | 2023-04-10 20:00 | 3 |
4 | 2023-04-11 10:00 | 2023-04-11 12:00 | 4 |
5 | 2023-04-11 14:00 | 2023-04-11 16:00 | 5 |
PassengerId | FirstName | LastName | Age |
---|---|---|---|
1 | John | Doe | 30 |
2 | Jane | Smith | 27 |
3 | Alice | Johnson | 29 |
4 | Bob | Williams | 35 |
5 | Mary | Jones | 40 |
AirplaneID | Model | SeatCapacity |
---|---|---|
1 | Boeing 737 | 180 |
2 | Airbus A320 | 160 |
3 | Embraer E190 | 100 |
4 | Bombardier CRJ700 | 70 |
5 | De Havilland Canada DHC-8 | 37 |
FacilityID | Name | Cost |
---|---|---|
1 | Terminal Building | 100000.0 |
2 | Parking Lot | 50000.0 |
3 | Security Checkpoint | 30000.0 |
4 | Restaurant | 20000.0 |
5 | Car Rental | 15000.0 |
BaggageTypeID | Type |
---|---|
1 | Cabin Baggage |
2 | Checked Baggage |
FeeID | LuggageTypeID | Fees |
---|---|---|
(→ BaggageType.BaggageTypeID) | ||
1 | 1 | 25.0 |
2 | 1 | 28.0 |
3 | 2 | 25.0 |
4 | 2 | 30.0 |