204 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| erp_v2_fct_trainer_class_appointments_appointment_id__erp_v2_dim_appointment_appointment_id_fkey_03e54edf990b |
|
|
Restrict delete | ||
| erp_v2_fct_trainer_class_appointments_trainer_appointment_status_id__erp_v2_dim_trainer_appointment_status_tra_487e44118838 |
|
|
Restrict delete | ||
| erp_v2_fct_trainer_class_appointments_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id__53869137b108 |
|
|
Restrict delete | ||
| erp_v2_fct_trainer_class_appointments_class_id__erp_v2_dim_class_class_id_fkey_40aa8e71a982 |
|
|
Restrict delete | ||
| erp_v2_fct_trainer_class_appointments_employee_id__erp_v2_dim_employee_employee_id_fkey_5658994255ec |
|
|
Restrict delete | ||
| erp_v2_dim_discount_campaign_discount_period_discount_campaign_id__erp_v2_dim_discount_campaign_discount_campa_6920fa97ea32 |
|
|
Restrict delete | ||
| erp_v2_dim_discount_campaign_discount_period_discount_campaign_scope_id__erp_v2_dim_discount_campaign_scope_di_c4317c5deca6 |
|
|
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 | ||
| erp_v2_dim_contract_voucher_definition_company_id__erp_v2_dim_company_company_id_fkey_70190aaa5d2c |
|
|
Restrict delete | ||
| erp_v2_dim_contract_voucher_definition_campaign_id__erp_v2_dim_campaign_campaign_id_fkey_de47ec642bb7 |
|
|
Restrict delete | ||
| erp_v2_dim_contract_voucher_definition_rate_id__erp_v2_dim_rate_rate_id_fkey_c565bcfd10eb |
|
|
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 | ||
| erp_v2_fct_revenue_cash_based_contract_id__erp_v2_fct_contract_contract_id_fkey_c182b8d8ecd4 |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_cash_based_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_4e9b78b78e53 |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_cash_based_product_id__erp_v2_dim_product_product_id_fkey_4a6772e67a8c |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_cash_based_customer_id__erp_v2_dim_customer_customer_id_fkey_9fcfa77af3ae |
|
|
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 | ||
| erp_v2_fct_idle_period_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_e20167bbb9db |
|
|
Restrict delete | ||
| erp_v2_fct_idle_period_currency_id__erp_v2_dim_currency_currency_id_fkey_331a01d0c42d |
|
|
Restrict delete | ||
| erp_v2_fct_idle_period_idle_period_property_id__erp_v2_dim_idle_period_property_idle_period_property_id_fkey_1532dc02200b |
|
|
Restrict delete | ||
| erp_v2_fct_idle_period_customer_id__erp_v2_dim_customer_customer_id_fkey_f8f5fa2aadee |
|
|
Restrict delete | ||
| erp_v2_fct_idle_period_contract_id__erp_v2_fct_contract_contract_id_fkey_310391a1376b |
|
|
Restrict delete | ||
| erp_v2_fct_idle_period_shared_contract_idle_period_id__erp_v2_fct_idle_period_idle_period_id_fkey_42fe563cf0ca |
|
|
Restrict delete | ||
| erp_v2_fct_idle_period_rate_id__erp_v2_dim_rate_rate_id_fkey_bce65a5cca84 |
|
|
Restrict delete | ||
| erp_v2_dim_customer_dunning_configuration_customer_id__erp_v2_dim_customer_customer_id_fkey_1ac71bcccf0f |
|
|
Restrict delete | ||
| erp_v2_dim_customer_group_member_discount_customer_group_id__erp_v2_dim_customer_group_customer_group_id_fkey_b1ddf1fcd7b5 |
|
|
Restrict delete | ||
| erp_v2_dim_studio_starter_package_adjustment_rate_term_configuration_id__erp_v2_dim_rate_term_configuration_ra_af781dd95291 |
|
|
Restrict delete | ||
| erp_v2_dim_studio_starter_package_adjustment_organization_unit_id__erp_v2_dim_organization_unit_organization_u_711bef1b21d1 |
|
|
Restrict delete | ||
| erp_v2_dim_studio_starter_package_adjustment_rate_id__erp_v2_dim_rate_rate_id_fkey_e4f8e5600d4a |
|
|
Restrict delete | ||
| erp_v2_fct_pos_saleposition_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_e2db3f4dc8ab |
|
|
Restrict delete | ||
| erp_v2_fct_pos_saleposition_cash_register_id__erp_v2_dim_cash_register_cash_register_id_fkey_9dc8c20076bd |
|
|
Restrict delete | ||
| erp_v2_bridge_organization_unit_to_organization_unit_code_organization_unit_code_id__erp_v2_dim_organization_u_a47f3e8453ce |
|
|
Restrict delete | ||
| erp_v2_bridge_organization_unit_to_organization_unit_code_organization_unit_id__erp_v2_dim_organization_unit_o_508bb3291f6a |
|
|
Restrict delete | ||
| erp_v2_fct_rate_term_payment_frequency_price_adjustment_rate_id__erp_v2_dim_rate_rate_id_fkey_4fa4778e2590 |
|
|
Restrict delete | ||
| erp_v2_fct_rate_term_payment_frequency_price_adjustment_rate_term_configuration_id__erp_v2_dim_rate_term_confi_f1a2952e2290 |
|
|
Restrict delete | ||
| erp_v2_fct_rate_term_payment_frequency_price_adjustment_rate_term_payment_frequency_id__erp_v2_dim_rate_term_p_f114d3930fb7 |
|
|
Restrict delete | ||
| erp_v2_bridge_rate_bundle_to_company_rate_bundle_id__erp_v2_dim_rate_bundle_rate_bundle_id_fkey_ca45bd926733 |
|
|
Restrict delete | ||
| erp_v2_bridge_rate_bundle_to_company_company_id__erp_v2_dim_company_company_id_fkey_716408ac5f77 |
|
|
Restrict delete | ||
| erp_v2_dim_rate_term_configuration_rate_id__erp_v2_dim_rate_rate_id_fkey_8aa80a16b5a9 |
|
|
Restrict delete | ||
| erp_v2_dim_rate_localized_rate_id__erp_v2_dim_rate_rate_id_fkey_3be38d4e221e |
|
|
Restrict delete | ||
| erp_v2_fct_contract_voucher_campaign_id__erp_v2_dim_campaign_campaign_id_fkey_00f5f09da640 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_voucher_contract_voucher_definition_id__erp_v2_dim_contract_voucher_definition_contract_vo_0c28e7e59b34 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_voucher_company_id__erp_v2_dim_company_company_id_fkey_9ee647363011 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_voucher_contract_id__erp_v2_fct_contract_contract_id_fkey_ba952ea0cd6e |
|
|
Restrict delete | ||
| erp_v2_bridge_rate_bundle_to_payment_choice_rate_bundle_id__erp_v2_dim_rate_bundle_rate_bundle_id_fkey_c53498fca3fa |
|
|
Restrict delete | ||
| erp_v2_bridge_rate_to_rate_code_rate_id__erp_v2_dim_rate_rate_id_fkey_9ee2eae02ce4 |
|
|
Restrict delete | ||
| erp_v2_bridge_rate_to_rate_code_rate_code_id__erp_v2_dim_rate_code_rate_code_id_fkey_dd41198c328b |
|
|
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 | ||
| erp_v2_fct_rate_bundle_term_availability_rate_bundle_term_id__erp_v2_dim_rate_bundle_term_rate_bundle_term_id__63dbe9cd5551 |
|
|
Restrict delete | ||
| erp_v2_fct_rate_bundle_term_availability_organization_unit_id__erp_v2_dim_organization_unit_organization_unit__3321960f897f |
|
|
Restrict delete | ||
| erp_v2_bridge_revenue_to_purchased_contingent_purchased_contingent_id__erp_v2_dim_purchased_contingent_purchas_f6a75d64c8cd |
|
|
Restrict delete | ||
| erp_v2_bridge_revenue_to_purchased_contingent_revenue_id__erp_v2_fct_revenue_revenue_id_fkey_8725c47a1b69 |
|
|
Restrict delete | ||
| erp_v2_dim_contract_voucher_rate_discount_period_contract_voucher_definition_id__erp_v2_dim_contract_voucher_d_cdc745c0b2a0 |
|
|
Restrict delete | ||
| erp_v2_dim_contract_voucher_rate_discount_period_rate_term_configuration_id__erp_v2_dim_rate_term_configuratio_0956186ce754 |
|
|
Restrict delete | ||
| erp_v2_dim_contract_voucher_rate_discount_period_rate_id__erp_v2_dim_rate_rate_id_fkey_0f1b67906738 |
|
|
Restrict delete | ||
| erp_v2_dim_contract_voucher_rate_discount_period_rate_term_payment_frequency_id__erp_v2_dim_rate_term_payment__f347a8726f1b |
|
|
Restrict delete | ||
| erp_v2_dim_contract_voucher_rate_discount_period_contract_voucher_id__erp_v2_fct_contract_voucher_contract_vou_e703b72da57c |
|
|
Restrict delete | ||
| erp_v2_dim_rate_bundle_term_rate_term_payment_frequency_id__erp_v2_dim_rate_term_payment_frequency_rate_term_p_47bf3f42eb8b |
|
|
Restrict delete | ||
| erp_v2_dim_rate_bundle_term_rate_bundle_id__erp_v2_dim_rate_bundle_rate_bundle_id_fkey_cfaee6d7ef31 |
|
|
Restrict delete | ||
| erp_v2_bridge_pos_saleposition_to_payment_pos_saleposition_id__erp_v2_fct_pos_saleposition_pos_saleposition_id_50c30e724329 |
|
|
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 | ||
| erp_v2_bridge_service_to_organization_unit_service_id__erp_v2_dim_service_service_id_fkey_027ea9035df6 |
|
|
Restrict delete | ||
| erp_v2_bridge_service_to_organization_unit_organization_unit_id__erp_v2_dim_organization_unit_organization_uni_93f5ab50f16a |
|
|
Restrict delete | ||
| erp_v2_bridge_payment_to_payment_run_payment_id__erp_v2_fct_payment_payment_id_fkey_237755775dad |
|
|
Restrict delete | ||
| erp_v2_dim_rate_term_payment_frequency_rate_id__erp_v2_dim_rate_rate_id_fkey_24eaf2a75a7c |
|
|
Restrict delete | ||
| erp_v2_dim_rate_term_payment_frequency_rate_term_configuration_id__erp_v2_dim_rate_term_configuration_rate_ter_f9b701626c3d |
|
|
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 | ||
| erp_v2_fct_payment_customer_id__erp_v2_dim_customer_customer_id_fkey_e319be685fa2 |
|
|
Restrict delete | ||
| erp_v2_fct_payment_currency_id__erp_v2_dim_currency_currency_id_fkey_a06f02bdffbe |
|
|
Restrict delete | ||
| erp_v2_fct_payment_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_4cd96431adf1 |
|
|
Restrict delete | ||
| erp_v2_fct_class_appointment_class_id__erp_v2_dim_class_class_id_fkey_0eb0a68fdacf |
|
|
Restrict delete | ||
| erp_v2_fct_class_appointment_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_cde89206a5f0 |
|
|
Restrict delete | ||
| erp_v2_fct_class_appointment_appointment_id__erp_v2_dim_appointment_appointment_id_fkey_f4e53bd6c753 |
|
|
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 | ||
| erp_v2_dim_cash_register_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_e6721b9ab5cd |
|
|
Restrict delete | ||
| erp_v2_dim_idle_period_property_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_bcec297cd3be |
|
|
Restrict delete | ||
| erp_v2_dim_closing_hours_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_82c34000fc77 |
|
|
Restrict delete | ||
| erp_v2_dim_contract_voucher_definition_localized_contract_voucher_definition_id__erp_v2_dim_contract_voucher_d_cecef4a0b550 |
|
|
Restrict delete | ||
| erp_v2_dim_discount_campaign_scope_rate_bundle_term_id__erp_v2_dim_rate_bundle_term_rate_bundle_term_id_fkey_460c2f074767 |
|
|
Restrict delete | ||
| erp_v2_dim_discount_campaign_scope_discount_campaign_id__erp_v2_dim_discount_campaign_discount_campaign_id_fke_ab76005959cc |
|
|
Restrict delete | ||
| erp_v2_dim_discount_campaign_scope_rate_bundle_id__erp_v2_dim_rate_bundle_rate_bundle_id_fkey_36f09d6ebe50 |
|
|
Restrict delete | ||
| erp_v2_fct_employee_access_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_04e45decc79f |
|
|
Restrict delete | ||
| erp_v2_fct_employee_access_employee_id__erp_v2_dim_employee_employee_id_fkey_fa344728f5ff |
|
|
Restrict delete | ||
| erp_v2_fct_lead_stage_history_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_2999e5217846 |
|
|
Restrict delete | ||
| erp_v2_fct_lead_stage_history_lead_stage_id__erp_v2_dim_lead_stage_lead_stage_id_fkey_9ca022e7a4b5 |
|
|
Restrict delete | ||
| erp_v2_fct_lead_stage_history_loss_reason_id__erp_v2_dim_loss_reason_loss_reason_id_fkey_5fca33474e52 |
|
|
Restrict delete | ||
| erp_v2_fct_lead_stage_history_previous_lead_stage_history_id__erp_v2_fct_lead_stage_history_lead_stage_history_81d986e9c6d6 |
|
|
Restrict delete | ||
| erp_v2_fct_lead_stage_history_customer_id__erp_v2_dim_customer_customer_id_fkey_4f92f3f5c4c9 |
|
|
Restrict delete | ||
| erp_v2_bridge_customer_group_to_customer_customer_group_id__erp_v2_dim_customer_group_customer_group_id_fkey_5e8065fbc643 |
|
|
Restrict delete | ||
| erp_v2_bridge_customer_group_to_customer_customer_id__erp_v2_dim_customer_customer_id_fkey_4148985e8f30 |
|
|
Restrict delete | ||
| erp_v2_fct_dunning_step_previous_dunning_step_id__erp_v2_fct_dunning_step_dunning_step_id_fkey_fb40e3240ab7 |
|
|
Restrict delete | ||
| erp_v2_fct_dunning_step_dunning_level_id__erp_v2_dim_dunning_level_dunning_level_id_fkey_c44a94e02894 |
|
|
Restrict delete | ||
| erp_v2_fct_dunning_step_customer_id__erp_v2_dim_customer_customer_id_fkey_1879304da46c |
|
|
Restrict delete | ||
| erp_v2_dim_cancellation_reason_localized_cancellation_reason_id__erp_v2_dim_cancellation_reason_cancellation_r_612cc6936a76 |
|
|
Restrict delete | ||
| erp_v2_fct_customer_studio_history_customer_id__erp_v2_dim_customer_customer_id_fkey_87a3526d7c02 |
|
|
Restrict delete | ||
| erp_v2_fct_customer_studio_history_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fke_04abcb7d4338 |
|
|
Restrict delete | ||
| erp_v2_dim_contract_cancellation_reason_cancellation_reason_id__erp_v2_dim_cancellation_reason_cancellation_re_644d1c4c8bb7 |
|
|
Restrict delete | ||
| erp_v2_dim_opening_hours_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_a8118e8ea847 |
|
|
Restrict delete | ||
| erp_v2_fct_customer_appointment_inclusive_contingent_id__erp_v2_dim_inclusive_contingent_inclusive_contingent__20a646d281e0 |
|
|
Restrict delete | ||
| erp_v2_fct_customer_appointment_appointment_id__erp_v2_dim_appointment_appointment_id_fkey_24da8b99b36c |
|
|
Restrict delete | ||
| erp_v2_fct_customer_appointment_customer_id__erp_v2_dim_customer_customer_id_fkey_7869556c7673 |
|
|
Restrict delete | ||
| erp_v2_fct_customer_appointment_purchased_contingent_id__erp_v2_dim_purchased_contingent_purchased_contingent__753134259bc0 |
|
|
Restrict delete | ||
| erp_v2_fct_customer_appointment_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_0b29e6e45a12 |
|
|
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 | ||
| erp_v2_bridge_customer_to_customer_code_customer_id__erp_v2_dim_customer_customer_id_fkey_6d686c59d642 |
|
|
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 | ||
| erp_v2_bridge_discount_campaign_to_allowed_origin_type_discount_campaign_id__erp_v2_dim_discount_campaign_disc_0ed5bdc786d7 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_cancellation_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_de00c0a9ddbb |
|
|
Restrict delete | ||
| erp_v2_fct_contract_cancellation_currency_id__erp_v2_dim_currency_currency_id_fkey_f92da2de7845 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_cancellation_customer_id__erp_v2_dim_customer_customer_id_fkey_6b34f21d3ca5 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_cancellation_cancellation_reason_id__erp_v2_dim_cancellation_reason_cancellation_reason_id_842390f8bf91 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_cancellation_rate_id__erp_v2_dim_rate_rate_id_fkey_58640f8358c5 |
|
|
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_employee_id__erp_v2_dim_employee_employee_id_fkey_ff80f2048c74 |
|
|
Restrict delete | ||
| erp_v2_fct_trainer_appointment_service_id__erp_v2_dim_service_service_id_fkey_b6c7f57ca44b |
|
|
Restrict delete | ||
| erp_v2_fct_trainer_appointment_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_d785c878b6f4 |
|
|
Restrict delete | ||
| erp_v2_fct_trainer_appointment_appointment_id__erp_v2_dim_appointment_appointment_id_fkey_4e3c9632486d |
|
|
Restrict delete | ||
| erp_v2_bridge_product_to_organization_unit_product_id__erp_v2_dim_product_product_id_fkey_f1fdb9e3c1ce |
|
|
Restrict delete | ||
| erp_v2_bridge_product_to_organization_unit_organization_unit_id__erp_v2_dim_organization_unit_organization_uni_7f6dc1b876f7 |
|
|
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 | ||
| erp_v2_fct_customer_referral_referred_customer_id__erp_v2_dim_customer_customer_id_fkey_10688aacefae |
|
|
Restrict delete | ||
| erp_v2_fct_customer_referral_referring_customer_id__erp_v2_dim_customer_customer_id_fkey_9ed5c601064c |
|
|
Restrict delete | ||
| erp_v2_dim_customer_custom_field_customer_id__erp_v2_dim_customer_customer_id_fkey_d73bcf978e91 |
|
|
Restrict delete | ||
| erp_v2_dim_customer_communication_consent_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_17e4f8f0f3bc |
|
|
Restrict delete | ||
| erp_v2_fct_contract_price_history_customer_id__erp_v2_dim_customer_customer_id_fkey_b2ed05f46d44 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_price_history_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_6f07537a3a43 |
|
|
Restrict delete | ||
| erp_v2_fct_contract_price_history_contract_id__erp_v2_fct_contract_contract_id_fkey_7ec3efc38ad2 |
|
|
Restrict delete | ||
| erp_v2_fct_service_usage_customer_id__erp_v2_dim_customer_customer_id_fkey_3b345e479996 |
|
|
Restrict delete | ||
| erp_v2_fct_service_usage_employee_id__erp_v2_dim_employee_employee_id_fkey_1e52486423bf |
|
|
Restrict delete | ||
| erp_v2_fct_service_usage_service_id__erp_v2_dim_service_service_id_fkey_252e7c8293c0 |
|
|
Restrict delete | ||
| erp_v2_fct_service_usage_purchased_contingent_id__erp_v2_dim_purchased_contingent_purchased_contingent_id_fkey_b32dd15cbc61 |
|
|
Restrict delete | ||
| erp_v2_fct_service_usage_inclusive_contingent_id__erp_v2_dim_inclusive_contingent_inclusive_contingent_id_fkey_0d4538394108 |
|
|
Restrict delete | ||
| erp_v2_fct_service_usage_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_3e9a8bf6cb0e |
|
|
Restrict delete | ||
| erp_v2_fct_service_usage_device_id__erp_v2_dim_device_device_id_fkey_c8141dcfec7f |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_product_id__erp_v2_dim_product_product_id_fkey_9ad64d17cb7b |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_rate_id__erp_v2_dim_rate_rate_id_fkey_e8c4ce28fc0c |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_currency_id__erp_v2_dim_currency_currency_id_fkey_61503c820a1c |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_customer_id__erp_v2_dim_customer_customer_id_fkey_813904625cce |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_revenue_group_id__erp_v2_dim_revenue_group_revenue_group_id_fkey_9c8d22346f1b |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_bab2228f7b9f |
|
|
Restrict delete | ||
| erp_v2_fct_revenue_contract_id__erp_v2_fct_contract_contract_id_fkey_c41c7b632840 |
|
|
Restrict delete | ||
| erp_v2_bridge_company_to_organization_unit_organization_unit_id__erp_v2_dim_organization_unit_organization_uni_51e5d48373ee |
|
|
Restrict delete | ||
| erp_v2_fct_contract_term_dates_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_e13a283163ac |
|
|
Restrict delete | ||
| erp_v2_fct_contract_term_dates_customer_id__erp_v2_dim_customer_customer_id_fkey_62bfcf6248f3 |
|
|
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 | ||
| erp_v2_dim_customer_group_organization_unit_id__erp_v2_dim_organization_unit_organization_unit_id_fkey_4fdcd4b09658 |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|