logo
ExamplesEditorPricingDocs
37.1kSign in

Flight booking and airline reservation schema

An airline reservation schema: airports, scheduled flights and their legs, weekly operating patterns, dated departures, fare classes with overlapping inventory buckets, PNR bookings, e-tickets, seat maps and assignments, and ancillaries.

Flight Booking ER diagram

Flight booking and airline reservation schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 airports idBIGINT iata_codeCHAR icao_codeCHAR nameVARCHAR cityVARCHAR country_codeCHAR timezoneVARCHAR latitudeNUMERIC longitudeNUMERIC is_activeBOOLEAN aircraft_configurat… idBIGINT codeVARCHAR aircraft_typeVARCHAR descriptionVARCHAR total_seatsSMALLINT has_wifiBOOLEAN cabin_seats idBIGINT configuration_idBIGINT seat_numberVARCHAR cabinVARCHAR seat_typeVARCHAR is_exit_rowBOOLEAN is_bulkheadBOOLEAN extra_legroomBOOLEAN is_blockedBOOLEAN flights idBIGINT carrier_codeCHAR flight_numberVARCHAR effective_fromDATE effective_toDATE days_of_weekVARCHAR configuration_idBIGINT is_activeBOOLEAN flight_legs idBIGINT flight_idBIGINT leg_sequenceSMALLINT origin_airport_idBIGINT destination_airpo…BIGINT departure_timeTIME arrival_timeTIME arrival_day_offsetSMALLINT block_minutesSMALLINT flight_departures idBIGINT flight_leg_idBIGINT departure_dateDATE configuration_idBIGINT tail_numberVARCHAR statusVARCHAR scheduled_departu…TIMESTAMPTZ actual_departure_…TIMESTAMPTZ actual_arrival_atTIMESTAMPTZ gateVARCHAR fare_classes idBIGINT codeCHAR cabinVARCHAR display_nameVARCHAR is_refundableBOOLEAN change_fee_minorINTEGER checked_bags_incl…SMALLINT mileage_earning_p…SMALLINT boarding_prioritySMALLINT inventory_buckets idBIGINT departure_idBIGINT fare_class_idBIGINT authorised_seatsSMALLINT sold_seatsSMALLINT waitlist_seatsSMALLINT price_minorINTEGER currency_codeCHAR is_closedBOOLEAN updated_atTIMESTAMPTZ bookings idBIGINT record_locatorCHAR statusVARCHAR contact_emailVARCHAR contact_phoneVARCHAR currency_codeCHAR total_minorINTEGER booking_channelVARCHAR ticketing_deadlineTIMESTAMPTZ created_atTIMESTAMPTZ cancelled_atTIMESTAMPTZ passengers idBIGINT booking_idBIGINT passenger_sequenceSMALLINT passenger_typeVARCHAR given_nameVARCHAR family_nameVARCHAR date_of_birthDATE document_numberVARCHAR document_country_…CHAR document_expires_…DATE frequent_flyer_nu…VARCHAR special_service_c…VARCHAR booking_segments idBIGINT booking_idBIGINT segment_sequenceSMALLINT departure_idBIGINT fare_class_idBIGINT statusVARCHAR is_connectionBOOLEAN marketing_carrierCHAR tickets idBIGINT booking_idBIGINT passenger_idBIGINT ticket_numberVARCHAR statusVARCHAR fare_minorINTEGER taxes_minorINTEGER currency_codeCHAR issued_atTIMESTAMPTZ exchanged_for_tic…BIGINT refunded_atTIMESTAMPTZ seat_assignments idBIGINT segment_idBIGINT passenger_idBIGINT seat_idBIGINT assigned_atTIMESTAMPTZ assigned_byVARCHAR is_paidBOOLEAN ancillaries idBIGINT booking_idBIGINT passenger_idBIGINT segment_idBIGINT seat_assignment_idBIGINT kindVARCHAR quantitySMALLINT amount_minorINTEGER currency_codeCHAR statusVARCHAR created_atTIMESTAMPTZ

Related database schemas

PostgreSQL
Travel

Event ticketing and seat reservation schema

A ticketing schema built around expiring checkout holds: venues with sections and seats, events, general-admission capacity pools, per-seat inventory, orders, tickets with rotating QR identifiers, transfers, door scans and partial refunds.

MySQL
Travel

Car rental and fleet database schema

A vehicle rental schema: branches, vehicle classes versus the individual cars behind them, a per-branch availability calendar, reservations and signed agreements, mileage and fuel, damage inspections with photos, protection add-ons and one-way fees.

MySQL
Travel

Hotel booking & reservation database schema

A reservation system that actually handles availability: room types versus rooms, rate plans, a per-night rate and inventory calendar, reservations broken down by night, payments and verified reviews.

PostgreSQL
Travel

Airbnb database schema

How a short-term rental marketplace models its data: hosts and listings, a host-owned per-night calendar, request-to-book versus instant book, reservations, guest payments and host payouts, and two-way reviews that only reveal once both sides have written.