Skip to main content
The Schema tab lists every table and column in the snapshot. Search by table or column name. Hover a column for a short description. Open Prism and choose Schema. You do not need to memorise this page — use the tab while you write SQL.

​
Amounts and times

Money columns are integers in the smallest currency unit (pence for GBP). Divide by 100 when you want pounds. Timestamps are UTC.

​
Tenancies and applications

An application is the leasing pipeline. A tenancy is the agreement once that pipeline has created one. Join them with tenancies.application_id = applications.id.
  • Use tenancies for rent roll and occupancy.
  • Use applications for conversion funnels and open pipeline steps.

​
Tables

​
Portfolio

  • buildings — Properties in the portfolio.
  • units — Lettable units within buildings. Status is occupied, available, or maintenance.
  • tenancies — Agreements with a start date, optional end date, and normalised monthly rent. Status is pending, active, complete, or canceled.

​
Leasing

  • applications — Pipeline records. Use open and current_step_type for funnels. type includes standard and renewal.

​
Billing

  • customers — People and companies you bill, let to, or otherwise hold on file.
  • invoices — Invoices issued to customers, including rent, charges, and one-off bills. Status includes draft, open, paid, uncollectible, and void.
  • invoice_items — Line items on invoices, including transfer behaviour.
  • subscriptions — Recurring billing agreements, typically rent.
  • subscription_items — Line items on subscriptions.
  • payments — Collected payments. Amounts are in pence.
  • refunds — Refunds against payments.
  • credit_notes — Credit notes against invoices.

​
Finance

  • balance_transactions — Movements on the Yorlet balance, including fees and payouts.
  • payouts — Payouts from the Yorlet balance to your bank account.

​
Owners

  • owners — Landlord, leaseholder, and supplier records.
  • owner_payouts — Payouts from owner balances to owner bank accounts.

​
Maintenance

  • maintenance_issues — Repair issues against units. Status is open, in_progress, or resolved.
Every table includes account_id. In organisation view, use it to split results by account after you set query scope.