app.addon_purchases
TablaSeguridad a nivel de fila activa
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.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org. A row never moves to another org.Hace referencia a 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.Hace referencia a 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 | Sí | Person who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Sí | Person who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| deleted_at | timestamp with time zone | Sí | Soft delete time. A row with deleted_at set is ignored by every access helper. |