Description:
Holds localized text resources (name/description strings) keyed by code, language, and country. These resources provide the translated name and description strings referenced from vouchers and voucherables (resolved by code, language, and country).
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the message resource. |
code |
TEXT | Resource code used to look up the localized value (e.g. from a voucher or voucherable). |
language |
TEXT | Language of the localized value. |
country |
TEXT | Country of the localized value. |
value |
TEXT | The localized text (name or description). |
created_at |
TIMESTAMP_TZ | Timestamp when the resource was created. |
updated_at |
TIMESTAMP_TZ | Timestamp when the resource was last updated. |
created_by |
NUMBER | Identifier of the user who created the resource. |
updated_by |
NUMBER | Identifier of the user who last updated the resource. |
area |
NUMBER | The area the resource applies to: 0 = APP, 1 = DASHBOARD, 2 = CORE, 3 = SHARED. |
area_name |
TEXT | String label for area. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |