141 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_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_class_appointments_class_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 | ||
| fct_payment_run_customer_id_fkey |
|
|
Restrict delete | ||
| fct_payment_run_currency_id_fkey |
|
|
Restrict delete | ||
| fct_payment_run_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_payment_run_payment_run_property_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_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_contract_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_cash_based_customer_id_fkey |
|
|
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_idle_period_property_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_currency_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_contract_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_rate_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_shared_contract_idle_period_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 | ||
| 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_id_fkey |
|
|
Restrict delete | ||
| fct_contract_voucher_campaign_id_fkey |
|
|
Restrict delete | ||
| bridge_rate_bundle_to_payment_choice_rate_bundle_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 | ||
| dim_opening_hours_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_organization_unit_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_rate_to_rate_code_rate_code_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_customer_to_customer_code_customer_code_id_fkey |
|
|
Restrict delete | ||
| bridge_customer_to_customer_code_customer_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_rate_bundle_term_rate_term_payment_frequency_id_fkey |
|
|
Restrict delete | ||
| dim_rate_bundle_term_rate_bundle_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_trainer_appointment_organization_unit_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 | ||
| fct_contract_start_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_subsequent_contract_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_pre_cancellation_end_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_created_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_receipt_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_end_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_start_date_of_use_id_fkey |
|
|
Restrict delete | ||
| fct_contract_main_contract_id_fkey |
|
|
Restrict delete | ||
| fct_customer_referral_referred_customer_id_fkey |
|
|
Restrict delete | ||
| fct_customer_referral_referring_customer_id_fkey |
|
|
Restrict delete | ||
| fct_invoice_product_id_fkey |
|
|
Restrict delete | ||
| fct_invoice_currency_id_fkey |
|
|
Restrict delete | ||
| bridge_service_to_organization_unit_organization_unit_id_fkey |
|
|
Restrict delete | ||
| bridge_service_to_organization_unit_service_id_fkey |
|
|
Restrict delete | ||
| dim_customer_custom_field_customer_id_fkey |
|
|
Restrict delete | ||
| dim_customer_communication_consent_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_contract_price_history_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_contract_price_history_contract_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_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_contract_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 | ||
| bridge_company_to_organization_unit_organization_unit_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 | ||
| fct_contract_term_dates_contract_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_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 | ||
| fct_class_appointment_end_date_id_fkey |
|
|
Restrict delete | ||
| fct_class_appointment_start_date_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 | ||
| fct_class_event_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_class_event_class_id_fkey |
|
|
Restrict delete | ||
| fct_class_event_inclusive_contingent_id_fkey |
|
|
Restrict delete | ||
| fct_class_event_customer_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|