fct_contract_term_dates

-1 rows


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