🏢 Real Estate & PropTech · Database ERD
Property Management Database Schema
A schema for property management: properties, units, owners, tenants, leases, rent invoices and maintenance requests.
Drawing diagram…
What this diagram shows
- A property has many units; each unit has one active lease
- Rent invoices are generated from lease terms
- Tenants raise maintenance requests per unit
Prompt used
ERD for property management: Owner owns Properties; Property has Units; Lease links a Unit and a Tenant with rent, deposit and dates; RentInvoice is generated monthly per Lease and settled by Payments; MaintenanceRequest is raised by a Tenant for a Unit and assigned to a Vendor.
Mermaid code
erDiagram
OWNER ||--o{ PROPERTY : owns
PROPERTY ||--|{ UNIT : contains
UNIT ||--o{ LEASE : "leased via"
TENANT ||--o{ LEASE : signs
LEASE ||--o{ RENT_INVOICE : bills
RENT_INVOICE ||--o{ PAYMENT : "paid by"
UNIT ||--o{ MAINTENANCE_REQUEST : raises
VENDOR ||--o{ MAINTENANCE_REQUEST : handles
UNIT {
int id PK
int property_id FK
string unit_no
decimal area_sqft
}
LEASE {
int id PK
int unit_id FK
int tenant_id FK
decimal monthly_rent
decimal deposit
date start_date
date end_date
}
RENT_INVOICE {
int id PK
int lease_id FK
string month
decimal amount
string status
}Related templates
Property Listing Platform Architecture
A real estate marketplace: listings by owners and brokers, search with maps, lead capture and site-visit booking.
Rental Application Workflow
A tenant's path from enquiry to moving in: site visit, application, verification, agreement and deposit.
Property Site Visit Booking
How a home buyer books a site visit from a listing: slot selection, broker confirmation, reminders and feedback after the visit.
Lease Lifecycle
The states of a residential or commercial lease: drafting, signing, active tenancy, renewal, notice and move-out settlement.
Smart Building Access Control Network
The network behind secure building access: card and mobile readers, turnstiles, lifts, visitor kiosks and CCTV on a separate security network.
Home Purchase and Loan Sequence
The steps between buyer, builder, bank and registrar when buying a new flat with a home loan.