Description:
Tracks subscriptions purchased by users (gusers). Records details about purchase, validity, renewal, and cancellation, as well as links to related balances and subscriptions.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the user subscription record. |
created_at |
TIMESTAMP_TZ | Timestamp when the subscription record was created. |
updated_at |
TIMESTAMP_TZ | Timestamp when the subscription record was last updated. |
guser_id |
NUMBER | Identifier of the user who owns the subscription. |
balance_id |
NUMBER | Identifier of the balance used to pay for the subscription. |
subscription_id |
NUMBER | Identifier of the subscription plan. |
bought_at |
TIMESTAMP_TZ | Timestamp when the subscription was purchased. |
valid_until |
TIMESTAMP_TZ | Expiration date/time of the subscription. |
state |
TEXT | Subscription state (stored as text). Values: RENEWING, EXPIRED, SWITCHING, SWITCHED, CANCELLED. |
auto_renewal |
NUMBER | Legacy flag indicating whether the subscription is set to automatically renew. |
canceled |
BOOLEAN | Indicates whether the subscription has been canceled. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | Timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | Timestamp of last record update in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |