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 |