110 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 | ||
| bridge_customer_to_customer_code_customer_code_id_fkey |
|
|
Restrict delete | ||
| bridge_customer_to_customer_code_customer_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 | ||
| 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_contract_cancellation_property_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 | ||
| 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_lead_lifetime_lead_start_date_fkey |
|
|
Restrict delete | ||
| fct_lead_lifetime_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_lead_lifetime_customer_id_fkey |
|
|
Restrict delete | ||
| fct_lead_lifetime_lead_finish_date_fkey |
|
|
Restrict delete | ||
| fct_trainer_appointment_employee_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_appointment_end_date_fkey |
|
|
Restrict delete | ||
| fct_trainer_appointment_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_trainer_appointment_start_date_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 | ||
| dim_customer_communication_consent_customer_id_fkey |
|
|
Restrict delete | ||
| dim_customer_communication_consent_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_contract_price_history_valid_to_date_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_valid_from_date_fkey |
|
|
Restrict delete | ||
| fct_contract_price_history_customer_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_revenue_group_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_rate_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_accounting_date_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_contract_id_fkey |
|
|
Restrict delete | ||
| fct_revenue_service_period_start_date_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 | ||
| fct_contract_term_dates_organization_unit_id_fkey |
|
|
Restrict delete | ||
| fct_contract_term_dates_start_date_fkey |
|
|
Restrict delete | ||
| fct_contract_term_dates_end_date_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_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_end_date_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_customer_id_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_start_date_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_inclusive_contingent_id_fkey |
|
|
Restrict delete | ||
| fct_customer_appointment_service_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 | ||
| dim_customer_created_date_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|