Airbnb (Study Case)

This ERD represents a detailed Airbnb-style accommodation booking platform database structure. The schema supports core marketplace features including user management, property listings, reservations, payments, reviews, messaging, notifications, and reporting systems. The `users` table manages platform accounts for guests, hosts, and administrators. Geographic information is normalized using `countries` and `cities`. Property management is centered around the `properties` table, which stores accommodation details such as room configuration, pricing, location, and availability. Property classification is separated into `property_types` and `room_types`. Additional features include property images, amenities, rules, cancellation policies, and daily availability calendars. Reservations are managed through the `reservations` table, which tracks booking dates, guest counts, pricing breakdowns, and reservation status. Related tables such as `reservation_guests` and `reservation_status_history` provide guest-level details and status change tracking. Financial processing includes `payments`, `refunds`, and `host_payouts` to support payment history, cancellations, refunds, and host settlement management. The review system allows guests to leave ratings and comments through `reviews`, while hosts can respond using `review_replies`. User engagement features include `wishlists` for saved properties and a messaging system composed of `conversations`, `conversation_members`, `messages`, and `message_attachments`. Operational features include `notifications` for system alerts and `reports` for abuse or issue reporting. This schema is designed for ERD visualization, database modeling practice, and accommodation platform clone projects. The structure emphasizes relational integrity, normalized design, and complex entity relationships similar to real-world booking services.