fct_contract_term_dates


Description

Each individual contract term of a customer.

Columns

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

The primary key of this table. System column calculated by the source System.
contract_id int8 19 null
fct_contract.contract_id fct_contract_term_dates_contract_id_fkey R

Contract connected to this term
customer_id int8 19 null
dim_customer.customer_id fct_contract_term_dates_customer_id_fkey R

Customer that holds this contract
organization_unit_id int8 19 null
dim_organization_unit.organization_unit_id fct_contract_term_dates_organization_unit_id_fkey R

The gym (organization_unit) for which contract was generated.
start_date date 13 null
dim_date.date fct_contract_term_dates_start_date_fkey R

The date at which this contract term started.
end_date date 13 null
dim_date.date fct_contract_term_dates_end_date_fkey R

The date at which this contract term ended.
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