fct_contract_term_dates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_term_id int8 19 null
contract_id int8 19 √ null
fct_contract.contract_id erp_v2_fct_contract_term_dates_contract_id__erp_v2_fct_contract_contract_id_fkey_212b7c43ac65 R
customer_id int8 19 √ null
dim_customer.customer_id fct_contract_term_dates_customer_id_fkey R
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id fct_contract_term_dates_organization_unit_id_fkey R
start_date date 13 √ null
end_date date 13 √ null
last_updated timestamptz 35 √ null
data_landing_time timestamptz 35 getdate()

Relationships

Close relationships within degrees of separation