Skip to content

real_estate

sqllocks_spindle.domains.real_estate

Real estate domain — properties, listings, transactions, and inspections.

Classes

RealEstateDomain

Bases: Domain

Real estate domain — properties, listings, transactions, and inspections.

Available schema modes
  • 3nf: Normalized schema with proper 3NF relationships

Tables (3NF mode): - neighborhood: Neighborhoods with demographics - agent: Real estate agents - property: Physical properties - listing: MLS listings - showing: Property showings - offer: Purchase offers - transaction: Closed sales - inspection: Property inspections - appraisal: Property appraisals

Methods:
star_schema_map()

Return the star schema mapping for the Real Estate domain.

Produces
  • dim_property (from property, enriched with neighborhood)
  • dim_agent (from agent)
  • dim_listing (from listing)
  • dim_date (generated from close_date / showing_date)
  • fact_transaction (from transaction)
  • fact_showing (from showing)
cdm_map()

Return the CDM entity map for the Real Estate domain.