Database schema

╔══════════════════════════════════════════════════════════════════════════════╗
║              PMS · DATABASE SCHEMA · overview                                ║
╚══════════════════════════════════════════════════════════════════════════════╝

Generated : 2026-07-30 10:17:03 UTC
Audience  : Public overview (authorized operators see full detail in-console)
Product   : rolling updates from source — one live operator console

WHAT THIS PAGE IS
─────────────────
  Conceptual model of how books hang together: entities, rent money path,
  and work orders. Enough for a prospect or partner to trust the design.

WHAT THIS PAGE IS NOT
─────────────────────
  Not a full DDL dump, API surface, or migration kit. Exact columns,
  keys, and constraint graphs stay in the authenticated operator wiki.

SUMMARY
───────
  Base tables : 15    Reporting views : 3

DOMAIN MAPS
════════════════════════════════════════════════════════════════════════════

  Tagline: ledger is truth · owner statements read signed ledger activity only

  1) ENTITY SPINE
  ───────────────
      owners (bill-to)
         │ 1:N
         v
      properties ──1:N──► units
         │                  │
         │                  ├── leases ──N:1──► tenants
         │                  │
         │                  └── work_orders (also property-level work ok)
         │
         └── property = economic control for one bill-to owner

  2) MONEY SPINE
  ──────────────
      leases → invoices (tenant AR) → payments
                    │
                    └──► owner ledger (rent collected +, management fee −)
      work orders + expenses → bill owner → owner ledger (expense −)

      Owner packages show period activity from the ledger — not invented
      opening balances or archaeology from old spreadsheets.

  3) OPS SPINE
  ────────────
      work_orders → expenses → complete → bill → owner ledger

  LEDGER SIGNS (owner point of view)
  ──────────────────────────────────
      rent collected + · completed work billed − · management fee −
      Net = sum of signed period activity

TABLE FAMILIES (names only)
════════════════════════════════════════════════════════════════════════════
  Core              leases, owners, properties, tenants, units
  AR (tenant)       invoices, payments
  Ledger (owner)    owner_transactions
  Ops               expenses, work_orders
  Config            settings, system_settings
  Platform          notes, runtime_telemetry, update_versions

REPORTING VIEWS (names only)
────────────────────────────────────────────────────────────────────────────
  • property_lease_invoice_summary
  • unit_lease_summary
  • vacant_units

VISUAL RELATIONSHIP (overview)
════════════════════════════════════════════════════════════════════════════

      owners ──► properties ──► units ──► leases ──► tenants
                      │            │
                      │            └──► work_orders ──► expenses
                      │                      │
                      v                      v
               owner ledger ◄──── rent payments / billed work

NOTES
─────
  • Cold start: books go forward from an agreed go-live month.
  • Full column inventory and foreign keys: operator console wiki
    (authenticated) — System → Wiki → Database Schema.
  • Public docs intentionally omit constraint-level detail.