118 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 | ||
| 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_effective_collection_date_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_idle_period_customer_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_idle_period_property_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 | ||
| fct_idle_period_contract_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_rate_id_fkey |
|
|
Restrict delete | ||
| fct_idle_period_end_date_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 | ||
| dim_device_active_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_contract_voucher_definition_id_fkey |
|
|
Restrict delete | ||
| fct_contract_voucher_company_id_fkey |
|
|
Restrict delete | ||
| fct_contract_voucher_campaign_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_end_date_fkey |
|
|
Restrict delete | ||
| fct_customer_studio_history_customer_id_fkey |
|
|
Restrict delete | ||
| fct_customer_studio_history_start_date_fkey |
|
|
Restrict delete | ||
| dim_contract_cancellation_reason_cancellation_reason_id_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_purchased_contingent_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 | ||
| 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 | ||
| 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 | ||
| 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_cancellation_reason_id_fkey |
|
|
Restrict delete | ||
| fct_contract_cancellation_cancellation_receipt_date_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_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 | ||
| 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_contract_term_id_fkey |
|
|
Restrict delete | ||
| fct_contract_rate_id_fkey |
|
|
Restrict delete | ||
| fct_contract_end_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_contract_property_id_fkey |
|
|
Restrict delete | ||
| fct_contract_start_date_id_fkey |
|
|
Restrict delete | ||
| fct_contract_contract_cancellation_reason_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_contract_payment_frequency_id_fkey |
|
|
Restrict delete | ||
| fct_contract_start_date_of_use_id_fkey |
|
|
Restrict delete | ||
| fct_contract_main_contract_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_purchased_contingent_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 | ||
| bridge_company_to_organization_unit_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_contract_term_dates_customer_id_fkey |
|
|
Restrict delete | ||
| fct_contract_term_dates_contract_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 | ||
| 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_purchased_contingent_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 |
Check Constraints
| Table | Constraint Name | Constraint |
|---|