id | name |
---|---|
1 | American Airlines |
2 | United Airlines |
3 | Delta Airlines |
flight_id | airline_id | departure_airport | arrival_airport | aircraft | inflight_amenities |
---|---|---|---|---|---|
(→ Airline.id) | |||||
1 | 1 | LAX | JFK | Boeing 787 Dreamliner | Onboard Service |
2 | 2 | LAX | ORD | Airbus A380 | Inflight Entertainment |
3 | 1 | DFW | MIA | Boeing 787 Dreamliner | Inflight Entertainment |
4 | 2 | EWR | SEA | Airbus A321 | Onboard Service |
5 | 3 | ATL | SFO | Boeing 767 | No Inflight Entertainment |
passenger_id | first_name | last_name | age | phone_number | |
---|---|---|---|---|---|
1 | John | Doe | 35 | johndoe@example.com | +1234567890 |
2 | Jane | Smith | 40 | janesmith@example.com | +0987654321 |
3 | Alice | Johnson | 25 | alicejohnson@example.com | +1357924680 |
4 | Michael | Williams | 50 | mwilliams@example.com | +2468135790 |
5 | Emily | Jones | 30 | emilyjones@example.com | +3681945230 |
booking_id | flight_id | passenger_id | seat_number | status | payment_date |
---|---|---|---|---|---|
(→ Flight.flight_id) | (→ Passenger.passenger_id) | ||||
1 | 1 | 1 | 10C | Confirmed | 2022-01-01 10:00:00 |
2 | 2 | 2 | 12A | Waitlisted | 2022-01-02 15:00:00 |
3 | 3 | 3 | 15F | Refunded | 2022-01-03 10:00:00 |
4 | 4 | 4 | 20G | Canceled | 2022-01-04 15:00:00 |
5 | 5 | 5 | 25H | Pending | 2022-01-05 10:00:00 |