logo
ExamplesEditorPricingDocs
37.1kSign in

Rental property management database schema

Landlord operations modelled end to end: buildings and units, leases and renewals, co-tenants and guarantors, rent charges generated per period, payments allocated against them, deposits held and returned, maintenance with vendors, and inspections.

Property Management ER diagram

Rental property management database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 11 n1 n1 n1 n1 n1 n1 n1 n1 n1 buildings idBIGINT building_codeVARCHAR nameVARCHAR address_line1VARCHAR cityVARCHAR regionVARCHAR postcodeVARCHAR country_codeCHAR timezoneVARCHAR year_builtSMALLINT total_unitsINTEGER common_area_sqmNUMERIC manager_nameVARCHAR acquired_onDATE units idBIGINT building_idBIGINT unit_numberVARCHAR floorSMALLINT bedroomsSMALLINT bathroomsNUMERIC floor_area_sqmNUMERIC market_rent_minorBIGINT currency_codeCHAR statusVARCHAR is_furnishedBOOLEAN parking_spacesSMALLINT tenants idBIGINT tenant_referenceVARCHAR full_nameVARCHAR emailVARCHAR phoneVARCHAR date_of_birthDATE emergency_contact…VARCHAR emergency_contact…VARCHAR screening_statusVARCHAR screening_complet…TIMESTAMPTZ created_atTIMESTAMPTZ leases idBIGINT unit_idBIGINT lease_referenceVARCHAR statusVARCHAR renewed_from_leas…BIGINT term_startDATE term_endDATE rent_amount_minorBIGINT currency_codeCHAR billing_periodVARCHAR rent_due_daySMALLINT deposit_amount_mi…BIGINT late_fee_minorBIGINT grace_period_daysSMALLINT notice_period_daysSMALLINT signed_atTIMESTAMPTZ terminated_onDATE termination_reasonVARCHAR lease_tenants lease_idBIGINT tenant_idBIGINT roleVARCHAR liability_share_b…INTEGER is_primary_contactBOOLEAN added_onDATE removed_onDATE rent_charges idBIGINT lease_idBIGINT charge_kindVARCHAR period_startDATE period_endDATE due_onDATE amount_minorBIGINT currency_codeCHAR paid_minorBIGINT statusVARCHAR is_proratedBOOLEAN allocation_basisVARCHAR source_referenceVARCHAR generated_atTIMESTAMPTZ payments idBIGINT lease_idBIGINT paid_by_tenant_idBIGINT amount_minorBIGINT currency_codeCHAR methodVARCHAR external_referenceVARCHAR received_onDATE unallocated_minorBIGINT statusVARCHAR notesVARCHAR payment_allocations idBIGINT payment_idBIGINT charge_idBIGINT amount_minorBIGINT allocated_atTIMESTAMPTZ allocation_ruleVARCHAR reversed_atTIMESTAMPTZ security_deposits idBIGINT lease_idBIGINT amount_held_minorBIGINT currency_codeCHAR received_onDATE scheme_nameVARCHAR scheme_referenceVARCHAR protected_onDATE statusVARCHAR deductions_minorBIGINT deduction_reasonTEXT returned_minorBIGINT returned_onDATE vendors idBIGINT vendor_codeVARCHAR nameVARCHAR tradeVARCHAR emailVARCHAR phoneVARCHAR hourly_rate_minorBIGINT currency_codeCHAR is_emergency_avai…BOOLEAN insurance_expires…DATE ratingNUMERIC is_activeBOOLEAN maintenance_requests idBIGINT unit_idBIGINT lease_idBIGINT reported_by_tenan…BIGINT categoryVARCHAR priorityVARCHAR descriptionTEXT access_instructio…VARCHAR statusVARCHAR is_tenant_respons…BOOLEAN reported_atTIMESTAMPTZ resolved_atTIMESTAMPTZ work_orders idBIGINT maintenance_reque…BIGINT unit_idBIGINT building_idBIGINT vendor_idBIGINT work_kindVARCHAR scopeTEXT quoted_cost_minorBIGINT actual_cost_minorBIGINT currency_codeCHAR statusVARCHAR scheduled_forTIMESTAMPTZ completed_atTIMESTAMPTZ completion_notesTEXT vendor_ratingSMALLINT inspections idBIGINT unit_idBIGINT lease_idBIGINT inspection_kindVARCHAR scheduled_forDATE notice_given_onDATE performed_onDATE inspector_nameVARCHAR overall_conditionVARCHAR findingsTEXT report_document_k…VARCHAR tenant_acknowledg…TIMESTAMPTZ

Related database schemas

Oracle
Real estate

Mortgage origination and underwriting database schema

How a mortgage lender models a file in Oracle: borrowers and co-borrowers with income and liabilities, the subject property and its appraisals, rate locks that expire, underwriting decisions and conditions to clear, a document checklist, closing and disbursement.

PostgreSQL
Real estate

Property portal and real estate listings database schema

How a property portal models its data: properties as durable things versus listings as repeatable campaigns, agents and agencies, ordered media, amenities, price history as rows, viewings, offers and saved searches with alerts.

PostgreSQL
Logistics

Vehicle fleet management database schema

How a vehicle fleet is modelled: vehicles and drivers, licence entitlements with expiry, assignment history, downsampled telematics and fault codes, maintenance due by mileage or date, work orders and parts, fuel, inspections and incidents.

SQL Server
Healthcare

Health insurance claims processing database schema

Payer-side claims processing in SQL Server: plans with benefit rules, policies covering members and dependents, provider network tiers, claims with service lines, per-line adjudication, coded denials, appeals, explanations of benefits and remittance to providers.