app.usage_rollups
TableRow level security on
Closed monthly usage totals per org and meter: the billing record reported to Stripe. Written once by the monthly rollup after the month ends and kept after the usage events age out (stored total registered in the denormalization register).
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org. A row never moves to another org.References app.organizations.id |
| meter_code | text | No | Meter.References private.usage_meters.code |
| period_start | date | No | First day of the month the total covers (UTC). |
| quantity | bigint | No | Total usage in the month, summed from usage_events when the month closed. |
| closed_at | timestamp with time zone | No | When the total was computed. |
| reported_at | timestamp with time zone | Yes | When the total was reported to Stripe. |
| stripe_usage_record_id | text | Yes | Stripe usage record id returned on reporting. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |