Hotel Booking

Overview

Hotel reservation platform schema inspired by Booking.com and hotel PMS systems. Models the complete booking lifecycle from room availability through check-out and reviews.

Key Design Decisions

• Availability Calendar: Date-based room availability with overbooking protection
• Rate Plans: Seasonal and dynamic pricing with minimum stay requirements
• Guest Profiles: Returning guest recognition with preference tracking
• Amenity Mapping: Many-to-many hotel-amenity relationships for search filtering

Tables

10-14 tables covering hotels, room types, rooms, rate plans, reservations, guests, availability, reviews, and amenities. Production-ready for a hotel booking platform.