Constraints

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

Cascade on delete

FK_civicrm_report_instance_domain_id

civicrm_report_instance.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

Null on delete

FK_civicrm_report_instance_owner_id

civicrm_report_instance.owner_id

Null on delete

FK_civicrm_mailing_job_mailing_id

civicrm_mailing_job.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

Null on delete

FK_civicrm_group_modified_id

civicrm_group.modified_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

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

Null on delete

FK_civicrm_group_nesting_child_group_id

civicrm_group_nesting.child_group_id

Cascade on delete

FK_civicrm_group_nesting_parent_group_id

civicrm_group_nesting.parent_group_id

Cascade on delete

FK_civicrm_uf_group_created_id

civicrm_uf_group.created_id

Null on delete

FK_civicrm_uf_group_add_to_group_id

civicrm_uf_group.add_to_group_id

Null on delete

FK_civicrm_uf_group_limit_listings_group_id

civicrm_uf_group.limit_listings_group_id

Null on delete

FK_civicrm_im_contact_id

civicrm_im.contact_id

Cascade on delete

FK_civicrm_entity_batch_batch_id

civicrm_entity_batch.batch_id

civicrm_batch.id

Cascade on delete

FK_civicrm_value_informations__1_entity_id

civicrm_value_informations__1.entity_id

Cascade on delete

FK_civicrm_mailing_abtest_created_id

civicrm_mailing_abtest.created_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

Restrict delete

FK_civicrm_membership_type_domain_id

civicrm_membership_type.domain_id

Restrict delete

FK_civicrm_membership_type_member_of_contact_id

civicrm_membership_type.member_of_contact_id

Restrict delete

FK_civicrm_product_financial_type_id

civicrm_product.financial_type_id

Null on delete

FK_civicrm_contact_primary_contact_id

civicrm_contact.primary_contact_id

Null on delete

FK_civicrm_contact_employer_id

civicrm_contact.employer_id

Null on delete

FK_civicrm_participant_payment_contribution_id

civicrm_participant_payment.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

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

Restrict delete

FK_civicrm_option_value_domain_id

civicrm_option_value.domain_id

Restrict delete

FK_civicrm_openid_contact_id

civicrm_openid.contact_id

Cascade on delete

FK_civicrm_activity_contact_activity_id

civicrm_activity_contact.activity_id

Cascade on delete

FK_civicrm_activity_contact_contact_id

civicrm_activity_contact.contact_id

Cascade on delete

FK_civicrm_subscription_history_contact_id

civicrm_subscription_history.contact_id

Cascade on delete

FK_civicrm_subscription_history_group_id

civicrm_subscription_history.group_id

Cascade on delete

FK_civicrm_mailing_event_opened_event_queue_id

civicrm_mailing_event_opened.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

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

Null on delete

FK_civicrm_action_schedule_group_id

civicrm_action_schedule.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

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

Null on delete

FK_civicrm_batch_modified_id

civicrm_batch.modified_id

Null on delete

FK_civicrm_sms_provider_domain_id

civicrm_sms_provider.domain_id

Null on delete

FK_civicrm_contribution_page_campaign_id

civicrm_contribution_page.campaign_id

Null on delete

FK_civicrm_contribution_page_financial_type_id

civicrm_contribution_page.financial_type_id

Restrict delete

FK_civicrm_contribution_page_created_id

civicrm_contribution_page.created_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

Null on delete

FK_civicrm_line_item_contribution_id

civicrm_line_item.contribution_id

Null on delete

FK_civicrm_activity_original_id

civicrm_activity.original_id

Cascade on delete

FK_civicrm_activity_campaign_id

civicrm_activity.campaign_id

Null on delete

FK_civicrm_activity_phone_id

civicrm_activity.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

Cascade on delete

FK_civicrm_mailing_event_trackable_url_open_event_queue_id

civicrm_mailing_event_trackable_url_open.event_queue_id

civicrm_mailing_trackable_url.id

Cascade on delete

FK_civicrm_mailing_event_trackable_url_open_trackable_url_id

civicrm_mailing_event_trackable_url_open.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

Cascade on delete

FK_civicrm_survey_last_modified_id

civicrm_survey.last_modified_id

Null on delete

FK_civicrm_survey_campaign_id

civicrm_survey.campaign_id

Null on delete

FK_civicrm_survey_created_id

civicrm_survey.created_id

Null on delete

FK_civicrm_price_set_financial_type_id

civicrm_price_set.financial_type_id

Null on delete

FK_civicrm_price_set_domain_id

civicrm_price_set.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

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

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

Null on delete

FK_civicrm_group_organization_group_id

civicrm_group_organization.group_id

Cascade on delete

FK_civicrm_group_organization_organization_id

civicrm_group_organization.organization_id

Cascade on delete

FK_civicrm_custom_group_created_id

civicrm_custom_group.created_id

Null on delete

FK_civicrm_email_contact_id

civicrm_email.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

Null on delete

FK_civicrm_mailing_event_queue_contact_id

civicrm_mailing_event_queue.contact_id

Cascade on delete

FK_civicrm_mailing_event_queue_phone_id

civicrm_mailing_event_queue.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

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

Null on delete

FK_civicrm_event_created_id

civicrm_event.created_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

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

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

Null on delete

FK_civicrm_membership_contact_id

civicrm_membership.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

Cascade on delete

FK_civicrm_address_master_id

civicrm_address.master_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

Cascade on delete

FK_civicrm_entity_financial_account_financial_account_id

civicrm_entity_financial_account.financial_account_id

civicrm_mailing_bounce_type.id

Restrict delete

FK_civicrm_mailing_bounce_pattern_bounce_type_id

civicrm_mailing_bounce_pattern.bounce_type_id

Cascade on delete

FK_civicrm_job_domain_id

civicrm_job.domain_id

Restrict delete

FK_civicrm_case_contact_contact_id

civicrm_case_contact.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

Null on delete

FK_civicrm_loc_block_email_id

civicrm_loc_block.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

Null on delete

FK_civicrm_loc_block_email_2_id

civicrm_loc_block.email_2_id

Null on delete

FK_civicrm_loc_block_phone_2_id

civicrm_loc_block.phone_2_id

Null on delete

FK_civicrm_loc_block_phone_id

civicrm_loc_block.phone_id

Null on delete

FK_civicrm_loc_block_im_id

civicrm_loc_block.im_id

civicrm_im.id

Null 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_discount_price_set_id

civicrm_discount.price_set_id

civicrm_price_set.id

Cascade on delete

FK_civicrm_contribution_recur_financial_type_id

civicrm_contribution_recur.financial_type_id

Null on delete

FK_civicrm_contribution_recur_contact_id

civicrm_contribution_recur.contact_id

Cascade on delete

FK_civicrm_contribution_recur_campaign_id

civicrm_contribution_recur.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

Cascade on delete

FK_civicrm_setting_component_id

civicrm_setting.component_id

Restrict delete

FK_civicrm_setting_created_id

civicrm_setting.created_id

Null on delete

FK_civicrm_setting_contact_id

civicrm_setting.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

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

Restrict delete

FK_civicrm_financial_item_contact_id

civicrm_financial_item.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

Restrict delete

FK_civicrm_menu_component_id

civicrm_menu.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

Restrict delete

FK_civicrm_membership_block_entity_id

civicrm_membership_block.entity_id

Restrict delete

FK_civicrm_pcp_contact_id

civicrm_pcp.contact_id

Cascade on delete

FK_civicrm_acl_contact_cache_contact_id

civicrm_acl_contact_cache.contact_id

Cascade on delete

FK_civicrm_acl_contact_cache_user_id

civicrm_acl_contact_cache.user_id

Cascade on delete

FK_civicrm_contribution_widget_contribution_page_id

civicrm_contribution_widget.contribution_page_id

Cascade on delete

FK_civicrm_mailing_trackable_url_mailing_id

civicrm_mailing_trackable_url.mailing_id

Cascade on delete

FK_civicrm_domain_contact_id

civicrm_domain.contact_id

Restrict delete

FK_civicrm_mailing_event_reply_event_queue_id

civicrm_mailing_event_reply.event_queue_id

Cascade on delete

FK_civicrm_file_created_id

civicrm_file.created_id

Null 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

Null on delete

FK_civicrm_payment_token_contact_id

civicrm_payment_token.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

Restrict delete

FK_civicrm_financial_trxn_from_financial_account_id

civicrm_financial_trxn.from_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

Null on delete

FK_civicrm_campaign_created_id

civicrm_campaign.created_id

Null on delete

FK_civicrm_campaign_last_modified_id

civicrm_campaign.last_modified_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

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

Restrict delete

FK_civicrm_mailing_event_unsubscribe_event_queue_id

civicrm_mailing_event_unsubscribe.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

Cascade on delete

FK_civicrm_mailing_group_mailing_id

civicrm_mailing_group.mailing_id

Cascade on delete

FK_civicrm_dedupe_exception_contact_id2

civicrm_dedupe_exception.contact_id2

Cascade on delete

FK_civicrm_dedupe_exception_contact_id1

civicrm_dedupe_exception.contact_id1

Cascade on delete

FK_civicrm_membership_payment_contribution_id

civicrm_membership_payment.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

Restrict delete

FK_civicrm_mailing_msg_template_id

civicrm_mailing.msg_template_id

Null on delete

FK_civicrm_mailing_optout_id

civicrm_mailing.optout_id

Null on delete

FK_civicrm_mailing_created_id

civicrm_mailing.created_id

Null on delete

FK_civicrm_mailing_campaign_id

civicrm_mailing.campaign_id

Null on delete

FK_civicrm_mailing_footer_id

civicrm_mailing.footer_id

Null on delete

FK_civicrm_mailing_approver_id

civicrm_mailing.approver_id

Null on delete

FK_civicrm_mailing_scheduled_id

civicrm_mailing.scheduled_id

Null on delete

FK_civicrm_mailing_reply_id

civicrm_mailing.reply_id

Null on delete

FK_civicrm_mailing_domain_id

civicrm_mailing.domain_id

Null on delete

FK_civicrm_mailing_header_id

civicrm_mailing.header_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

Null on delete

FK_civicrm_acl_cache_contact_id

civicrm_acl_cache.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

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

Restrict delete

FK_civicrm_contribution_address_id

civicrm_contribution.address_id

Null on delete

FK_civicrm_contribution_campaign_id

civicrm_contribution.campaign_id

Null on delete

FK_civicrm_contribution_contact_id

civicrm_contribution.contact_id

Cascade on delete

FK_civicrm_contribution_contribution_page_id

civicrm_contribution.contribution_page_id

Null on delete

FK_civicrm_contribution_financial_type_id

civicrm_contribution.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

Cascade on delete

FK_civicrm_mosaico_template_msg_tpl_id

civicrm_mosaico_template.msg_tpl_id

Null on delete

FK_civicrm_payment_processor_domain_id

civicrm_payment_processor.domain_id

civicrm_payment_processor_type.id

Restrict delete

FK_civicrm_payment_processor_payment_processor_type_id

civicrm_payment_processor.payment_processor_type_id

Restrict delete

FK_civicrm_group_contact_email_id

civicrm_group_contact.email_id

Restrict delete

FK_civicrm_group_contact_contact_id

civicrm_group_contact.contact_id

Cascade on delete

FK_civicrm_group_contact_group_id

civicrm_group_contact.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

Cascade on delete

FK_civicrm_group_contact_cache_contact_id

civicrm_group_contact_cache.contact_id

Cascade on delete

FK_civicrm_mailing_event_subscribe_group_id

civicrm_mailing_event_subscribe.group_id

Cascade on delete

FK_civicrm_mailing_event_subscribe_contact_id

civicrm_mailing_event_subscribe.contact_id

Cascade on delete

FK_civicrm_contribution_soft_contribution_id

civicrm_contribution_soft.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

Cascade on delete

FK_civicrm_dashboard_domain_id

civicrm_dashboard.domain_id

Cascade on delete

FK_civicrm_pledge_campaign_id

civicrm_pledge.campaign_id

Null on delete

FK_civicrm_pledge_financial_type_id

civicrm_pledge.financial_type_id

Restrict delete

FK_civicrm_pledge_contribution_page_id

civicrm_pledge.contribution_page_id

Null on delete

FK_civicrm_pledge_contact_id

civicrm_pledge.contact_id

Cascade on delete

FK_civicrm_participant_transferred_to_contact_id

civicrm_participant.transferred_to_contact_id

Null on delete

FK_civicrm_participant_campaign_id

civicrm_participant.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_participant_status_type.id

Cascade on delete

FK_civicrm_participant_status_id

civicrm_participant.status_id

Restrict delete

FK_civicrm_financial_account_parent_id

civicrm_financial_account.parent_id

Restrict delete

FK_civicrm_financial_account_contact_id

civicrm_financial_account.contact_id

Null on delete

FK_civicrm_mail_settings_domain_id

civicrm_mail_settings.domain_id

Restrict delete

FK_civicrm_mosaico_msg_template_msg_tpl_id

civicrm_mosaico_msg_template.msg_tpl_id

Cascade on delete

FK_civicrm_grant_contact_id

civicrm_grant.contact_id

Cascade on delete

FK_civicrm_grant_financial_type_id

civicrm_grant.financial_type_id

Null on delete

FK_civicrm_campaign_group_campaign_id

civicrm_campaign_group.campaign_id

Cascade on delete

FK_civicrm_contribution_product_financial_type_id

civicrm_contribution_product.financial_type_id

Null on delete

FK_civicrm_contribution_product_contribution_id

civicrm_contribution_product.contribution_id

Cascade on delete

FK_civicrm_mailing_recipients_phone_id

civicrm_mailing_recipients.phone_id

Null on delete

FK_civicrm_mailing_recipients_email_id

civicrm_mailing_recipients.email_id

Null on delete

FK_civicrm_mailing_recipients_contact_id

civicrm_mailing_recipients.contact_id

Cascade on delete

FK_civicrm_mailing_recipients_mailing_id

civicrm_mailing_recipients.mailing_id

Cascade on delete

FK_civicrm_mailing_event_delivered_event_queue_id

civicrm_mailing_event_delivered.event_queue_id

Cascade on delete

FK_civicrm_price_field_value_membership_type_id

civicrm_price_field_value.membership_type_id

Null on delete

FK_civicrm_price_field_value_financial_type_id

civicrm_price_field_value.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

Null on delete

FK_civicrm_mailing_event_forward_event_queue_id

civicrm_mailing_event_forward.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

Restrict delete

FK_civicrm_uf_match_contact_id

civicrm_uf_match.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