Airline

idname
1American Airlines
2United Airlines
3Delta Airlines

Flight

flight_idairline_iddeparture_airportarrival_airportaircraftinflight_amenities
(→ Airline.id)
11LAXJFKBoeing 787 DreamlinerOnboard Service
22LAXORDAirbus A380Inflight Entertainment
31DFWMIABoeing 787 DreamlinerInflight Entertainment
42EWRSEAAirbus A321Onboard Service
53ATLSFOBoeing 767No Inflight Entertainment

Passenger

passenger_idfirst_namelast_nameageemailphone_number
1JohnDoe35johndoe@example.com+1234567890
2JaneSmith40janesmith@example.com+0987654321
3AliceJohnson25alicejohnson@example.com+1357924680
4MichaelWilliams50mwilliams@example.com+2468135790
5EmilyJones30emilyjones@example.com+3681945230

Booking

booking_idflight_idpassenger_idseat_numberstatuspayment_date
(→ Flight.flight_id)(→ Passenger.passenger_id)
11110CConfirmed2022-01-01 10:00:00
22212AWaitlisted2022-01-02 15:00:00
33315FRefunded2022-01-03 10:00:00
44420GCanceled2022-01-04 15:00:00
55525HPending2022-01-05 10:00:00