| id | name | headquarter_city |
|---|---|---|
| 1 | Delta | Atlanta |
| 2 | United | Chicago |
| 3 | Southwest | Dallas |
| 4 | American | Fort Worth |
| 5 | Alaska | Seattle |
| 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 |
| 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 |
| passenger_id | first_name | last_name | date_of_birth | passport_number | 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 |
| 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 |
| 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 |