dim_contract_voucher_definition_localized


Description

Localized text for contract voucher definitions, one row per definition per locale. Includes the public-facing name and description shown to members, plus the staff-only internal description used to categorise a promotion or voucher (not visible to members).

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_voucher_definition_localized_id varchar 256 null

The primary key of this table. Surrogate key derived from (contract_voucher_definition_id, locale).
contract_voucher_definition_id int8 19 √ null
dim_contract_voucher_definition.contract_voucher_definition_id dim_contract_voucher_definition_localized_contract_voucher_definition_id_fkey R

The contract voucher definition this translation belongs to.
locale varchar 256 √ null

The locale representing the language and region for which the voucher definition is translated, formatted as a combination of ISO-639 language code and ISO-3166 country code (e.g., de_DE).
public_name varchar 65535 √ null

The public-facing name of the voucher definition shown to members, for this locale.
description varchar 65535 √ null

The public-facing description of the voucher definition shown to members, for this locale.
sub_description varchar 65535 √ null

A secondary, public-facing description of the voucher definition shown to members, for this locale.
footnote varchar 65535 √ null

Footnote text associated with the voucher definition, shown to members, for this locale.
contract_remarks varchar 65535 √ null

Remarks shown on the contract document for this voucher definition, for this locale.
internal_description varchar 65535 √ null

A description that can categorise or annotate this voucher definition/promotion. Not visible to members. Truncated to 650 characters to fit Redshift column constraints.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).

Relationships

Close relationships within degrees of separation