## Airlines

id | name | headquarter_city
--- | --- | ---
1 | Delta | Atlanta
2 | United | Chicago
3 | Southwest | Dallas
4 | American | Fort Worth
5 | Alaska | Seattle

## Flight

flight_id | airline_id | departure_time | arrival_time | origin_airport | destination_airport
--- | --- | --- | --- | --- | ---
| (→ Airlines.id) |  |  |  |
1 | 1 | 2023-08-01 09:00:00 | 2023-08-01 11:00:00 | ATL | LAX
2 | 2 | 2023-08-01 10:00:00 | 2023-08-01 12:00:00 | ORD | IAD
3 | 3 | 2023-08-01 11:00:00 | 2023-08-01 13:00:00 | DFW | MIA
4 | 4 | 2023-08-01 12:00:00 | 2023-08-01 14:00:00 | SEA | PHX
5 | 1 | 2023-08-01 15:00:00 | 2023-08-01 17:00:00 | ATL | LAX

## Aircrafts

aircraft_id | model | capacity | current_flight_id
--- | --- | --- | ---
|  |  | (→ Flight.flight_id)
1 | Boeing 767 | 200 | None
2 | Airbus A320 | 150 | None
3 | Embraer E190 | 80 | None
4 | Bombardier CRJ700 | 50 | None
5 | Airbus A380 | 400 | None

## Passengers

passenger_id | first_name | last_name | date_of_birth | passport_number | email | phone_number
--- | --- | --- | --- | --- | --- | ---
1 | John | Smith | 1990-05-15 | AB1234CD | johnsmith@email.com | +1234567890
2 | Anna | Karenina | 1985-06-20 | EF5678GH | annakarenina@email.com | +1234567890
3 | Michael | Scott | 1970-07-10 | JK987LN | mscott@email.com | +1234567890
4 | Emma | Swanson | 1995-08-05 | LM890QP | emmaswanson@email.com | +1234567890
5 | Daniel | Plainview | 1960-09-15 | NO456RP | danielplainview@email.com | +1234567890

## Bookings

booking_id | flight_id | passenger_id | seat_number
--- | --- | --- | ---
| (→ Flight.flight_id) | (→ Passengers.passenger_id) |
1 | 1 | 1 | 1A
2 | 2 | 2 | 12B
3 | 3 | 3 | 22E
4 | 4 | 4 | 28D
5 | 5 | 5 | 1F

## Transportations

transportation_id | service_type | pick_up_location | drop_off_location | available_hours | price
--- | --- | --- | --- | --- | ---
1 | Rental Car | Zone D | Terminal B | 08:00:00 | 50
2 | Rental Car | Zone C | Terminal A | 08:00:00 | 50
3 | Airport Shuttle | Zone D | Terminal B | 08:00:00 | 20
4 | Airport Shuttle | Zone C | Terminal A | 08:00:00 | 20