bridge_customer_to_customer_code


Description

Link customer to all his customer codes.

Columns

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

The primary key of the table. System column calculated by the source System.
customer_id int8 19 √ null
dim_customer.customer_id erp_v2_bridge_customer_to_customer_code_customer_id__erp_v2_dim_customer_customer_id_fkey_6d686c59d642 R

The customer this customer code is assigned to.
customer_code_id int8 19 √ null
dim_customer_code.customer_code_id erp_v2_bridge_customer_to_customer_code_customer_code_id__erp_v2_dim_customer_code_customer_code_id_fkey_60a1d958f68c R

The customer code that this customer is assigned to.
last_updated timestamptz 35 √ null

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

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation