app.addon_purchases
TableRow level security on
One-time add-ons an org paid for through Stripe Checkout, such as an Aurora request pack (ADR 0035). Each raises its limit for the UTC calendar month it was paid in. Written once per Checkout session by app.record_addon_purchase_from_stripe; append-only.
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 |
| addon_code | text | No | Add-on code from packages/schemas/plans.yaml. |
| quantity | integer | No | Units bought. |
| applies_month | date | No | First day of the UTC calendar month the purchase raises the limit for. |
| stripe_checkout_session_id | text | No | Stripe Checkout session (cs_...) that was paid, unique. |
| currency_code | character(3) | No | Currency the org paid in.References private.currencies.currency_code |
| amount_total_minor | bigint | No | Amount paid in minor units, after discounts and before tax, as Stripe reports it. |
| livemode | boolean | No | True for live mode payments. |
| paid_at | timestamp with time zone | No | When Stripe completed the payment. |
| 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. |