fct_contract_term_dates


Description

Contract term dates fact table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_term_id varchar 256 √ null
dim_contract_term.contract_term_id Implied Constraint R

Primary key for contract term
contract_id varchar 256 √ null
fct_contract.contract_id fct_contract_term_dates_contract_id_fkey R

Foreign key to contract
customer_id varchar 256 √ null
dim_customer.customer_id fct_contract_term_dates_customer_id_fkey R

Foreign key to customer
start_date varchar 256 √ null

Contract term start date
end_date varchar 256 √ null

Contract term end date
last_updated timestamptz 35 √ null

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

Relationships

Close relationships within degrees of separation