> ## Documentation Index
> Fetch the complete documentation index at: https://docs.yorlet.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Schema

> See which tables Prism can query, how amounts are stored, and how tenancies relate to applications.

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](https://dashboard.yorlet.com/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](/prism/write-a-query#query-across-accounts).