fct_contract


Columns

Column Type Size Nulls Auto Default Children Parents Comments
contract_id int8 19 null
dim_customer_group.contract_id Implied Constraint R
fct_contract_price_history.contract_id Implied Constraint R
fct_contract_term_dates.contract_id Implied Constraint R
fct_contract_voucher.contract_id Implied Constraint R
fct_idle_period.contract_id Implied Constraint R
fct_invoice.contract_id Implied Constraint R
fct_revenue.contract_id Implied Constraint R
fct_revenue_cash_based.contract_id Implied Constraint R
fct_revenue_invoice_based.contract_id Implied Constraint R
imported_contract_number varchar 256 √ null
third_party_id varchar 256 √ null
main_contract_id int8 19 √ null
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
first_booking_date date 13 √ null
cancellation_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
cancellation_receipt_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
pre_cancellation_end_date_id int4 10 √ null
dim_date.date_id Implied Constraint R
rate_id int8 19 √ null
dim_rate.rate_id fct_contract_rate_id_fkey R
organization_unit_id int8 19 √ null
dim_organization_unit.organization_unit_id fct_contract_organization_unit_id_fkey R
employee_id int8 19 √ null
dim_employee.employee_id Implied Constraint R
customer_id int8 19 √ null
dim_customer.customer_id fct_contract_customer_id_fkey R
contract_property_id varchar 256 √ null
dim_contract_property.contract_property_id fct_contract_contract_property_id_fkey R
contract_term_id varchar 256 √ null
dim_contract_term.contract_term_id fct_contract_contract_term_id_fkey R
contract_cancellation_reason_id varchar 256 √ null
dim_contract_cancellation_reason.contract_cancellation_reason_id fct_contract_contract_cancellation_reason_id_fkey R
company_id int8 19 √ null
dim_company.company_id fct_contract_company_id_fkey R
discount_campaign_id int8 19 √ null
contract_payment_frequency_id varchar 256 √ null
dim_contract_payment_frequency.contract_payment_frequency_id fct_contract_contract_payment_frequency_id_fkey R
rate_bundle_term_id int8 19 √ null
dim_rate_bundle_term.rate_bundle_term_id Implied Constraint R
subsequent_contract_id int8 19 √ null
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