Description:
Links users (gusers) to their balances. Each record associates a user with a specific balance account, optionally scoped to a branch. Tracks creation, updates, and whether the balance is the user’s default.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the user–balance association. |
created_at |
TIMESTAMP_TZ | Timestamp when the record was created. |
updated_at |
TIMESTAMP_TZ | Timestamp when the record was last updated. |
guser_id |
NUMBER | Identifier of the user associated with the balance. |
balance_id |
NUMBER | Identifier of the balance account linked to the user. |
default_balance |
BOOLEAN | Indicates whether this balance is the user’s default balance. |
branch_id |
NUMBER | Identifier of the branch where this balance association is applicable. |
_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. |