214 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fct_trainer_class_appointments_trainer_appointment_status_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_class_appointments_appointment_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_class_appointments_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_class_appointments_start_date_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_class_appointments_employee_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_class_appointments_class_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_class_appointments_end_date_id_fkey |
|
|
Restrict delete | ||
| dim_discount_campaign_discount_period_discount_campaign_scope_id_fkey |
|
|
Restrict delete | ||
| dim_discount_campaign_discount_period_discount_campaign_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_payment_run_currency_id__erp_v2_dim_currency_currency_id_fkey_3e612dd303a5 |
|
|
Restrict delete | ||
| erp_v2_fct_payment_run_payment_run_property_id__erp_v2_dim_payment_run_property_payment_run_property_id_fkey_c34472c8a249 |
|
|
Restrict delete | ||
| erp_v2_fct_payment_run_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_6234eded60eb |
|
|
Restrict delete | ||
| erp_v2_fct_payment_run_customer_id__erp_v2_dim_customer_customer_id_fkey_8bd139378cfb |
|
|
Restrict delete | ||
| dim_contract_voucher_definition_rate_id_fkey |
|
|
Restrict delete | ||
| dim_contract_voucher_definition_campaign_id_fkey |
|
|
Restrict delete | ||
| dim_contract_voucher_definition_company_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_cash_based_currency_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_cash_based_customer_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_cash_based_contract_id__erp_v2_fct_contract_contract_id_fkey_c182b8d8ecd4 |
|
|
Restrict delete | ||
| fct_revenue_cash_based_product_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_cash_based_revenue_group_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_cash_based_organization_unit_id_fkey |
|
|
Restrict delete | ||
| dim_purchased_contingent_customer_id_fkey |
|
|
Restrict delete | ||
| dim_purchased_contingent_service_id_fkey |
|
|
Restrict delete | ||
| dim_purchased_contingent_product_id_fkey |
|
|
Restrict delete | ||
| dim_purchased_contingent_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_customer_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_start_date_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_currency_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_organization_unit_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_idle_period_contract_id__erp_v2_fct_contract_contract_id_fkey_310391a1376b |
|
|
Restrict delete | ||
| fct_idle_period_rate_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_shared_contract_idle_period_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_end_date_id_fkey |
|
|
Restrict delete | ||
| dim_customer_dunning_configuration_customer_id_fkey |
|
|
Restrict delete | ||
| dim_customer_group_member_discount_customer_group_id_fkey |
|
|
Restrict delete | ||
| dim_studio_starter_package_adjustment_organization_unit_id_fkey |
|
|
Restrict delete | ||
| dim_studio_starter_package_adjustment_rate_term_configuration_id_fkey |
|
|
Restrict delete | ||
| dim_studio_starter_package_adjustment_rate_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_pos_saleposition_cash_register_id__erp_v2_dim_cash_register_cash_register_id_fkey_9dc8c20076bd |
|
|
Restrict delete | ||
| fct_pos_saleposition_organization_unit_id_fkey |
|
|
Restrict delete | ||
| bridge_organization_unit_to_organization_unit_code_organization_unit_code_id_fkey |
|
|
Restrict delete | ||
| bridge_organization_unit_to_organization_unit_code_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_rate_term_payment_frequency_price_adjustment_rate_term_configuration_id_fkey |
|
|
Restrict delete | ||
| fct_rate_term_payment_frequency_price_adjustment_rate_id_fkey |
|
|
Restrict delete | ||
| fct_rate_term_payment_frequency_price_adjustment_rate_term_payment_frequency_id_fkey |
|
|
Restrict delete | ||
| bridge_rate_bundle_to_company_company_id_fkey |
|
|
Restrict delete | ||
| bridge_rate_bundle_to_company_rate_bundle_id_fkey |
|
|
Restrict delete | ||
| dim_rate_term_configuration_rate_id_fkey |
|
|
Restrict delete | ||
| dim_rate_localized_rate_id_fkey |
|
|
Restrict delete | ||
| fct_contract_voucher_contract_voucher_definition_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_contract_voucher_contract_id__erp_v2_fct_contract_contract_id_fkey_ba952ea0cd6e |
|
|
Restrict delete | ||
| fct_contract_voucher_company_id_fkey |
|
|
Restrict delete | ||
| fct_contract_voucher_campaign_id_fkey |
|
|
Restrict delete | ||
| bridge_rate_bundle_to_payment_choice_rate_bundle_id_fkey |
|
|
Restrict delete | ||
| bridge_rate_to_rate_code_rate_code_id_fkey |
|
|
Restrict delete | ||
| bridge_rate_to_rate_code_rate_id_fkey |
|
|
Restrict delete | ||
| fct_payment_instrument_status_history_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_payment_instrument_status_history_paying_customer_id_fkey |
|
|
Restrict delete | ||
| fct_payment_instrument_status_history_payment_instrument_id_fkey |
|
|
Restrict delete | ||
| fct_payment_instrument_status_history_customer_id_fkey |
|
|
Restrict delete | ||
| fct_rate_bundle_term_availability_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_rate_bundle_term_availability_rate_bundle_term_id_fkey |
|
|
Restrict delete | ||
| bridge_revenue_to_purchased_contingent_revenue_id_fkey |
|
|
Restrict delete | ||
| dim_contract_voucher_rate_discount_period_contract_voucher_definition_id_fkey |
|
|
Restrict delete | ||
| dim_contract_voucher_rate_discount_period_rate_id_fkey |
|
|
Restrict delete | ||
| dim_contract_voucher_rate_discount_period_contract_voucher_id_fkey |
|
|
Restrict delete | ||
| dim_contract_voucher_rate_discount_period_rate_term_configuration_id_fkey |
|
|
Restrict delete | ||
| dim_contract_voucher_rate_discount_period_rate_term_payment_frequency_id_fkey |
|
|
Restrict delete | ||
| dim_rate_bundle_term_rate_term_payment_frequency_id_fkey |
|
|
Restrict delete | ||
| dim_rate_bundle_term_rate_bundle_id_fkey |
|
|
Restrict delete | ||
| bridge_pos_saleposition_to_payment_pos_saleposition_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_invoice_product_id__erp_v2_dim_product_product_id_fkey_f56d6e53c597 |
|
|
Restrict delete | ||
| erp_v2_fct_invoice_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_66c6d57ea319 |
|
|
Restrict delete | ||
| erp_v2_fct_invoice_company_id__erp_v2_dim_company_company_id_fkey_744909276350 |
|
|
Restrict delete | ||
| erp_v2_fct_invoice_rate_id__erp_v2_dim_rate_rate_id_fkey_e147c9be7ad9 |
|
|
Restrict delete | ||
| erp_v2_fct_invoice_currency_id__erp_v2_dim_currency_currency_id_fkey_572bc6bb4efa |
|
|
Restrict delete | ||
| erp_v2_fct_invoice_customer_id__erp_v2_dim_customer_customer_id_fkey_6bae03ba04a1 |
|
|
Restrict delete | ||
| bridge_service_to_organization_unit_organization_unit_id_fkey |
|
|
Restrict delete | ||
| bridge_service_to_organization_unit_service_id_fkey |
|
|
Restrict delete | ||
| dim_rate_term_payment_frequency_rate_id_fkey |
|
|
Restrict delete | ||
| dim_rate_term_payment_frequency_rate_term_configuration_id_fkey |
|
|
Restrict delete | ||
| bridge_discount_campaign_to_organization_unit_organization_unit_id_fkey |
|
|
Restrict delete | ||
| bridge_discount_campaign_to_organization_unit_discount_campaign_id_fkey |
|
|
Restrict delete | ||
| fct_payment_customer_id_fkey |
|
|
Restrict delete | ||
| fct_payment_currency_id_fkey |
|
|
Restrict delete | ||
| fct_payment_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_class_appointment_end_date_id_fkey |
|
|
Restrict delete | ||
| fct_class_appointment_start_date_id_fkey |
|
|
Restrict delete | ||
| fct_class_appointment_appointment_id_fkey |
|
|
Restrict delete | ||
| fct_class_appointment_created_date_id_fkey |
|
|
Restrict delete | ||
| fct_class_appointment_class_id_fkey |
|
|
Restrict delete | ||
| fct_class_appointment_organization_unit_id_fkey |
|
|
Restrict delete | ||
| dim_payment_instrument_customer_id_fkey |
|
|
Restrict delete | ||
| dim_payment_instrument_paying_customer_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_invoice_based_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_f1c5bda0cb26 |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_invoice_based_product_id__erp_v2_dim_product_product_id_fkey_4a10cc383354 |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_invoice_based_revenue_group_id__erp_v2_dim_revenue_group_revenue_group_id_fkey_5faa1ef0796f |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_invoice_based_contract_id__erp_v2_fct_contract_contract_id_fkey_4059737dd498 |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_invoice_based_invoice_id__erp_v2_fct_invoice_invoice_id_fkey_316170475d2a |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_invoice_based_currency_id__erp_v2_dim_currency_currency_id_fkey_946272c93489 |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_invoice_based_customer_id__erp_v2_dim_customer_customer_id_fkey_324f3c30b638 |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_invoice_based_rate_id__erp_v2_dim_rate_rate_id_fkey_3aa5475d9fe8 |
|
|
Restrict delete | ||
| fct_class_event_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_class_event_start_date_id_fkey |
|
|
Restrict delete | ||
| fct_class_event_appointment_id_fkey |
|
|
Restrict delete | ||
| fct_class_event_class_id_fkey |
|
|
Restrict delete | ||
| fct_class_event_end_date_id_fkey |
|
|
Restrict delete | ||
| fct_class_event_event_date_id_fkey |
|
|
Restrict delete | ||
| fct_class_event_inclusive_contingent_id_fkey |
|
|
Restrict delete | ||
| fct_class_event_customer_id_fkey |
|
|
Restrict delete | ||
| erp_v2_dim_discount_campaign_localized_discount_campaign_id__erp_v2_dim_discount_campaign_discount_campaign_id_88507be14e5c |
|
|
Restrict delete | ||
| dim_cash_register_organization_unit_id_fkey |
|
|
Restrict delete | ||
| dim_idle_period_property_organization_unit_id_fkey |
|
|
Restrict delete | ||
| dim_closing_hours_organization_unit_id_fkey |
|
|
Restrict delete | ||
| dim_contract_voucher_definition_localized_contract_voucher_definition_id_fkey |
|
|
Restrict delete | ||
| dim_discount_campaign_scope_discount_campaign_id_fkey |
|
|
Restrict delete | ||
| dim_discount_campaign_scope_rate_bundle_id_fkey |
|
|
Restrict delete | ||
| dim_discount_campaign_scope_rate_bundle_term_id_fkey |
|
|
Restrict delete | ||
| fct_employee_access_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_employee_access_employee_id_fkey |
|
|
Restrict delete | ||
| fct_lead_stage_history_customer_id_fkey |
|
|
Restrict delete | ||
| fct_lead_stage_history_loss_reason_id_fkey |
|
|
Restrict delete | ||
| fct_lead_stage_history_previous_lead_stage_history_id_fkey |
|
|
Restrict delete | ||
| fct_lead_stage_history_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_lead_stage_history_lead_stage_id_fkey |
|
|
Restrict delete | ||
| bridge_customer_group_to_customer_customer_group_id_fkey |
|
|
Restrict delete | ||
| bridge_customer_group_to_customer_customer_id_fkey |
|
|
Restrict delete | ||
| fct_dunning_step_customer_id_fkey |
|
|
Restrict delete | ||
| fct_dunning_step_previous_dunning_step_id_fkey |
|
|
Restrict delete | ||
| fct_dunning_step_dunning_level_id_fkey |
|
|
Restrict delete | ||
| dim_cancellation_reason_localized_cancellation_reason_id_fkey |
|
|
Restrict delete | ||
| fct_customer_studio_history_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_customer_studio_history_customer_id_fkey |
|
|
Restrict delete | ||
| erp_v2_dim_contract_cancellation_reason_cancellation_reason_id__erp_v2_dim_cancellation_reason_cancellation_re_644d1c4c8bb7 |
|
|
Restrict delete | ||
| dim_opening_hours_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_appointment_id_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_customer_id_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_inclusive_contingent_id_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_service_id_fkey |
|
|
Restrict delete | ||
| bridge_customer_to_customer_code_customer_code_id_fkey |
|
|
Restrict delete | ||
| bridge_customer_to_customer_code_customer_id_fkey |
|
|
Restrict delete | ||
| fct_checkin_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_checkin_customer_id_fkey |
|
|
Restrict delete | ||
| fct_checkin_customer_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_checkin_checkout_date_id_fkey |
|
|
Restrict delete | ||
| fct_checkin_device_id_fkey |
|
|
Restrict delete | ||
| fct_checkin_checkin_date_id_fkey |
|
|
Restrict delete | ||
| bridge_discount_campaign_to_allowed_origin_type_discount_campaign_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_currency_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_customer_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_pre_cancellation_end_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_cancellation_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_contract_end_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_rate_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_cancellation_reason_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_cancellation_receipt_date_id_fkey |
|
|
Restrict delete | ||
| dim_product_service_id_fkey |
|
|
Restrict delete | ||
| fct_lead_lifetime_campaign_id_fkey |
|
|
Restrict delete | ||
| fct_lead_lifetime_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_lead_lifetime_customer_id_fkey |
|
|
Restrict delete | ||
| fct_lead_lifetime_lead_stage_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_appointment_employee_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_appointment_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_appointment_appointment_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_appointment_service_id_fkey |
|
|
Restrict delete | ||
| bridge_product_to_organization_unit_organization_unit_id_fkey |
|
|
Restrict delete | ||
| bridge_product_to_organization_unit_product_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_contract_main_contract_id__erp_v2_fct_contract_contract_id_fkey_3bac2f809e19 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_contract_property_id__erp_v2_dim_contract_property_contract_property_id_fkey_ed2c046c6e2a |
|
|
Restrict delete | ||
| erp_v2_fct_contract_subsequent_contract_id__erp_v2_fct_contract_contract_id_fkey_067fa8c35887 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_contract_term_id__erp_v2_dim_contract_term_contract_term_id_fkey_313196804702 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_rate_bundle_term_id__erp_v2_dim_rate_bundle_term_rate_bundle_term_id_fkey_4651a84a9af7 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_b1c3c75d1a29 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_discount_campaign_id__erp_v2_dim_discount_campaign_discount_campaign_id_fkey_acd88b13dfa5 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_contract_cancellation_reason_id__erp_v2_dim_contract_cancellation_reason_contract_cancella_2593f16b1f8a |
|
|
Restrict delete | ||
| erp_v2_fct_contract_customer_id__erp_v2_dim_customer_customer_id_fkey_37033086980d |
|
|
Restrict delete | ||
| erp_v2_fct_contract_contract_payment_frequency_id__erp_v2_dim_contract_payment_frequency_contract_payment_freq_9af692569944 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_rate_id__erp_v2_dim_rate_rate_id_fkey_6c24ad00ff02 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_company_id__erp_v2_dim_company_company_id_fkey_8ca1239364d9 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_employee_id__erp_v2_dim_employee_employee_id_fkey_54e92a4e8fd8 |
|
|
Restrict delete | ||
| fct_customer_referral_referred_customer_id_fkey |
|
|
Restrict delete | ||
| fct_customer_referral_referring_customer_id_fkey |
|
|
Restrict delete | ||
| dim_customer_custom_field_customer_id_fkey |
|
|
Restrict delete | ||
| dim_customer_communication_consent_organization_unit_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_contract_price_history_contract_id__erp_v2_fct_contract_contract_id_fkey_7ec3efc38ad2 |
|
|
Restrict delete | ||
| fct_contract_price_history_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_contract_price_history_customer_id_fkey |
|
|
Restrict delete | ||
| fct_service_usage_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_service_usage_service_id_fkey |
|
|
Restrict delete | ||
| fct_service_usage_employee_id_fkey |
|
|
Restrict delete | ||
| fct_service_usage_device_id_fkey |
|
|
Restrict delete | ||
| fct_service_usage_customer_id_fkey |
|
|
Restrict delete | ||
| fct_service_usage_inclusive_contingent_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_revenue_group_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_rate_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_accounting_date_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_currency_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_product_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_customer_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_contract_id__erp_v2_fct_contract_contract_id_fkey_c41c7b632840 |
|
|
Restrict delete | ||
| bridge_company_to_organization_unit_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_contract_term_dates_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_contract_term_dates_customer_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_contract_term_dates_contract_id__erp_v2_fct_contract_contract_id_fkey_212b7c43ac65 |
|
|
Restrict delete | ||
| fct_rate_term_payment_frequency_price_rate_term_payment_frequency_id_fkey |
|
|
Restrict delete | ||
| fct_rate_term_payment_frequency_price_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_rate_term_payment_frequency_price_rate_id_fkey |
|
|
Restrict delete | ||
| fct_rate_term_payment_frequency_price_rate_term_configuration_id_fkey |
|
|
Restrict delete | ||
| erp_v2_dim_customer_group_contract_id__erp_v2_fct_contract_contract_id_fkey_f3bb8a9435ed |
|
|
Restrict delete | ||
| dim_customer_group_organization_unit_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|