dim_customer_code


Description

Dimension table containing customer codes (tags) used to categorize customers. Customer codes help organize and filter customers based on business-defined categories. Each customer code has a unique identifier and can be associated with multiple customers.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
customer_code_id int8 19 null
bridge_customer_to_customer_code.customer_code_id bridge_customer_to_customer_code_customer_code_id_fkey R

Unique identifier for the customer code (primary key)
name varchar 256 √ null

Display name of the customer code
description varchar 256 √ null

Detailed description of the customer code purpose and usage. Defaults to ‘UNKNOWN’ if not provided.
color_hex varchar 256 √ null

Hexadecimal color code for visual representation of the customer code in UI
active bool 1 √ null

Indicates if the customer code is currently active and available for use
archived bool 1 √ null

Indicates if the customer code has been archived and is no longer in regular use
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