Home Real EstateProperty Listings Platform

Property Listings Platform

Real estate listing platform with agent hierarchy, property details, inquiries, favorites, open houses, and price history

SchemaVerse

Real EstatePostgreSQLReal EstateNormalizedREST API

property-listings.dbml

12 tables|12 relations

agencies

idinteger

namevarchar(200)

license_numbervarchar(100)

emailvarchar(255)

phonevarchar(20)

addresstext

cityvarchar(100)

statevarchar(50)

zip_codevarchar(20)

countryvarchar(100)

websitevarchar(500)

logo_urlvarchar(500)

descriptiontext

is_activeboolean

created_attimestamp

updated_attimestamp

agents

idinteger

agency_idinteger

FK*

emailvarchar(255)

*UQ

password_hashvarchar(255)

first_namevarchar(100)

last_namevarchar(100)

license_numbervarchar(100)

phonevarchar(20)

mobilevarchar(20)

photo_urlvarchar(500)

biotext

specialtiesvarchar(255)

is_activeboolean

created_attimestamp

updated_attimestamp

property_types

idinteger

namevarchar(50)

*UQ

descriptiontext

created_attimestamp

neighborhoods

idinteger

namevarchar(100)

cityvarchar(100)

statevarchar(50)

zip_codevarchar(20)

descriptiontext

median_pricedecimal(12,2)

created_attimestamp

updated_attimestamp

properties

idinteger

property_type_idinteger

FK*

neighborhood_idinteger

addressvarchar(255)

cityvarchar(100)

statevarchar(50)

zip_codevarchar(20)

countryvarchar(100)

latitudedecimal(10,7)

longitudedecimal(10,7)

bedroomsinteger

bathroomsdecimal(3,1)

square_feetinteger

lot_sizedecimal(10,2)

year_builtinteger

descriptiontext

created_attimestamp

updated_attimestamp

property_features

idinteger

property_idinteger

FK*

feature_namevarchar(100)

feature_valuevarchar(255)

created_attimestamp

property_images

idinteger

property_idinteger

FK*

urlvarchar(500)

captionvarchar(255)

display_orderinteger

is_primaryboolean

created_attimestamp

listings

idinteger

property_idinteger

FK*

agent_idinteger

FK*

list_pricedecimal(12,2)

statusvarchar(20)

listing_typevarchar(20)

listing_datedate

expiration_datedate

sold_pricedecimal(12,2)

sold_datedate

days_on_marketinteger

view_countinteger

created_attimestamp

updated_attimestamp

price_history

idinteger

listing_idinteger

FK*

pricedecimal(12,2)

changed_byinteger

change_reasonvarchar(255)

created_attimestamp

inquiries

idinteger

listing_idinteger

FK*

namevarchar(100)

emailvarchar(255)

phonevarchar(20)

messagetext

preferred_contactvarchar(20)

statusvarchar(20)

contacted_attimestamp

created_attimestamp

updated_attimestamp

favorites

idinteger

user_emailvarchar(255)

listing_idinteger

FK*

created_attimestamp

open_houses

idinteger

listing_idinteger

FK*

start_timetimestamp

end_timetimestamp

descriptiontext

attendee_countinteger

created_attimestamp

updated_attimestamp

React Flow

About this Schema

Overview

Real estate listing platform schema for properties, agents, and buyers. Manages property listings, agent/agency relationships, buyer inquiries, saved searches, open houses, and price tracking.

Key Design Decisions

Agent Hierarchy: Agents belong to agencies with commission splits
Property Details: Comprehensive property attributes and media
Inquiry Tracking: Lead management for agents
Price History: Track listing price changes over time

Tables

12 tables covering properties, agents, agencies, inquiries, favorites, open houses, showings, and price history. Complete MLS-style platform.

Comments

Loading comments...