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