99 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_employee_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_class_appointments_class_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_employee_working_time_model_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_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_idle_period_property_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_rate_id_fkey |
|
|
Restrict delete | ||
| fct_employee_access_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_employee_access_employee_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 | ||
| 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 | ||
| 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 | ||
| dim_cancellation_reason_localized_cancellation_reason_id_fkey |
|
|
Restrict delete | ||
| fct_customer_studio_history_organization_unit_id_fkey |
|
|
Restrict delete | ||
| dim_contract_cancellation_reason_cancellation_reason_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_appointment_id_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_inclusive_contingent_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_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_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_checkin_device_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_rate_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_cancellation_reason_id_fkey |
|
|
Restrict delete | ||
| fct_lead_lifetime_campaign_id_fkey |
|
|
Restrict delete | ||
| fct_lead_lifetime_organization_unit_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 | ||
| bridge_product_to_organization_unit_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_contract_employee_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_pre_cancellation_end_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_contract_rate_id_fkey |
|
|
Restrict delete | ||
| fct_contract_end_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_start_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_created_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_customer_id_fkey |
|
|
Restrict delete | ||
| fct_contract_company_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_receipt_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_start_date_of_use_id_fkey |
|
|
Restrict delete | ||
| fct_contract_main_contract_id_fkey |
|
|
Restrict delete | ||
| bridge_service_to_organization_unit_organization_unit_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_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_customer_id_fkey |
|
|
Restrict delete | ||
| fct_service_usage_inclusive_contingent_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 | ||
| 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_organization_unit_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_appointment_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_event_property_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 |
Check Constraints
| Table | Constraint Name | Constraint |
|---|