267 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| FK_civicrm_acl_cache_acl_id |
|
|
Cascade on delete | ||
| FK_civicrm_acl_cache_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_acl_contact_cache_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_acl_contact_cache_user_id |
|
|
Cascade on delete | ||
| FK_civicrm_action_log_action_schedule_id |
|
|
Cascade on delete | ||
| FK_civicrm_action_log_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_action_schedule_group_id |
|
|
Null on delete | ||
| FK_civicrm_action_schedule_msg_template_id |
|
|
Null on delete | ||
| FK_civicrm_action_schedule_sms_provider_id |
|
|
Null on delete | ||
| FK_civicrm_action_schedule_sms_template_id |
|
|
Null on delete | ||
| FK_civicrm_activity_campaign_id |
|
|
Null on delete | ||
| FK_civicrm_activity_contact_activity_id |
|
|
Cascade on delete | ||
| FK_civicrm_activity_contact_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_activity_original_id |
|
|
Cascade on delete | ||
| FK_civicrm_activity_parent_id |
|
|
Cascade on delete | ||
| FK_civicrm_activity_phone_id |
|
|
Null on delete | ||
| FK_civicrm_activity_relationship_id |
|
|
Null on delete | ||
| FK_civicrm_address_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_address_country_id |
|
|
Null on delete | ||
| FK_civicrm_address_county_id |
|
|
Null on delete | ||
| FK_civicrm_address_master_id |
|
|
Null on delete | ||
| FK_civicrm_address_state_province_id |
|
|
Null on delete | ||
| FK_civicrm_batch_created_id |
|
|
Null on delete | ||
| FK_civicrm_batch_modified_id |
|
|
Null on delete | ||
| FK_civicrm_batch_saved_search_id |
|
|
Null on delete | ||
| FK_civicrm_cache_component_id |
|
|
Restrict delete | ||
| FK_civicrm_campaign_created_id |
|
|
Null on delete | ||
| FK_civicrm_campaign_group_campaign_id |
|
|
Cascade on delete | ||
| FK_civicrm_campaign_last_modified_id |
|
|
Null on delete | ||
| FK_civicrm_campaign_parent_id |
|
|
Null on delete | ||
| FK_civicrm_case_activity_activity_id |
|
|
Cascade on delete | ||
| FK_civicrm_case_activity_case_id |
|
|
Cascade on delete | ||
| FK_civicrm_case_case_type_id |
|
|
Restrict delete | ||
| FK_civicrm_case_contact_case_id |
|
|
Cascade on delete | ||
| FK_civicrm_case_contact_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_contact_employer_id |
|
|
Null on delete | ||
| FK_civicrm_contact_primary_contact_id |
|
|
Null on delete | ||
| FK_civicrm_contact_type_parent_id |
|
|
Restrict delete | ||
| FK_civicrm_contribution_address_id |
|
|
Null on delete | ||
| FK_civicrm_contribution_campaign_id |
|
|
Null on delete | ||
| FK_civicrm_contribution_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_contribution_contribution_page_id |
|
|
Null on delete | ||
| FK_civicrm_contribution_contribution_recur_id |
|
|
Null on delete | ||
| FK_civicrm_contribution_financial_type_id |
|
|
Restrict delete | ||
| FK_civicrm_contribution_page_campaign_id |
|
|
Null on delete | ||
| FK_civicrm_contribution_page_created_id |
|
|
Null on delete | ||
| FK_civicrm_contribution_page_financial_type_id |
|
|
Restrict delete | ||
| FK_civicrm_contribution_product_contribution_id |
|
|
Cascade on delete | ||
| FK_civicrm_contribution_product_financial_type_id |
|
|
Null on delete | ||
| FK_civicrm_contribution_recur_campaign_id |
|
|
Null on delete | ||
| FK_civicrm_contribution_recur_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_contribution_recur_financial_type_id |
|
|
Null on delete | ||
| FK_civicrm_contribution_recur_payment_processor_id |
|
|
Null on delete | ||
| FK_civicrm_contribution_recur_payment_token_id |
|
|
Null on delete | ||
| FK_civicrm_contribution_soft_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_contribution_soft_contribution_id |
|
|
Cascade on delete | ||
| FK_civicrm_contribution_soft_pcp_id |
|
|
Null on delete | ||
| FK_civicrm_contribution_widget_contribution_page_id |
|
|
Cascade on delete | ||
| FK_civicrm_country_address_format_id |
|
|
Restrict delete | ||
| FK_civicrm_country_region_id |
|
|
Restrict delete | ||
| FK_civicrm_county_state_province_id |
|
|
Restrict delete | ||
| FK_civicrm_custom_field_custom_group_id |
|
|
Cascade on delete | ||
| FK_civicrm_custom_group_created_id |
|
|
Null on delete | ||
| FK_civicrm_dashboard_contact_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_dashboard_contact_dashboard_id |
|
|
Cascade on delete | ||
| FK_civicrm_dashboard_domain_id |
|
|
Cascade on delete | ||
| FK_civicrm_dedupe_exception_contact_id1 |
|
|
Cascade on delete | ||
| FK_civicrm_dedupe_exception_contact_id2 |
|
|
Cascade on delete | ||
| FK_civicrm_dedupe_rule_dedupe_rule_group_id |
|
|
Restrict delete | ||
| FK_civicrm_discount_price_set_id |
|
|
Cascade on delete | ||
| FK_civicrm_domain_contact_id |
|
|
Restrict delete | ||
| FK_civicrm_email_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_entity_batch_batch_id |
|
|
Cascade on delete | ||
| FK_civicrm_entity_file_file_id |
|
|
Restrict delete | ||
| FK_civicrm_entity_financial_account_financial_account_id |
|
|
Restrict delete | ||
| FK_civicrm_entity_financial_trxn_financial_trxn_id |
|
|
Null on delete | ||
| FK_civicrm_entity_tag_tag_id |
|
|
Cascade on delete | ||
| FK_civicrm_event_campaign_id |
|
|
Null on delete | ||
| FK_civicrm_event_carts_user_id |
|
|
Null on delete | ||
| FK_civicrm_event_created_id |
|
|
Null on delete | ||
| FK_civicrm_event_dedupe_rule_group_id |
|
|
Restrict delete | ||
| FK_civicrm_event_loc_block_id |
|
|
Null on delete | ||
| FK_civicrm_events_in_carts_event_cart_id |
|
|
Cascade on delete | ||
| FK_civicrm_events_in_carts_event_id |
|
|
Cascade on delete | ||
| FK_civicrm_file_created_id |
|
|
Null on delete | ||
| FK_civicrm_financial_account_contact_id |
|
|
Null on delete | ||
| FK_civicrm_financial_account_parent_id |
|
|
Restrict delete | ||
| FK_civicrm_financial_item_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_financial_item_financial_account_id |
|
|
Restrict delete | ||
| FK_civicrm_financial_trxn_from_financial_account_id |
|
|
Restrict delete | ||
| FK_civicrm_financial_trxn_payment_processor_id |
|
|
Null on delete | ||
| FK_civicrm_financial_trxn_to_financial_account_id |
|
|
Restrict delete | ||
| FK_civicrm_grant_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_grant_financial_type_id |
|
|
Null on delete | ||
| FK_civicrm_group_contact_cache_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_group_contact_cache_group_id |
|
|
Cascade on delete | ||
| FK_civicrm_group_contact_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_group_contact_email_id |
|
|
Restrict delete | ||
| FK_civicrm_group_contact_group_id |
|
|
Cascade on delete | ||
| FK_civicrm_group_contact_location_id |
|
|
Null on delete | ||
| FK_civicrm_group_created_id |
|
|
Null on delete | ||
| FK_civicrm_group_modified_id |
|
|
Null on delete | ||
| FK_civicrm_group_nesting_child_group_id |
|
|
Cascade on delete | ||
| FK_civicrm_group_nesting_parent_group_id |
|
|
Cascade on delete | ||
| FK_civicrm_group_organization_group_id |
|
|
Cascade on delete | ||
| FK_civicrm_group_organization_organization_id |
|
|
Cascade on delete | ||
| FK_civicrm_group_saved_search_id |
|
|
Null on delete | ||
| FK_civicrm_im_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_job_domain_id |
|
|
Restrict delete | ||
| FK_civicrm_job_log_domain_id |
|
|
Restrict delete | ||
| FK_civicrm_line_item_contribution_id |
|
|
Null on delete | ||
| FK_civicrm_line_item_financial_type_id |
|
|
Null on delete | ||
| FK_civicrm_line_item_price_field_id |
|
|
Null on delete | ||
| FK_civicrm_line_item_price_field_value_id |
|
|
Null on delete | ||
| FK_civicrm_loc_block_address_2_id |
|
|
Null on delete | ||
| FK_civicrm_loc_block_address_id |
|
|
Null on delete | ||
| FK_civicrm_loc_block_email_2_id |
|
|
Null on delete | ||
| FK_civicrm_loc_block_email_id |
|
|
Null on delete | ||
| FK_civicrm_loc_block_im_2_id |
|
|
Null on delete | ||
| FK_civicrm_loc_block_im_id |
|
|
Null on delete | ||
| FK_civicrm_loc_block_phone_2_id |
|
|
Null on delete | ||
| FK_civicrm_loc_block_phone_id |
|
|
Null on delete | ||
| FK_civicrm_log_modified_id |
|
|
Cascade on delete | ||
| FK_civicrm_mail_settings_domain_id |
|
|
Restrict delete | ||
| FK_civicrm_mailing_abtest_created_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_approver_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_bounce_pattern_bounce_type_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_campaign_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_created_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_domain_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_event_bounce_event_queue_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_event_confirm_event_subscribe_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_event_delivered_event_queue_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_event_forward_dest_queue_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_event_forward_event_queue_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_event_opened_event_queue_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_event_queue_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_event_queue_email_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_event_queue_job_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_event_queue_phone_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_event_reply_event_queue_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_event_subscribe_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_event_subscribe_group_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_event_trackable_url_open_event_queue_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_event_trackable_url_open_trackable_url_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_event_unsubscribe_event_queue_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_footer_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_group_mailing_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_header_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_job_mailing_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_job_parent_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_location_type_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_msg_template_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_optout_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_recipients_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_recipients_email_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_recipients_mailing_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_recipients_phone_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_reply_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_scheduled_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_sms_provider_id |
|
|
Null on delete | ||
| FK_civicrm_mailing_spool_job_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_trackable_url_mailing_id |
|
|
Cascade on delete | ||
| FK_civicrm_mailing_unsubscribe_id |
|
|
Null on delete | ||
| FK_civicrm_mapping_field_location_type_id |
|
|
Restrict delete | ||
| FK_civicrm_mapping_field_mapping_id |
|
|
Restrict delete | ||
| FK_civicrm_mapping_field_relationship_type_id |
|
|
Restrict delete | ||
| FK_civicrm_membership_block_entity_id |
|
|
Restrict delete | ||
| FK_civicrm_membership_block_membership_type_default |
|
|
Restrict delete | ||
| FK_civicrm_membership_campaign_id |
|
|
Null on delete | ||
| FK_civicrm_membership_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_membership_contribution_recur_id |
|
|
Null on delete | ||
| FK_civicrm_membership_log_membership_id |
|
|
Cascade on delete | ||
| FK_civicrm_membership_log_membership_type_id |
|
|
Null on delete | ||
| FK_civicrm_membership_log_modified_id |
|
|
Null on delete | ||
| FK_civicrm_membership_log_status_id |
|
|
Cascade on delete | ||
| FK_civicrm_membership_membership_type_id |
|
|
Cascade on delete | ||
| FK_civicrm_membership_owner_membership_id |
|
|
Null on delete | ||
| FK_civicrm_membership_payment_contribution_id |
|
|
Cascade on delete | ||
| FK_civicrm_membership_payment_membership_id |
|
|
Cascade on delete | ||
| FK_civicrm_membership_status_id |
|
|
Cascade on delete | ||
| FK_civicrm_membership_type_domain_id |
|
|
Restrict delete | ||
| FK_civicrm_membership_type_financial_type_id |
|
|
Restrict delete | ||
| FK_civicrm_membership_type_member_of_contact_id |
|
|
Restrict delete | ||
| FK_civicrm_menu_component_id |
|
|
Restrict delete | ||
| FK_civicrm_menu_domain_id |
|
|
Restrict delete | ||
| FK_civicrm_mosaico_msg_template_msg_tpl_id |
|
|
Cascade on delete | ||
| FK_civicrm_mosaico_template_msg_tpl_id |
|
|
Null on delete | ||
| FK_civicrm_navigation_domain_id |
|
|
Restrict delete | ||
| FK_civicrm_navigation_parent_id |
|
|
Cascade on delete | ||
| FK_civicrm_note_contact_id |
|
|
Null on delete | ||
| FK_civicrm_openid_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_option_value_component_id |
|
|
Restrict delete | ||
| FK_civicrm_option_value_domain_id |
|
|
Restrict delete | ||
| FK_civicrm_option_value_option_group_id |
|
|
Cascade on delete | ||
| FK_civicrm_participant_campaign_id |
|
|
Null on delete | ||
| FK_civicrm_participant_cart_id |
|
|
Null on delete | ||
| FK_civicrm_participant_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_participant_discount_id |
|
|
Null on delete | ||
| FK_civicrm_participant_event_id |
|
|
Cascade on delete | ||
| FK_civicrm_participant_payment_contribution_id |
|
|
Cascade on delete | ||
| FK_civicrm_participant_payment_participant_id |
|
|
Cascade on delete | ||
| FK_civicrm_participant_registered_by_id |
|
|
Null on delete | ||
| FK_civicrm_participant_status_id |
|
|
Restrict delete | ||
| FK_civicrm_participant_transferred_to_contact_id |
|
|
Null on delete | ||
| FK_civicrm_payment_processor_domain_id |
|
|
Restrict delete | ||
| FK_civicrm_payment_processor_payment_processor_type_id |
|
|
Restrict delete | ||
| FK_civicrm_payment_token_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_payment_token_created_id |
|
|
Null on delete | ||
| FK_civicrm_payment_token_payment_processor_id |
|
|
Restrict delete | ||
| FK_civicrm_pcp_block_supporter_profile_id |
|
|
Null on delete | ||
| FK_civicrm_pcp_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_phone_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_pledge_campaign_id |
|
|
Null on delete | ||
| FK_civicrm_pledge_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_pledge_contribution_page_id |
|
|
Null on delete | ||
| FK_civicrm_pledge_financial_type_id |
|
|
Restrict delete | ||
| FK_civicrm_pledge_payment_contribution_id |
|
|
Cascade on delete | ||
| FK_civicrm_pledge_payment_pledge_id |
|
|
Cascade on delete | ||
| FK_civicrm_premiums_product_financial_type_id |
|
|
Null on delete | ||
| FK_civicrm_premiums_product_premiums_id |
|
|
Restrict delete | ||
| FK_civicrm_premiums_product_product_id |
|
|
Restrict delete | ||
| FK_civicrm_price_field_price_set_id |
|
|
Restrict delete | ||
| FK_civicrm_price_field_value_financial_type_id |
|
|
Null on delete | ||
| FK_civicrm_price_field_value_membership_type_id |
|
|
Null on delete | ||
| FK_civicrm_price_field_value_price_field_id |
|
|
Restrict delete | ||
| FK_civicrm_price_set_domain_id |
|
|
Restrict delete | ||
| FK_civicrm_price_set_entity_price_set_id |
|
|
Restrict delete | ||
| FK_civicrm_price_set_financial_type_id |
|
|
Null on delete | ||
| FK_civicrm_print_label_created_id |
|
|
Null on delete | ||
| FK_civicrm_product_financial_type_id |
|
|
Null on delete | ||
| FK_civicrm_relationship_case_id |
|
|
Cascade on delete | ||
| FK_civicrm_relationship_contact_id_a |
|
|
Cascade on delete | ||
| FK_civicrm_relationship_contact_id_b |
|
|
Cascade on delete | ||
| FK_civicrm_relationship_relationship_type_id |
|
|
Cascade on delete | ||
| FK_civicrm_report_instance_created_id |
|
|
Null on delete | ||
| FK_civicrm_report_instance_domain_id |
|
|
Restrict delete | ||
| FK_civicrm_report_instance_drilldown_id |
|
|
Null on delete | ||
| FK_civicrm_report_instance_navigation_id |
|
|
Null on delete | ||
| FK_civicrm_report_instance_owner_id |
|
|
Null on delete | ||
| FK_civicrm_saved_search_mapping_id |
|
|
Restrict delete | ||
| FK_civicrm_setting_component_id |
|
|
Restrict delete | ||
| FK_civicrm_setting_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_setting_created_id |
|
|
Null on delete | ||
| FK_civicrm_setting_domain_id |
|
|
Cascade on delete | ||
| FK_civicrm_sms_provider_domain_id |
|
|
Null on delete | ||
| FK_civicrm_state_province_country_id |
|
|
Restrict delete | ||
| FK_civicrm_status_pref_domain_id |
|
|
Restrict delete | ||
| FK_civicrm_subscription_history_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_subscription_history_group_id |
|
|
Cascade on delete | ||
| FK_civicrm_survey_campaign_id |
|
|
Null on delete | ||
| FK_civicrm_survey_created_id |
|
|
Null on delete | ||
| FK_civicrm_survey_last_modified_id |
|
|
Null on delete | ||
| FK_civicrm_tag_created_id |
|
|
Null on delete | ||
| FK_civicrm_tag_parent_id |
|
|
Restrict delete | ||
| FK_civicrm_timezone_country_id |
|
|
Restrict delete | ||
| FK_civicrm_uf_field_location_type_id |
|
|
Null on delete | ||
| FK_civicrm_uf_field_uf_group_id |
|
|
Cascade on delete | ||
| FK_civicrm_uf_group_add_to_group_id |
|
|
Null on delete | ||
| FK_civicrm_uf_group_created_id |
|
|
Null on delete | ||
| FK_civicrm_uf_group_limit_listings_group_id |
|
|
Null on delete | ||
| FK_civicrm_uf_join_uf_group_id |
|
|
Restrict delete | ||
| FK_civicrm_uf_match_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_uf_match_domain_id |
|
|
Restrict delete | ||
| FK_civicrm_value_informations__1_entity_id |
|
|
Cascade on delete | ||
| FK_civicrm_website_contact_id |
|
|
Cascade on delete | ||
| FK_civicrm_word_replacement_domain_id |
|
|
Restrict delete |
Processing...
Showing 1 to 267 of 267 entries
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| No data available in table | ||
Processing...
Showing 0 to 0 of 0 entries