214 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fct_trainer_class_appointments_trainer_appointment_status_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_trainer_class_appointments_appointment_id__erp_v2_dim_appointment_appointment_id_fkey_03e54edf990b |
|
|
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_end_date_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_trainer_class_appointments_class_id__erp_v2_dim_class_class_id_fkey_40aa8e71a982 |
|
|
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 | ||
| erp_v2_fct_revenue_cash_based_currency_id__erp_v2_dim_currency_currency_id_fkey_2b0e240e4321 |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_cash_based_revenue_group_id__erp_v2_dim_revenue_group_revenue_group_id_fkey_cb3674ae5b59 |
|
|
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_organization_unit_id_fkey |
|
|
Restrict delete | ||
| erp_v2_dim_purchased_contingent_service_id__erp_v2_dim_service_service_id_fkey_abb1fd04e195 |
|
|
Restrict delete | ||
| erp_v2_dim_purchased_contingent_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_58fc0abfa10c |
|
|
Restrict delete | ||
| erp_v2_dim_purchased_contingent_customer_id__erp_v2_dim_customer_customer_id_fkey_3991af1b86ab |
|
|
Restrict delete | ||
| erp_v2_dim_purchased_contingent_product_id__erp_v2_dim_product_product_id_fkey_f5546ee4072d |
|
|
Restrict delete | ||
| fct_idle_period_customer_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_idle_period_currency_id__erp_v2_dim_currency_currency_id_fkey_331a01d0c42d |
|
|
Restrict delete | ||
| fct_idle_period_start_date_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 | ||
| erp_v2_fct_payment_instrument_status_history_payment_instrument_id__erp_v2_dim_payment_instrument_payment_inst_c713c4fa9637 |
|
|
Restrict delete | ||
| erp_v2_fct_payment_instrument_status_history_organization_unit_id__erp_v2_dim_organization_unit_organization_u_0950a3274251 |
|
|
Restrict delete | ||
| erp_v2_fct_payment_instrument_status_history_paying_customer_id__erp_v2_dim_customer_customer_id_fkey_5618b8434946 |
|
|
Restrict delete | ||
| erp_v2_fct_payment_instrument_status_history_customer_id__erp_v2_dim_customer_customer_id_fkey_c435bb107490 |
|
|
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 | ||
| erp_v2_bridge_revenue_to_purchased_contingent_purchased_contingent_id__erp_v2_dim_purchased_contingent_purchas_f6a75d64c8cd |
|
|
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 | ||
| erp_v2_bridge_service_to_organization_unit_service_id__erp_v2_dim_service_service_id_fkey_027ea9035df6 |
|
|
Restrict delete | ||
| dim_rate_term_payment_frequency_rate_id_fkey |
|
|
Restrict delete | ||
| dim_rate_term_payment_frequency_rate_term_configuration_id_fkey |
|
|
Restrict delete | ||
| erp_v2_bridge_discount_campaign_to_organization_unit_discount_campaign_id__erp_v2_dim_discount_campaign_discou_7a9da8bcf0a3 |
|
|
Restrict delete | ||
| erp_v2_bridge_discount_campaign_to_organization_unit_organization_unit_id__erp_v2_dim_organization_unit_organi_d2fbb7060fea |
|
|
Restrict delete | ||
| fct_payment_customer_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_payment_currency_id__erp_v2_dim_currency_currency_id_fkey_a06f02bdffbe |
|
|
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 | ||
| erp_v2_fct_class_appointment_class_id__erp_v2_dim_class_class_id_fkey_0eb0a68fdacf |
|
|
Restrict delete | ||
| fct_class_appointment_created_date_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_class_appointment_appointment_id__erp_v2_dim_appointment_appointment_id_fkey_f4e53bd6c753 |
|
|
Restrict delete | ||
| fct_class_appointment_organization_unit_id_fkey |
|
|
Restrict delete | ||
| erp_v2_dim_payment_instrument_customer_id__erp_v2_dim_customer_customer_id_fkey_1d94a658b247 |
|
|
Restrict delete | ||
| erp_v2_dim_payment_instrument_paying_customer_id__erp_v2_dim_customer_customer_id_fkey_2652b076ff2a |
|
|
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 | ||
| erp_v2_fct_class_event_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_e6ab28415bac |
|
|
Restrict delete | ||
| erp_v2_fct_class_event_inclusive_contingent_id__erp_v2_dim_inclusive_contingent_inclusive_contingent_id_fkey_94ae8bcc3b4a |
|
|
Restrict delete | ||
| erp_v2_fct_class_event_class_event_property_id__erp_v2_dim_class_event_property_class_event_property_id_fkey_2f246406031f |
|
|
Restrict delete | ||
| erp_v2_fct_class_event_purchased_contingent_id__erp_v2_dim_purchased_contingent_purchased_contingent_id_fkey_895261d4114d |
|
|
Restrict delete | ||
| erp_v2_fct_class_event_class_id__erp_v2_dim_class_class_id_fkey_608cf7f8dd85 |
|
|
Restrict delete | ||
| erp_v2_fct_class_event_appointment_id__erp_v2_dim_appointment_appointment_id_fkey_ef6408601227 |
|
|
Restrict delete | ||
| erp_v2_fct_class_event_customer_id__erp_v2_dim_customer_customer_id_fkey_a00da0c26bf7 |
|
|
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 | ||
| erp_v2_fct_customer_appointment_appointment_id__erp_v2_dim_appointment_appointment_id_fkey_24da8b99b36c |
|
|
Restrict delete | ||
| erp_v2_fct_customer_appointment_purchased_contingent_id__erp_v2_dim_purchased_contingent_purchased_contingent__753134259bc0 |
|
|
Restrict delete | ||
| fct_customer_appointment_customer_id_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_inclusive_contingent_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_customer_appointment_service_id__erp_v2_dim_service_service_id_fkey_615003f02b3b |
|
|
Restrict delete | ||
| erp_v2_bridge_customer_to_customer_code_customer_code_id__erp_v2_dim_customer_code_customer_code_id_fkey_60a1d958f68c |
|
|
Restrict delete | ||
| bridge_customer_to_customer_code_customer_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_checkin_device_id__erp_v2_dim_device_device_id_fkey_8a1ae26194f0 |
|
|
Restrict delete | ||
| erp_v2_fct_checkin_customer_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_add16c7191fc |
|
|
Restrict delete | ||
| erp_v2_fct_checkin_customer_id__erp_v2_dim_customer_customer_id_fkey_7952116f2b18 |
|
|
Restrict delete | ||
| erp_v2_fct_checkin_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_53f443d15805 |
|
|
Restrict delete | ||
| bridge_discount_campaign_to_allowed_origin_type_discount_campaign_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_customer_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_pre_cancellation_end_date_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_contract_cancellation_currency_id__erp_v2_dim_currency_currency_id_fkey_f92da2de7845 |
|
|
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 | ||
| erp_v2_dim_product_service_id__erp_v2_dim_service_service_id_fkey_292dad53b2fd |
|
|
Restrict delete | ||
| erp_v2_fct_lead_lifetime_lead_stage_id__erp_v2_dim_lead_stage_lead_stage_id_fkey_38cc29024b18 |
|
|
Restrict delete | ||
| erp_v2_fct_lead_lifetime_customer_id__erp_v2_dim_customer_customer_id_fkey_8e5fc9fefb54 |
|
|
Restrict delete | ||
| erp_v2_fct_lead_lifetime_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_88dd817d8549 |
|
|
Restrict delete | ||
| erp_v2_fct_lead_lifetime_campaign_id__erp_v2_dim_campaign_campaign_id_fkey_791cdefd0cec |
|
|
Restrict delete | ||
| erp_v2_fct_trainer_appointment_service_id__erp_v2_dim_service_service_id_fkey_b6c7f57ca44b |
|
|
Restrict delete | ||
| fct_trainer_appointment_employee_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_appointment_organization_unit_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_trainer_appointment_appointment_id__erp_v2_dim_appointment_appointment_id_fkey_4e3c9632486d |
|
|
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 | ||
| erp_v2_fct_service_usage_service_id__erp_v2_dim_service_service_id_fkey_252e7c8293c0 |
|
|
Restrict delete | ||
| fct_service_usage_organization_unit_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_service_usage_purchased_contingent_id__erp_v2_dim_purchased_contingent_purchased_contingent_id_fkey_b32dd15cbc61 |
|
|
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 | ||
| erp_v2_fct_revenue_currency_id__erp_v2_dim_currency_currency_id_fkey_61503c820a1c |
|
|
Restrict delete | ||
| fct_revenue_rate_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_accounting_date_id_fkey |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_revenue_group_id__erp_v2_dim_revenue_group_revenue_group_id_fkey_9c8d22346f1b |
|
|
Restrict delete | ||
| fct_revenue_organization_unit_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 | ||
| erp_v2_fct_rate_term_payment_frequency_price_organization_unit_id__erp_v2_dim_organization_unit_organization_u_4c25ab6b3d1a |
|
|
Restrict delete | ||
| erp_v2_fct_rate_term_payment_frequency_price_rate_id__erp_v2_dim_rate_rate_id_fkey_d81de4569261 |
|
|
Restrict delete | ||
| erp_v2_fct_rate_term_payment_frequency_price_rate_term_configuration_id__erp_v2_dim_rate_term_configuration_ra_1d03f4728b27 |
|
|
Restrict delete | ||
| erp_v2_fct_rate_term_payment_frequency_price_rate_term_payment_frequency_id__erp_v2_dim_rate_term_payment_freq_54f1456d7341 |
|
|
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 |
|---|