## Flights

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

## Passengers

PassengerId | FirstName | LastName | Age
--- | --- | --- | ---
1 | John | Doe | 30
2 | Jane | Smith | 27
3 | Alice | Johnson | 29
4 | Bob | Williams | 35
5 | Mary | Jones | 40

## Airplanes

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

## AirportFacilities

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

## BaggageType

BaggageTypeID | Type
--- | ---
1 | Cabin Baggage
2 | Checked Baggage

## Baggefees

FeeID | LuggageTypeID | Fees
--- | --- | ---
| (→ BaggageType.BaggageTypeID) |
1 | 1 | 25.0
2 | 1 | 28.0
3 | 2 | 25.0
4 | 2 | 30.0