## Airline

id | name
--- | ---
1 | American Airlines
2 | United Airlines
3 | Delta Airlines

## Flight

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

passenger_id | first_name | last_name | age | email | 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

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