Bookings
# book_ref* book_date* total_amount
Ticket_flights
# ticket_no# flight_id* fare_conditions* amount
Flights
# flight_id* flight_no* scheduled_departure* scheduled_arrival* departure_airport* arrival_airport* status* aircraft_code° actual_departure° actual_arrival
Boarding_passes
# ticket_no# flight_id* boarding_no* seat_no
Airports
# airport_code* airport_name* city* longitude* latitude* timezone
Aircrafts
# aircraft_code* model* range
Seats
# aircraft_code# seat_no* fare_conditions
Tickets
# ticket_no* book_ref* passenger_id* passenger_name° contact_data