dim_customer_code

-1 rows


Description

A tag or ‘member code’ set on customers to organize them into groups.

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

The primary key of this table. System column calculated by the source System.
name varchar 256 null

The name of the customer code.
description varchar 256 null

The description of the customer code.
color_hex varchar 256 √ null

The color of the customer code in hexadecimal format displayed on the UI.
active bool 1 null

Whether the customer code currently is assignable to customers.
archived bool 1 null

Permanently removed but kept for historic relations.
last_updated timestamptz 35 √ null

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

Relationships

Close relationships within degrees of separation