Constraints

263 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK_civicrm_entity_tag_tag_id
civicrm_entity_tag.tag_id
civicrm_tag.id
Cascade on delete
FK_civicrm_relationship_contact_id_b
civicrm_relationship.contact_id_b
civicrm_contact.id
Cascade on delete
FK_civicrm_relationship_case_id
civicrm_relationship.case_id
civicrm_case.id
Cascade on delete
FK_civicrm_relationship_relationship_type_id
civicrm_relationship.relationship_type_id
civicrm_relationship_type.id
Cascade on delete
FK_civicrm_relationship_contact_id_a
civicrm_relationship.contact_id_a
civicrm_contact.id
Cascade on delete
FK_civicrm_report_instance_domain_id
civicrm_report_instance.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_report_instance_navigation_id
civicrm_report_instance.navigation_id
civicrm_navigation.id
Null on delete
FK_civicrm_report_instance_drilldown_id
civicrm_report_instance.drilldown_id
civicrm_report_instance.id
Null on delete
FK_civicrm_report_instance_created_id
civicrm_report_instance.created_id
civicrm_contact.id
Null on delete
FK_civicrm_report_instance_owner_id
civicrm_report_instance.owner_id
civicrm_contact.id
Null on delete
FK_civicrm_mailing_job_mailing_id
civicrm_mailing_job.mailing_id
civicrm_mailing.id
Cascade on delete
FK_civicrm_mailing_job_parent_id
civicrm_mailing_job.parent_id
civicrm_mailing_job.id
Cascade on delete
FK_civicrm_group_created_id
civicrm_group.created_id
civicrm_contact.id
Null on delete
FK_civicrm_group_modified_id
civicrm_group.modified_id
civicrm_contact.id
Null on delete
FK_civicrm_group_saved_search_id
civicrm_group.saved_search_id
civicrm_saved_search.id
Null on delete
FK_civicrm_status_pref_domain_id
civicrm_status_pref.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_price_set_entity_price_set_id
civicrm_price_set_entity.price_set_id
civicrm_price_set.id
Restrict delete
FK_civicrm_dedupe_rule_dedupe_rule_group_id
civicrm_dedupe_rule.dedupe_rule_group_id
civicrm_dedupe_rule_group.id
Restrict delete
FK_civicrm_event_carts_user_id
civicrm_event_carts.user_id
civicrm_contact.id
Null on delete
FK_civicrm_group_nesting_child_group_id
civicrm_group_nesting.child_group_id
civicrm_group.id
Cascade on delete
FK_civicrm_group_nesting_parent_group_id
civicrm_group_nesting.parent_group_id
civicrm_group.id
Cascade on delete
FK_civicrm_uf_group_created_id
civicrm_uf_group.created_id
civicrm_contact.id
Null on delete
FK_civicrm_uf_group_add_to_group_id
civicrm_uf_group.add_to_group_id
civicrm_group.id
Null on delete
FK_civicrm_uf_group_limit_listings_group_id
civicrm_uf_group.limit_listings_group_id
civicrm_group.id
Null on delete
FK_civicrm_im_contact_id
civicrm_im.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_entity_batch_batch_id
civicrm_entity_batch.batch_id
civicrm_batch.id
Cascade on delete
FK_civicrm_mailing_abtest_created_id
civicrm_mailing_abtest.created_id
civicrm_contact.id
Null on delete
FK_civicrm_entity_financial_trxn_financial_trxn_id
civicrm_entity_financial_trxn.financial_trxn_id
civicrm_financial_trxn.id
Null on delete
FK_civicrm_membership_type_financial_type_id
civicrm_membership_type.financial_type_id
civicrm_financial_type.id
Restrict delete
FK_civicrm_membership_type_domain_id
civicrm_membership_type.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_membership_type_member_of_contact_id
civicrm_membership_type.member_of_contact_id
civicrm_contact.id
Restrict delete
FK_civicrm_product_financial_type_id
civicrm_product.financial_type_id
civicrm_financial_type.id
Null on delete
FK_civicrm_contact_primary_contact_id
civicrm_contact.primary_contact_id
civicrm_contact.id
Null on delete
FK_civicrm_contact_employer_id
civicrm_contact.employer_id
civicrm_contact.id
Null on delete
FK_civicrm_participant_payment_contribution_id
civicrm_participant_payment.contribution_id
civicrm_contribution.id
Cascade on delete
FK_civicrm_participant_payment_participant_id
civicrm_participant_payment.participant_id
civicrm_participant.id
Cascade on delete
FK_civicrm_case_activity_activity_id
civicrm_case_activity.activity_id
civicrm_activity.id
Cascade on delete
FK_civicrm_case_activity_case_id
civicrm_case_activity.case_id
civicrm_case.id
Cascade on delete
FK_civicrm_option_value_option_group_id
civicrm_option_value.option_group_id
civicrm_option_group.id
Cascade on delete
FK_civicrm_option_value_component_id
civicrm_option_value.component_id
civicrm_component.id
Restrict delete
FK_civicrm_option_value_domain_id
civicrm_option_value.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_openid_contact_id
civicrm_openid.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_activity_contact_activity_id
civicrm_activity_contact.activity_id
civicrm_activity.id
Cascade on delete
FK_civicrm_activity_contact_contact_id
civicrm_activity_contact.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_subscription_history_contact_id
civicrm_subscription_history.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_subscription_history_group_id
civicrm_subscription_history.group_id
civicrm_group.id
Cascade on delete
FK_civicrm_mailing_event_opened_event_queue_id
civicrm_mailing_event_opened.event_queue_id
civicrm_mailing_event_queue.id
Cascade on delete
FK_civicrm_county_state_province_id
civicrm_county.state_province_id
civicrm_state_province.id
Restrict delete
FK_civicrm_action_schedule_msg_template_id
civicrm_action_schedule.msg_template_id
civicrm_msg_template.id
Null on delete
FK_civicrm_action_schedule_sms_provider_id
civicrm_action_schedule.sms_provider_id
civicrm_sms_provider.id
Null on delete
FK_civicrm_action_schedule_sms_template_id
civicrm_action_schedule.sms_template_id
civicrm_msg_template.id
Null on delete
FK_civicrm_action_schedule_group_id
civicrm_action_schedule.group_id
civicrm_group.id
Null on delete
FK_civicrm_saved_search_mapping_id
civicrm_saved_search.mapping_id
civicrm_mapping.id
Restrict delete
FK_civicrm_note_contact_id
civicrm_note.contact_id
civicrm_contact.id
Null on delete
FK_civicrm_batch_saved_search_id
civicrm_batch.saved_search_id
civicrm_saved_search.id
Null on delete
FK_civicrm_batch_created_id
civicrm_batch.created_id
civicrm_contact.id
Null on delete
FK_civicrm_batch_modified_id
civicrm_batch.modified_id
civicrm_contact.id
Null on delete
FK_civicrm_sms_provider_domain_id
civicrm_sms_provider.domain_id
civicrm_domain.id
Null on delete
FK_civicrm_contribution_page_campaign_id
civicrm_contribution_page.campaign_id
civicrm_campaign.id
Null on delete
FK_civicrm_contribution_page_financial_type_id
civicrm_contribution_page.financial_type_id
civicrm_financial_type.id
Restrict delete
FK_civicrm_contribution_page_created_id
civicrm_contribution_page.created_id
civicrm_contact.id
Null on delete
FK_civicrm_line_item_price_field_value_id
civicrm_line_item.price_field_value_id
civicrm_price_field_value.id
Null on delete
FK_civicrm_line_item_price_field_id
civicrm_line_item.price_field_id
civicrm_price_field.id
Null on delete
FK_civicrm_line_item_financial_type_id
civicrm_line_item.financial_type_id
civicrm_financial_type.id
Null on delete
FK_civicrm_line_item_contribution_id
civicrm_line_item.contribution_id
civicrm_contribution.id
Null on delete
FK_civicrm_activity_original_id
civicrm_activity.original_id
civicrm_activity.id
Cascade on delete
FK_civicrm_activity_campaign_id
civicrm_activity.campaign_id
civicrm_campaign.id
Null on delete
FK_civicrm_activity_phone_id
civicrm_activity.phone_id
civicrm_phone.id
Null on delete
FK_civicrm_activity_relationship_id
civicrm_activity.relationship_id
civicrm_relationship.id
Null on delete
FK_civicrm_activity_parent_id
civicrm_activity.parent_id
civicrm_activity.id
Cascade on delete
FK_civicrm_mailing_event_trackable_url_open_event_queue_id
civicrm_mailing_event_trackable_url_open.event_queue_id
civicrm_mailing_event_queue.id
Cascade on delete
FK_civicrm_mailing_event_trackable_url_open_trackable_url_id
civicrm_mailing_event_trackable_url_open.trackable_url_id
civicrm_mailing_trackable_url.id
Cascade on delete
FK_civicrm_state_province_country_id
civicrm_state_province.country_id
civicrm_country.id
Restrict delete
FK_civicrm_mailing_event_bounce_event_queue_id
civicrm_mailing_event_bounce.event_queue_id
civicrm_mailing_event_queue.id
Cascade on delete
FK_civicrm_survey_last_modified_id
civicrm_survey.last_modified_id
civicrm_contact.id
Null on delete
FK_civicrm_survey_campaign_id
civicrm_survey.campaign_id
civicrm_campaign.id
Null on delete
FK_civicrm_survey_created_id
civicrm_survey.created_id
civicrm_contact.id
Null on delete
FK_civicrm_price_set_financial_type_id
civicrm_price_set.financial_type_id
civicrm_financial_type.id
Null on delete
FK_civicrm_price_set_domain_id
civicrm_price_set.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_action_log_action_schedule_id
civicrm_action_log.action_schedule_id
civicrm_action_schedule.id
Cascade on delete
FK_civicrm_action_log_contact_id
civicrm_action_log.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_membership_log_status_id
civicrm_membership_log.status_id
civicrm_membership_status.id
Cascade on delete
FK_civicrm_membership_log_modified_id
civicrm_membership_log.modified_id
civicrm_contact.id
Null on delete
FK_civicrm_membership_log_membership_id
civicrm_membership_log.membership_id
civicrm_membership.id
Cascade on delete
FK_civicrm_membership_log_membership_type_id
civicrm_membership_log.membership_type_id
civicrm_membership_type.id
Null on delete
FK_civicrm_group_organization_group_id
civicrm_group_organization.group_id
civicrm_group.id
Cascade on delete
FK_civicrm_group_organization_organization_id
civicrm_group_organization.organization_id
civicrm_contact.id
Cascade on delete
FK_civicrm_custom_group_created_id
civicrm_custom_group.created_id
civicrm_contact.id
Null on delete
FK_civicrm_email_contact_id
civicrm_email.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_mapping_field_location_type_id
civicrm_mapping_field.location_type_id
civicrm_location_type.id
Restrict delete
FK_civicrm_mapping_field_mapping_id
civicrm_mapping_field.mapping_id
civicrm_mapping.id
Restrict delete
FK_civicrm_mapping_field_relationship_type_id
civicrm_mapping_field.relationship_type_id
civicrm_relationship_type.id
Restrict delete
FK_civicrm_mailing_event_queue_email_id
civicrm_mailing_event_queue.email_id
civicrm_email.id
Null on delete
FK_civicrm_mailing_event_queue_contact_id
civicrm_mailing_event_queue.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_mailing_event_queue_phone_id
civicrm_mailing_event_queue.phone_id
civicrm_phone.id
Null on delete
FK_civicrm_mailing_event_queue_job_id
civicrm_mailing_event_queue.job_id
civicrm_mailing_job.id
Cascade on delete
FK_civicrm_print_label_created_id
civicrm_print_label.created_id
civicrm_contact.id
Null on delete
FK_civicrm_event_dedupe_rule_group_id
civicrm_event.dedupe_rule_group_id
civicrm_dedupe_rule_group.id
Restrict delete
FK_civicrm_event_campaign_id
civicrm_event.campaign_id
civicrm_campaign.id
Null on delete
FK_civicrm_event_created_id
civicrm_event.created_id
civicrm_contact.id
Null on delete
FK_civicrm_event_loc_block_id
civicrm_event.loc_block_id
civicrm_loc_block.id
Null on delete
FK_civicrm_pcp_block_supporter_profile_id
civicrm_pcp_block.supporter_profile_id
civicrm_uf_group.id
Null on delete
FK_civicrm_tag_created_id
civicrm_tag.created_id
civicrm_contact.id
Null on delete
FK_civicrm_tag_parent_id
civicrm_tag.parent_id
civicrm_tag.id
Restrict delete
FK_civicrm_membership_owner_membership_id
civicrm_membership.owner_membership_id
civicrm_membership.id
Null on delete
FK_civicrm_membership_membership_type_id
civicrm_membership.membership_type_id
civicrm_membership_type.id
Cascade on delete
FK_civicrm_membership_status_id
civicrm_membership.status_id
civicrm_membership_status.id
Cascade on delete
FK_civicrm_membership_contribution_recur_id
civicrm_membership.contribution_recur_id
civicrm_contribution_recur.id
Null on delete
FK_civicrm_membership_campaign_id
civicrm_membership.campaign_id
civicrm_campaign.id
Null on delete
FK_civicrm_membership_contact_id
civicrm_membership.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_address_country_id
civicrm_address.country_id
civicrm_country.id
Null on delete
FK_civicrm_address_contact_id
civicrm_address.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_address_master_id
civicrm_address.master_id
civicrm_address.id
Null on delete
FK_civicrm_address_state_province_id
civicrm_address.state_province_id
civicrm_state_province.id
Null on delete
FK_civicrm_address_county_id
civicrm_address.county_id
civicrm_county.id
Null on delete
FK_civicrm_website_contact_id
civicrm_website.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_entity_financial_account_financial_account_id
civicrm_entity_financial_account.financial_account_id
civicrm_financial_account.id
Restrict delete
FK_civicrm_mailing_bounce_pattern_bounce_type_id
civicrm_mailing_bounce_pattern.bounce_type_id
civicrm_mailing_bounce_type.id
Cascade on delete
FK_civicrm_job_domain_id
civicrm_job.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_case_contact_contact_id
civicrm_case_contact.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_case_contact_case_id
civicrm_case_contact.case_id
civicrm_case.id
Cascade on delete
FK_civicrm_loc_block_address_id
civicrm_loc_block.address_id
civicrm_address.id
Null on delete
FK_civicrm_loc_block_email_id
civicrm_loc_block.email_id
civicrm_email.id
Null on delete
FK_civicrm_loc_block_im_2_id
civicrm_loc_block.im_2_id
civicrm_im.id
Null on delete
FK_civicrm_loc_block_address_2_id
civicrm_loc_block.address_2_id
civicrm_address.id
Null on delete
FK_civicrm_loc_block_email_2_id
civicrm_loc_block.email_2_id
civicrm_email.id
Null on delete
FK_civicrm_loc_block_phone_2_id
civicrm_loc_block.phone_2_id
civicrm_phone.id
Null on delete
FK_civicrm_loc_block_phone_id
civicrm_loc_block.phone_id
civicrm_phone.id
Null on delete
FK_civicrm_loc_block_im_id
civicrm_loc_block.im_id
civicrm_im.id
Null on delete
FK_civicrm_discount_price_set_id
civicrm_discount.price_set_id
civicrm_price_set.id
Cascade on delete
FK_civicrm_country_address_format_id
civicrm_country.address_format_id
civicrm_address_format.id
Restrict delete
FK_civicrm_country_region_id
civicrm_country.region_id
civicrm_worldregion.id
Restrict delete
FK_civicrm_contribution_recur_financial_type_id
civicrm_contribution_recur.financial_type_id
civicrm_financial_type.id
Null on delete
FK_civicrm_contribution_recur_contact_id
civicrm_contribution_recur.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_contribution_recur_campaign_id
civicrm_contribution_recur.campaign_id
civicrm_campaign.id
Null on delete
FK_civicrm_contribution_recur_payment_token_id
civicrm_contribution_recur.payment_token_id
civicrm_payment_token.id
Null on delete
FK_civicrm_contribution_recur_payment_processor_id
civicrm_contribution_recur.payment_processor_id
civicrm_payment_processor.id
Null on delete
FK_civicrm_setting_domain_id
civicrm_setting.domain_id
civicrm_domain.id
Cascade on delete
FK_civicrm_setting_component_id
civicrm_setting.component_id
civicrm_component.id
Restrict delete
FK_civicrm_setting_created_id
civicrm_setting.created_id
civicrm_contact.id
Null on delete
FK_civicrm_setting_contact_id
civicrm_setting.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_uf_join_uf_group_id
civicrm_uf_join.uf_group_id
civicrm_uf_group.id
Restrict delete
FK_civicrm_navigation_domain_id
civicrm_navigation.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_navigation_parent_id
civicrm_navigation.parent_id
civicrm_navigation.id
Cascade on delete
FK_civicrm_entity_file_file_id
civicrm_entity_file.file_id
civicrm_file.id
Restrict delete
FK_civicrm_financial_item_financial_account_id
civicrm_financial_item.financial_account_id
civicrm_financial_account.id
Restrict delete
FK_civicrm_financial_item_contact_id
civicrm_financial_item.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_events_in_carts_event_cart_id
civicrm_events_in_carts.event_cart_id
civicrm_event_carts.id
Cascade on delete
FK_civicrm_events_in_carts_event_id
civicrm_events_in_carts.event_id
civicrm_event.id
Cascade on delete
FK_civicrm_menu_domain_id
civicrm_menu.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_menu_component_id
civicrm_menu.component_id
civicrm_component.id
Restrict delete
FK_civicrm_uf_field_location_type_id
civicrm_uf_field.location_type_id
civicrm_location_type.id
Null on delete
FK_civicrm_uf_field_uf_group_id
civicrm_uf_field.uf_group_id
civicrm_uf_group.id
Cascade on delete
FK_civicrm_membership_block_membership_type_default
civicrm_membership_block.membership_type_default
civicrm_membership_type.id
Restrict delete
FK_civicrm_membership_block_entity_id
civicrm_membership_block.entity_id
civicrm_contribution_page.id
Restrict delete
FK_civicrm_pcp_contact_id
civicrm_pcp.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_acl_contact_cache_contact_id
civicrm_acl_contact_cache.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_acl_contact_cache_user_id
civicrm_acl_contact_cache.user_id
civicrm_contact.id
Cascade on delete
FK_civicrm_contribution_widget_contribution_page_id
civicrm_contribution_widget.contribution_page_id
civicrm_contribution_page.id
Cascade on delete
FK_civicrm_mailing_trackable_url_mailing_id
civicrm_mailing_trackable_url.mailing_id
civicrm_mailing.id
Cascade on delete
FK_civicrm_domain_contact_id
civicrm_domain.contact_id
civicrm_contact.id
Restrict delete
FK_civicrm_mailing_event_reply_event_queue_id
civicrm_mailing_event_reply.event_queue_id
civicrm_mailing_event_queue.id
Cascade on delete
FK_civicrm_payment_token_payment_processor_id
civicrm_payment_token.payment_processor_id
civicrm_payment_processor.id
Restrict delete
FK_civicrm_payment_token_created_id
civicrm_payment_token.created_id
civicrm_contact.id
Null on delete
FK_civicrm_payment_token_contact_id
civicrm_payment_token.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_contact_type_parent_id
civicrm_contact_type.parent_id
civicrm_contact_type.id
Restrict delete
FK_civicrm_financial_trxn_to_financial_account_id
civicrm_financial_trxn.to_financial_account_id
civicrm_financial_account.id
Restrict delete
FK_civicrm_financial_trxn_from_financial_account_id
civicrm_financial_trxn.from_financial_account_id
civicrm_financial_account.id
Restrict delete
FK_civicrm_financial_trxn_payment_processor_id
civicrm_financial_trxn.payment_processor_id
civicrm_payment_processor.id
Null on delete
FK_civicrm_campaign_parent_id
civicrm_campaign.parent_id
civicrm_campaign.id
Null on delete
FK_civicrm_campaign_created_id
civicrm_campaign.created_id
civicrm_contact.id
Null on delete
FK_civicrm_campaign_last_modified_id
civicrm_campaign.last_modified_id
civicrm_contact.id
Null on delete
FK_civicrm_custom_field_custom_group_id
civicrm_custom_field.custom_group_id
civicrm_custom_group.id
Cascade on delete
FK_civicrm_phone_contact_id
civicrm_phone.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_price_field_price_set_id
civicrm_price_field.price_set_id
civicrm_price_set.id
Restrict delete
FK_civicrm_word_replacement_domain_id
civicrm_word_replacement.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_mailing_event_unsubscribe_event_queue_id
civicrm_mailing_event_unsubscribe.event_queue_id
civicrm_mailing_event_queue.id
Cascade on delete
FK_civicrm_dashboard_contact_dashboard_id
civicrm_dashboard_contact.dashboard_id
civicrm_dashboard.id
Cascade on delete
FK_civicrm_dashboard_contact_contact_id
civicrm_dashboard_contact.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_mailing_group_mailing_id
civicrm_mailing_group.mailing_id
civicrm_mailing.id
Cascade on delete
FK_civicrm_dedupe_exception_contact_id2
civicrm_dedupe_exception.contact_id2
civicrm_contact.id
Cascade on delete
FK_civicrm_dedupe_exception_contact_id1
civicrm_dedupe_exception.contact_id1
civicrm_contact.id
Cascade on delete
FK_civicrm_membership_payment_contribution_id
civicrm_membership_payment.contribution_id
civicrm_contribution.id
Cascade on delete
FK_civicrm_membership_payment_membership_id
civicrm_membership_payment.membership_id
civicrm_membership.id
Cascade on delete
FK_civicrm_job_log_domain_id
civicrm_job_log.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_mailing_msg_template_id
civicrm_mailing.msg_template_id
civicrm_msg_template.id
Null on delete
FK_civicrm_mailing_optout_id
civicrm_mailing.optout_id
civicrm_mailing_component.id
Null on delete
FK_civicrm_mailing_created_id
civicrm_mailing.created_id
civicrm_contact.id
Null on delete
FK_civicrm_mailing_campaign_id
civicrm_mailing.campaign_id
civicrm_campaign.id
Null on delete
FK_civicrm_mailing_footer_id
civicrm_mailing.footer_id
civicrm_mailing_component.id
Null on delete
FK_civicrm_mailing_approver_id
civicrm_mailing.approver_id
civicrm_contact.id
Null on delete
FK_civicrm_mailing_scheduled_id
civicrm_mailing.scheduled_id
civicrm_contact.id
Null on delete
FK_civicrm_mailing_reply_id
civicrm_mailing.reply_id
civicrm_mailing_component.id
Null on delete
FK_civicrm_mailing_domain_id
civicrm_mailing.domain_id
civicrm_domain.id
Null on delete
FK_civicrm_mailing_header_id
civicrm_mailing.header_id
civicrm_mailing_component.id
Null on delete
FK_civicrm_mailing_sms_provider_id
civicrm_mailing.sms_provider_id
civicrm_sms_provider.id
Null on delete
FK_civicrm_mailing_location_type_id
civicrm_mailing.location_type_id
civicrm_location_type.id
Null on delete
FK_civicrm_mailing_unsubscribe_id
civicrm_mailing.unsubscribe_id
civicrm_mailing_component.id
Null on delete
FK_civicrm_acl_cache_contact_id
civicrm_acl_cache.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_acl_cache_acl_id
civicrm_acl_cache.acl_id
civicrm_acl.id
Cascade on delete
FK_civicrm_premiums_product_product_id
civicrm_premiums_product.product_id
civicrm_product.id
Restrict delete
FK_civicrm_premiums_product_financial_type_id
civicrm_premiums_product.financial_type_id
civicrm_financial_type.id
Null on delete
FK_civicrm_premiums_product_premiums_id
civicrm_premiums_product.premiums_id
civicrm_premiums.id
Restrict delete
FK_civicrm_cache_component_id
civicrm_cache.component_id
civicrm_component.id
Restrict delete
FK_civicrm_contribution_address_id
civicrm_contribution.address_id
civicrm_address.id
Null on delete
FK_civicrm_contribution_campaign_id
civicrm_contribution.campaign_id
civicrm_campaign.id
Null on delete
FK_civicrm_contribution_contact_id
civicrm_contribution.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_contribution_contribution_page_id
civicrm_contribution.contribution_page_id
civicrm_contribution_page.id
Null on delete
FK_civicrm_contribution_financial_type_id
civicrm_contribution.financial_type_id
civicrm_financial_type.id
Restrict delete
FK_civicrm_contribution_contribution_recur_id
civicrm_contribution.contribution_recur_id
civicrm_contribution_recur.id
Null on delete
FK_civicrm_pledge_payment_pledge_id
civicrm_pledge_payment.pledge_id
civicrm_pledge.id
Cascade on delete
FK_civicrm_pledge_payment_contribution_id
civicrm_pledge_payment.contribution_id
civicrm_contribution.id
Cascade on delete
FK_civicrm_payment_processor_domain_id
civicrm_payment_processor.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_payment_processor_payment_processor_type_id
civicrm_payment_processor.payment_processor_type_id
civicrm_payment_processor_type.id
Restrict delete
FK_civicrm_group_contact_email_id
civicrm_group_contact.email_id
civicrm_email.id
Restrict delete
FK_civicrm_group_contact_contact_id
civicrm_group_contact.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_group_contact_group_id
civicrm_group_contact.group_id
civicrm_group.id
Cascade on delete
FK_civicrm_group_contact_location_id
civicrm_group_contact.location_id
civicrm_loc_block.id
Null on delete
FK_civicrm_timezone_country_id
civicrm_timezone.country_id
civicrm_country.id
Restrict delete
FK_civicrm_group_contact_cache_group_id
civicrm_group_contact_cache.group_id
civicrm_group.id
Cascade on delete
FK_civicrm_group_contact_cache_contact_id
civicrm_group_contact_cache.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_mailing_event_subscribe_group_id
civicrm_mailing_event_subscribe.group_id
civicrm_group.id
Cascade on delete
FK_civicrm_mailing_event_subscribe_contact_id
civicrm_mailing_event_subscribe.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_contribution_soft_contribution_id
civicrm_contribution_soft.contribution_id
civicrm_contribution.id
Cascade on delete
FK_civicrm_contribution_soft_pcp_id
civicrm_contribution_soft.pcp_id
civicrm_pcp.id
Null on delete
FK_civicrm_contribution_soft_contact_id
civicrm_contribution_soft.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_dashboard_domain_id
civicrm_dashboard.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_pledge_campaign_id
civicrm_pledge.campaign_id
civicrm_campaign.id
Null on delete
FK_civicrm_pledge_financial_type_id
civicrm_pledge.financial_type_id
civicrm_financial_type.id
Restrict delete
FK_civicrm_pledge_contribution_page_id
civicrm_pledge.contribution_page_id
civicrm_contribution_page.id
Null on delete
FK_civicrm_pledge_contact_id
civicrm_pledge.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_participant_transferred_to_contact_id
civicrm_participant.transferred_to_contact_id
civicrm_contact.id
Null on delete
FK_civicrm_participant_campaign_id
civicrm_participant.campaign_id
civicrm_campaign.id
Null on delete
FK_civicrm_participant_discount_id
civicrm_participant.discount_id
civicrm_discount.id
Null on delete
FK_civicrm_participant_event_id
civicrm_participant.event_id
civicrm_event.id
Cascade on delete
FK_civicrm_participant_registered_by_id
civicrm_participant.registered_by_id
civicrm_participant.id
Null on delete
FK_civicrm_participant_cart_id
civicrm_participant.cart_id
civicrm_event_carts.id
Null on delete
FK_civicrm_participant_contact_id
civicrm_participant.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_participant_status_id
civicrm_participant.status_id
civicrm_participant_status_type.id
Restrict delete
FK_civicrm_financial_account_parent_id
civicrm_financial_account.parent_id
civicrm_financial_account.id
Restrict delete
FK_civicrm_financial_account_contact_id
civicrm_financial_account.contact_id
civicrm_contact.id
Null on delete
FK_civicrm_mail_settings_domain_id
civicrm_mail_settings.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_grant_contact_id
civicrm_grant.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_grant_financial_type_id
civicrm_grant.financial_type_id
civicrm_financial_type.id
Null on delete
FK_civicrm_campaign_group_campaign_id
civicrm_campaign_group.campaign_id
civicrm_campaign.id
Cascade on delete
FK_civicrm_contribution_product_financial_type_id
civicrm_contribution_product.financial_type_id
civicrm_financial_type.id
Null on delete
FK_civicrm_contribution_product_contribution_id
civicrm_contribution_product.contribution_id
civicrm_contribution.id
Cascade on delete
FK_civicrm_mailing_recipients_phone_id
civicrm_mailing_recipients.phone_id
civicrm_phone.id
Null on delete
FK_civicrm_mailing_recipients_email_id
civicrm_mailing_recipients.email_id
civicrm_email.id
Null on delete
FK_civicrm_mailing_recipients_contact_id
civicrm_mailing_recipients.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_mailing_recipients_mailing_id
civicrm_mailing_recipients.mailing_id
civicrm_mailing.id
Cascade on delete
FK_civicrm_mailing_event_delivered_event_queue_id
civicrm_mailing_event_delivered.event_queue_id
civicrm_mailing_event_queue.id
Cascade on delete
FK_civicrm_price_field_value_membership_type_id
civicrm_price_field_value.membership_type_id
civicrm_membership_type.id
Null on delete
FK_civicrm_price_field_value_financial_type_id
civicrm_price_field_value.financial_type_id
civicrm_financial_type.id
Null on delete
FK_civicrm_price_field_value_price_field_id
civicrm_price_field_value.price_field_id
civicrm_price_field.id
Restrict delete
FK_civicrm_mailing_event_forward_dest_queue_id
civicrm_mailing_event_forward.dest_queue_id
civicrm_mailing_event_queue.id
Null on delete
FK_civicrm_mailing_event_forward_event_queue_id
civicrm_mailing_event_forward.event_queue_id
civicrm_mailing_event_queue.id
Cascade on delete
FK_civicrm_mailing_spool_job_id
civicrm_mailing_spool.job_id
civicrm_mailing_job.id
Cascade on delete
FK_civicrm_uf_match_domain_id
civicrm_uf_match.domain_id
civicrm_domain.id
Restrict delete
FK_civicrm_uf_match_contact_id
civicrm_uf_match.contact_id
civicrm_contact.id
Cascade on delete
FK_civicrm_case_case_type_id
civicrm_case.case_type_id
civicrm_case_type.id
Restrict delete
FK_civicrm_log_modified_id
civicrm_log.modified_id
civicrm_contact.id
Cascade on delete
FK_civicrm_mailing_event_confirm_event_subscribe_id
civicrm_mailing_event_confirm.event_subscribe_id
civicrm_mailing_event_subscribe.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
None detected