fct_contract


Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_id int8 19 null
fct_contract.main_contract_id fct_contract_main_contract_id_fkey R
fct_contract_price_history.contract_id fct_contract_price_history_contract_id_fkey R
fct_contract_term_dates.contract_id fct_contract_term_dates_contract_id_fkey R
fct_contract_voucher.contract_id fct_contract_voucher_contract_id_fkey R
fct_idle_period.contract_id fct_idle_period_contract_id_fkey R
fct_revenue.contract_id Implied Constraint R
fct_revenue_cash_based.contract_id Implied Constraint R
imported_contract_number varchar 256 √ null
third_party_id varchar 256 √ null
main_contract_id int8 19 √ null
fct_contract.contract_id fct_contract_main_contract_id_fkey R
is_reversed bool 1 √ null
created_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
start_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
start_date_of_use_id int4 10 √ null
end_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
cancellation_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
cancellation_receipt_date_id int8 19 √ null
pre_cancellation_end_date_id int8 19 √ null
rate_id int8 19 √ null
dim_rate.rate_id Implied Constraint R
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id Implied Constraint R
employee_id int8 19 √ null
dim_employee.employee_id Implied Constraint R
customer_id int8 19 √ null
dim_customer.customer_id Implied Constraint R
contract_property_id varchar 256 √ null
dim_contract_property.contract_property_id Implied Constraint R
contract_term_id varchar 256 √ null
dim_contract_term.contract_term_id Implied Constraint R
contract_cancellation_reason_id varchar 256 √ null
dim_contract_cancellation_reason.contract_cancellation_reason_id Implied Constraint R
company_id int8 19 √ null
dim_company.company_id Implied Constraint R
contract_payment_frequency_id varchar 256 √ null
dim_contract_payment_frequency.contract_payment_frequency_id Implied Constraint R
cancellation_fee numeric 23,6 √ null
original_monthly_price float8 17,17 √ null
current_monthly_price float8 17,17 √ null
original_total_price float8 17,17 √ null
last_date_before_contract_renewal date 13 √ null
last_updated timestamptz 35 √ null

Relationships

Close relationships within degrees of separation