SchemaSpy Analysis of d47civi_0z3xa - Constraints Generated by
SchemaSpy
281 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
FK_civicrm_acl_cache_acl_id civicrm_acl_cache.acl_id civicrm_acl.id Cascade on delete 
FK_civicrm_acl_cache_contact_id civicrm_acl_cache.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_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_action_schedule_group_id civicrm_action_schedule.group_id civicrm_group.id Null on 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_activity_campaign_id civicrm_activity.campaign_id civicrm_campaign.id Null 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_activity_original_id civicrm_activity.original_id civicrm_activity.id Cascade on delete 
FK_civicrm_activity_parent_id civicrm_activity.parent_id civicrm_activity.id Cascade 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_address_contact_id civicrm_address.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_county_id civicrm_address.county_id civicrm_county.id Null 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_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_batch_saved_search_id civicrm_batch.saved_search_id civicrm_saved_search.id Null on delete 
FK_civicrm_cache_component_id civicrm_cache.component_id civicrm_component.id Restrict delete 
FK_civicrm_campaign_created_id civicrm_campaign.created_id civicrm_contact.id Null on delete 
FK_civicrm_campaign_group_campaign_id civicrm_campaign_group.campaign_id civicrm_campaign.id Cascade on delete 
FK_civicrm_campaign_last_modified_id civicrm_campaign.last_modified_id civicrm_contact.id Null on delete 
FK_civicrm_campaign_parent_id civicrm_campaign.parent_id civicrm_campaign.id Null 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_case_case_type_id civicrm_case.case_type_id civicrm_case_type.id Null on delete 
FK_civicrm_case_contact_case_id civicrm_case_contact.case_id civicrm_case.id Cascade on delete 
FK_civicrm_case_contact_contact_id civicrm_case_contact.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_contact_employer_id civicrm_contact.employer_id civicrm_contact.id Null on delete 
FK_civicrm_contact_primary_contact_id civicrm_contact.primary_contact_id civicrm_contact.id Null on delete 
FK_civicrm_contact_type_parent_id civicrm_contact_type.parent_id civicrm_contact_type.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_contribution_recur_id civicrm_contribution.contribution_recur_id civicrm_contribution_recur.id Null on delete 
FK_civicrm_contribution_financial_type_id civicrm_contribution.financial_type_id civicrm_financial_type.id Restrict delete 
FK_civicrm_contribution_page_campaign_id civicrm_contribution_page.campaign_id civicrm_campaign.id Null on delete 
FK_civicrm_contribution_page_created_id civicrm_contribution_page.created_id civicrm_contact.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_product_contribution_id civicrm_contribution_product.contribution_id civicrm_contribution.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_recur_campaign_id civicrm_contribution_recur.campaign_id civicrm_campaign.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_financial_type_id civicrm_contribution_recur.financial_type_id civicrm_financial_type.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_contribution_recur_payment_token_id civicrm_contribution_recur.payment_token_id civicrm_payment_token.id Null on delete 
FK_civicrm_contribution_soft_contact_id civicrm_contribution_soft.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_widget_contribution_page_id civicrm_contribution_widget.contribution_page_id civicrm_contribution_page.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_county_state_province_id civicrm_county.state_province_id civicrm_state_province.id Restrict delete 
FK_civicrm_custom_field_custom_group_id civicrm_custom_field.custom_group_id civicrm_custom_group.id Cascade on delete 
FK_civicrm_custom_group_created_id civicrm_custom_group.created_id civicrm_contact.id Null on delete 
FK_civicrm_dashboard_contact_contact_id civicrm_dashboard_contact.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_dashboard_contact_dashboard_id civicrm_dashboard_contact.dashboard_id civicrm_dashboard.id Cascade on delete 
FK_civicrm_dashboard_domain_id civicrm_dashboard.domain_id civicrm_domain.id Restrict delete 
FK_civicrm_dedupe_exception_contact_id1 civicrm_dedupe_exception.contact_id1 civicrm_contact.id Cascade on delete 
FK_civicrm_dedupe_exception_contact_id2 civicrm_dedupe_exception.contact_id2 civicrm_contact.id Cascade on 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_discount_price_set_id civicrm_discount.price_set_id civicrm_price_set.id Cascade on delete 
FK_civicrm_domain_contact_id civicrm_domain.contact_id civicrm_contact.id Restrict delete 
FK_civicrm_email_contact_id civicrm_email.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_entity_file_file_id civicrm_entity_file.file_id civicrm_file.id Restrict delete 
FK_civicrm_entity_financial_account_financial_account_id civicrm_entity_financial_account.financial_account_id civicrm_financial_account.id Restrict 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_entity_tag_tag_id civicrm_entity_tag.tag_id civicrm_tag.id Cascade on delete 
FK_civicrm_event_campaign_id civicrm_event.campaign_id civicrm_campaign.id Null on delete 
FK_civicrm_event_carts_user_id civicrm_event_carts.user_id civicrm_contact.id Null on delete 
FK_civicrm_event_created_id civicrm_event.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_loc_block_id civicrm_event.loc_block_id civicrm_loc_block.id Null 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_financial_account_contact_id civicrm_financial_account.contact_id civicrm_contact.id Null on delete 
FK_civicrm_financial_account_parent_id civicrm_financial_account.parent_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_financial_item_financial_account_id civicrm_financial_item.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_financial_trxn_to_financial_account_id civicrm_financial_trxn.to_financial_account_id civicrm_financial_account.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_group_contact_cache_contact_id civicrm_group_contact_cache.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_group_contact_cache_group_id civicrm_group_contact_cache.group_id civicrm_group.id Cascade on delete 
FK_civicrm_group_contact_contact_id civicrm_group_contact.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_group_contact_email_id civicrm_group_contact.email_id civicrm_email.id Restrict 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_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_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_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_group_saved_search_id civicrm_group.saved_search_id civicrm_saved_search.id Null on delete 
FK_civicrm_im_contact_id civicrm_im.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_job_domain_id civicrm_job.domain_id civicrm_domain.id Restrict delete 
FK_civicrm_job_log_domain_id civicrm_job_log.domain_id civicrm_domain.id Restrict delete 
FK_civicrm_line_item_contribution_id civicrm_line_item.contribution_id civicrm_contribution.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_price_field_id civicrm_line_item.price_field_id civicrm_price_field.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_loc_block_address_2_id civicrm_loc_block.address_2_id civicrm_address.id Null on delete 
FK_civicrm_loc_block_address_id civicrm_loc_block.address_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_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_im_id civicrm_loc_block.im_id civicrm_im.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_log_modified_id civicrm_log.modified_id civicrm_contact.id Cascade on delete 
FK_civicrm_mail_settings_domain_id civicrm_mail_settings.domain_id civicrm_domain.id Cascade on delete 
FK_civicrm_mailing_abtest_created_id civicrm_mailing_abtest.created_id civicrm_contact.id Null on delete 
FK_civicrm_mailing_approver_id civicrm_mailing.approver_id civicrm_contact.id Null on 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_mailing_campaign_id civicrm_mailing.campaign_id civicrm_campaign.id Null on delete 
FK_civicrm_mailing_created_id civicrm_mailing.created_id civicrm_contact.id Null on delete 
FK_civicrm_mailing_domain_id civicrm_mailing.domain_id civicrm_domain.id Null on 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_mailing_event_confirm_event_subscribe_id civicrm_mailing_event_confirm.event_subscribe_id civicrm_mailing_event_subscribe.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_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_event_opened_event_queue_id civicrm_mailing_event_opened.event_queue_id civicrm_mailing_event_queue.id Cascade 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_email_id civicrm_mailing_event_queue.email_id civicrm_email.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_mailing_event_queue_phone_id civicrm_mailing_event_queue.phone_id civicrm_phone.id Null on 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_mailing_event_subscribe_contact_id civicrm_mailing_event_subscribe.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_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_mailing_event_unsubscribe_event_queue_id civicrm_mailing_event_unsubscribe.event_queue_id civicrm_mailing_event_queue.id Cascade on delete 
FK_civicrm_mailing_footer_id civicrm_mailing.footer_id civicrm_mailing_component.id Null on delete 
FK_civicrm_mailing_group_mailing_id civicrm_mailing_group.mailing_id civicrm_mailing.id Cascade on delete 
FK_civicrm_mailing_header_id civicrm_mailing.header_id civicrm_mailing_component.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_mailing_location_type_id civicrm_mailing.location_type_id civicrm_location_type.id Null on 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_recipients_contact_id civicrm_mailing_recipients.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_mailing_recipients_email_id civicrm_mailing_recipients.email_id civicrm_email.id Null on delete 
FK_civicrm_mailing_recipients_mailing_id civicrm_mailing_recipients.mailing_id civicrm_mailing.id Cascade on delete 
FK_civicrm_mailing_recipients_phone_id civicrm_mailing_recipients.phone_id civicrm_phone.id Null on delete 
FK_civicrm_mailing_reply_id civicrm_mailing.reply_id civicrm_mailing_component.id Null on delete 
FK_civicrm_mailing_scheduled_id civicrm_mailing.scheduled_id civicrm_contact.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_spool_job_id civicrm_mailing_spool.job_id civicrm_mailing_job.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_mailing_unsubscribe_id civicrm_mailing.unsubscribe_id civicrm_mailing_component.id Null 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_membership_block_entity_id civicrm_membership_block.entity_id civicrm_contribution_page.id Restrict delete 
FK_civicrm_membership_block_membership_type_default civicrm_membership_block.membership_type_default civicrm_membership_type.id Restrict 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_membership_contribution_recur_id civicrm_membership.contribution_recur_id civicrm_contribution_recur.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_membership_log_modified_id civicrm_membership_log.modified_id civicrm_contact.id Null on delete 
FK_civicrm_membership_log_status_id civicrm_membership_log.status_id civicrm_membership_status.id Cascade on delete 
FK_civicrm_membership_membership_type_id civicrm_membership.membership_type_id civicrm_membership_type.id Cascade on delete 
FK_civicrm_membership_owner_membership_id civicrm_membership.owner_membership_id civicrm_membership.id Null 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_membership_status_id civicrm_membership.status_id civicrm_membership_status.id Cascade on delete 
FK_civicrm_membership_type_domain_id civicrm_membership_type.domain_id civicrm_domain.id Restrict delete 
FK_civicrm_membership_type_financial_type_id civicrm_membership_type.financial_type_id civicrm_financial_type.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_menu_component_id civicrm_menu.component_id civicrm_component.id Restrict delete 
FK_civicrm_menu_domain_id civicrm_menu.domain_id civicrm_domain.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_note_contact_id civicrm_note.contact_id civicrm_contact.id Null on delete 
FK_civicrm_openid_contact_id civicrm_openid.contact_id civicrm_contact.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_option_value_option_group_id civicrm_option_value.option_group_id civicrm_option_group.id Cascade on delete 
FK_civicrm_participant_campaign_id civicrm_participant.campaign_id civicrm_campaign.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_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_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_participant_registered_by_id civicrm_participant.registered_by_id civicrm_participant.id Null on delete 
FK_civicrm_participant_status_id civicrm_participant.status_id civicrm_participant_status_type.id Restrict delete 
FK_civicrm_participant_transferred_to_contact_id civicrm_participant.transferred_to_contact_id civicrm_contact.id Null 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_payment_token_contact_id civicrm_payment_token.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_payment_token_created_id civicrm_payment_token.created_id civicrm_contact.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_pcp_block_supporter_profile_id civicrm_pcp_block.supporter_profile_id civicrm_uf_group.id Null on delete 
FK_civicrm_pcp_contact_id civicrm_pcp.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_phone_contact_id civicrm_phone.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_pledge_campaign_id civicrm_pledge.campaign_id civicrm_campaign.id Null on delete 
FK_civicrm_pledge_contact_id civicrm_pledge.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_pledge_contribution_page_id civicrm_pledge.contribution_page_id civicrm_contribution_page.id Null on delete 
FK_civicrm_pledge_financial_type_id civicrm_pledge.financial_type_id civicrm_financial_type.id Restrict delete 
FK_civicrm_pledge_payment_contribution_id civicrm_pledge_payment.contribution_id civicrm_contribution.id Cascade on delete 
FK_civicrm_pledge_payment_pledge_id civicrm_pledge_payment.pledge_id civicrm_pledge.id Cascade on 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_premiums_product_product_id civicrm_premiums_product.product_id civicrm_product.id Restrict delete 
FK_civicrm_price_field_price_set_id civicrm_price_field.price_set_id civicrm_price_set.id Restrict 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_membership_type_id civicrm_price_field_value.membership_type_id civicrm_membership_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_price_set_domain_id civicrm_price_set.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_price_set_financial_type_id civicrm_price_set.financial_type_id civicrm_financial_type.id Null on delete 
FK_civicrm_print_label_created_id civicrm_print_label.created_id civicrm_contact.id Null on delete 
FK_civicrm_product_financial_type_id civicrm_product.financial_type_id civicrm_financial_type.id Null on delete 
FK_civicrm_relationship_case_id civicrm_relationship.case_id civicrm_case.id Cascade on delete 
FK_civicrm_relationship_contact_id_a civicrm_relationship.contact_id_a civicrm_contact.id Cascade on delete 
FK_civicrm_relationship_contact_id_b civicrm_relationship.contact_id_b civicrm_contact.id Cascade on delete 
FK_civicrm_relationship_relationship_type_id civicrm_relationship.relationship_type_id civicrm_relationship_type.id Cascade on delete 
FK_civicrm_report_instance_created_id civicrm_report_instance.created_id civicrm_contact.id Null on delete 
FK_civicrm_report_instance_domain_id civicrm_report_instance.domain_id civicrm_domain.id Restrict delete 
FK_civicrm_report_instance_drilldown_id civicrm_report_instance.drilldown_id civicrm_report_instance.id Null on delete 
FK_civicrm_report_instance_navigation_id civicrm_report_instance.navigation_id civicrm_navigation.id Null on delete 
FK_civicrm_report_instance_owner_id civicrm_report_instance.owner_id civicrm_contact.id Null on delete 
FK_civicrm_saved_search_mapping_id civicrm_saved_search.mapping_id civicrm_mapping.id Restrict delete 
FK_civicrm_setting_component_id civicrm_setting.component_id civicrm_component.id Restrict delete 
FK_civicrm_setting_contact_id civicrm_setting.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_setting_created_id civicrm_setting.created_id civicrm_contact.id Null on delete 
FK_civicrm_setting_domain_id civicrm_setting.domain_id civicrm_domain.id Cascade on delete 
FK_civicrm_state_province_country_id civicrm_state_province.country_id civicrm_country.id Restrict delete 
FK_civicrm_status_pref_domain_id civicrm_status_pref.domain_id civicrm_domain.id Restrict 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_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_survey_last_modified_id civicrm_survey.last_modified_id civicrm_contact.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_timezone_country_id civicrm_timezone.country_id civicrm_country.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_uf_group_add_to_group_id civicrm_uf_group.add_to_group_id civicrm_group.id Null on delete 
FK_civicrm_uf_group_created_id civicrm_uf_group.created_id civicrm_contact.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_uf_join_uf_group_id civicrm_uf_join.uf_group_id civicrm_uf_group.id Restrict delete 
FK_civicrm_uf_match_contact_id civicrm_uf_match.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_uf_match_domain_id civicrm_uf_match.domain_id civicrm_domain.id Restrict delete 
FK_civicrm_value_civivolunteer_4_entity_id civicrm_value_civivolunteer_4.entity_id civicrm_activity.id Cascade on delete 
FK_civicrm_value_constituent_information_1_entity_id civicrm_value_constituent_information_1.entity_id civicrm_contact.id Cascade on delete 
FK_civicrm_value_food_preference_2_entity_id civicrm_value_food_preference_2.entity_id civicrm_participant.id Cascade on delete 
FK_civicrm_value_volunteer_commenda_89009a1280120ff9 civicrm_value_volunteer_commendation_6.entity_id civicrm_activity.id Cascade on delete 
FK_civicrm_value_volunteer_information_5_entity_id civicrm_value_volunteer_information_5.entity_id civicrm_contact.id Cascade on delete 
FK_civicrm_volunteer_need_project_id civicrm_volunteer_need.project_id civicrm_volunteer_project.id Null on delete 
FK_civicrm_volunteer_project_campaign_id civicrm_volunteer_project.campaign_id civicrm_campaign.id Null on delete 
FK_civicrm_volunteer_project_contact_contact_id civicrm_volunteer_project_contact.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_volunteer_project_contact_project_id civicrm_volunteer_project_contact.project_id civicrm_volunteer_project.id Cascade on delete 
FK_civicrm_volunteer_project_loc_block_id civicrm_volunteer_project.loc_block_id civicrm_loc_block.id Null on delete 
FK_civicrm_website_contact_id civicrm_website.contact_id civicrm_contact.id Cascade on delete 
FK_civicrm_word_replacement_domain_id civicrm_word_replacement.domain_id civicrm_domain.id Restrict delete 
FK_cividiscount_item_organization_id cividiscount_item.organization_id civicrm_contact.id Null on delete 
FK_cividiscount_track_contact_id cividiscount_track.contact_id civicrm_contact.id Null on delete 
FK_cividiscount_track_contribution_id cividiscount_track.contribution_id civicrm_contribution.id Cascade on delete 
FK_cividiscount_track_item_id cividiscount_track.item_id cividiscount_item.id Null on delete 
fk_ra_action civirule_rule_action.action_id civirule_action.id Restrict delete 
fk_ra_rule civirule_rule_action.rule_id civirule_rule.id Restrict delete 
fk_rc_condition civirule_rule_condition.condition_id civirule_condition.id Restrict delete 
fk_rc_rule civirule_rule_condition.rule_id civirule_rule.id Restrict delete 
fk_rule_trigger civirule_rule.trigger_id civirule_trigger.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected