Back to Home
ERD Studio
Browse Templates/Airbnb

Airbnb

Full database schema for an Airbnb-like short-term rental marketplace featuring host and guest profiles, property listings with amenities and photos, availability calendars, dynamic pricing, booking lifecycle management, bidirectional reviews, messaging, wish lists, and host payout tracking.

PostgreSQL15 tablesWeb App
rentalmarketplacebookinghospitality
Created with ERD Studio

Tables in this template

usersUsers
10 cols
host_profilesHost Profiles
9 cols
listingsListings
19 cols
listing_photosListing Photos
6 cols
amenitiesAmenities
5 cols
listing_amenitiesListing Amenities
4 cols
availability_calendarAvailability Calendar
8 cols
bookingsBookings
14 cols
reviewsReviews
11 cols
conversationsConversations
5 cols
conversation_participantsConversation Participants
5 cols
messagesMessages
6 cols
wish_listsWish Lists
6 cols
wish_list_itemsWish List Items
5 cols
payoutsPayouts
8 cols

Related Templates

View all templates →

GitHub

Clone

Code hosting platform with repositories, issues, pull requests, and CI/CD

PostgreSQL16 tables
developer-toolsgitcollaboration+2
Web App

Netflix

Clone

Video streaming platform with content catalog, profiles, subscriptions, and recommendations

PostgreSQL15 tables
streamingvideosubscription+2
Web App

Spotify

Clone

Music streaming platform with tracks, artists, albums, playlists, and social features

PostgreSQL18 tables
musicstreamingplaylist+2
Web App

Discord

Clone

Community platform with servers, channels, roles, voice, and bots

PostgreSQL15 tables
gamingcommunityvoice+2
Web App
Airbnb Database Schema - ERD Template