logo
ExamplesEditorPricingDocs
37.1kSign in

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.

Hotel Booking ER diagram

Hotel booking & reservation database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 hotels idBIGINT nameVARCHAR slugVARCHAR address_line1VARCHAR cityVARCHAR country_codeCHAR timezoneVARCHAR check_in_timeVARCHAR check_out_timeVARCHAR star_ratingINTEGER is_activeBOOLEAN room_types idBIGINT hotel_idBIGINT codeVARCHAR nameVARCHAR descriptionTEXT max_occupancyINTEGER bed_configurationVARCHAR size_sqmINTEGER rooms idBIGINT hotel_idBIGINT room_type_idBIGINT room_numberVARCHAR floorINTEGER statusVARCHAR rate_plans idBIGINT hotel_idBIGINT codeVARCHAR nameVARCHAR is_refundableBOOLEAN includes_breakfastBOOLEAN min_nightsINTEGER cancellation_hoursINTEGER room_rates idBIGINT room_type_idBIGINT rate_plan_idBIGINT stay_dateDATE price_minorINTEGER currency_codeCHAR rooms_availableINTEGER closedBOOLEAN guests idBIGINT emailVARCHAR full_nameVARCHAR phoneVARCHAR country_codeCHAR loyalty_numberVARCHAR created_atDATETIME reservations idBIGINT hotel_idBIGINT guest_idBIGINT confirmation_codeVARCHAR statusVARCHAR check_in_dateDATE check_out_dateDATE adultsINTEGER childrenINTEGER total_minorINTEGER currency_codeCHAR sourceVARCHAR special_requestsTEXT booked_atDATETIME cancelled_atDATETIME reservation_nights idBIGINT reservation_idBIGINT room_type_idBIGINT rate_plan_idBIGINT assigned_room_idBIGINT stay_dateDATE price_minorINTEGER currency_codeCHAR payments idBIGINT reservation_idBIGINT kindVARCHAR providerVARCHAR provider_referenceVARCHAR amount_minorINTEGER currency_codeCHAR statusVARCHAR created_atDATETIME reviews idBIGINT hotel_idBIGINT reservation_idBIGINT guest_idBIGINT ratingINTEGER titleVARCHAR bodyTEXT responseTEXT created_atDATETIME

Related database schemas

PostgreSQL
Commerce

E-commerce store database schema

A production-shaped e-commerce schema: products with variants, inventory per location, carts, orders with snapshotted line items, payments and shipments. Open it in the editor or export SQL for six dialects.

PostgreSQL
Healthcare

Hospital / EHR database schema

The core of an electronic health record: patients and providers, appointments versus encounters, coded conditions and observations, prescriptions against a drug catalogue, allergies and insurance coverage over time.

PostgreSQL
Internal tools

Project management & issue tracker database schema

A Jira-shaped tracker: projects with human-readable issue keys, subtasks through a self-reference, fractional board positions for drag-and-drop, labels, milestones, comments, attachments and a worklog.

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.