Flights

FlightIDDepartureTimeArrivalTimeAirplaneID
(→ Airplanes.AirplaneID)
12023-04-10 10:002023-04-10 12:001
22023-04-10 14:002023-04-10 16:002
32023-04-10 18:002023-04-10 20:003
42023-04-11 10:002023-04-11 12:004
52023-04-11 14:002023-04-11 16:005

Passengers

PassengerIdFirstNameLastNameAge
1JohnDoe30
2JaneSmith27
3AliceJohnson29
4BobWilliams35
5MaryJones40

Airplanes

AirplaneIDModelSeatCapacity
1Boeing 737180
2Airbus A320160
3Embraer E190100
4Bombardier CRJ70070
5De Havilland Canada DHC-837

AirportFacilities

FacilityIDNameCost
1Terminal Building100000.0
2Parking Lot50000.0
3Security Checkpoint30000.0
4Restaurant20000.0
5Car Rental15000.0

BaggageType

BaggageTypeIDType
1Cabin Baggage
2Checked Baggage

Baggefees

FeeIDLuggageTypeIDFees
(→ BaggageType.BaggageTypeID)
1125.0
2128.0
3225.0
4230.0