fct_customer_studio_history


Description

Tracks the history of customers’ associations with studios over time, including start and end dates of these relationships.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
customer_studio_history_id int8 19 null

The primary key of this table.
customer_id int8 19 null
dim_customer.customer_id fct_customer_studio_history_customer_id_fkey R

The customer who has a relationship with the studio.
organization_unit_id int8 19 null
dim_organization_unit.organization_unit_id fct_customer_studio_history_organization_unit_id_fkey R

The studio (organization unit) that the customer is associated with.
start_date date 13 √ null
dim_date.date fct_customer_studio_history_start_date_fkey R

The date when the customer’s relationship with this studio began.
end_date date 13 √ null
dim_date.date fct_customer_studio_history_end_date_fkey R

The date when the customer’s relationship with this studio ended. NULL indicates the relationship is still active.
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