298 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| agency_contacts_agency_id_fkey |
|
|
Null on delete | ||
| opportunities_archive_reason_id_fkey |
|
|
Null on delete | ||
| opportunities_contact_id_fkey |
|
|
Null on delete | ||
| opportunities_owner_user_id_fkey |
|
|
Null on delete | ||
| opportunities_sourced_by_user_id_fkey |
|
|
Null on delete | ||
| opportunities_account_stage_id_fkey |
|
|
Null on delete | ||
| opportunities_requisition_id_fkey |
|
|
Null on delete | ||
| opportunities_posting_id_fkey |
|
|
Null on delete | ||
| opportunities_archived_by_user_id_fkey |
|
|
Null on delete | ||
| opportunities_origin_id_fkey |
|
|
Null on delete | ||
| external_message_participant_id_names_external_message_id_fkey |
|
|
Null on delete | ||
| external_message_participant__external_message_participant_fkey |
|
|
Null on delete | ||
| opportunity_education_start_date_id_fkey |
|
|
Null on delete | ||
| opportunity_education_end_date_id_fkey |
|
|
Null on delete | ||
| opportunity_education_opportunity_id_fkey |
|
|
Cascade on delete | ||
| email_participants_participant_type_fkey |
|
|
Null on delete | ||
| email_participants_email_id_fkey |
|
|
Null on delete | ||
| distribution_channels_posting_id_fkey |
|
|
Null on delete | ||
| posting_distribution_channels_distribution_channel_id_fkey |
|
|
Null on delete | ||
| posting_approvers_posting_id_fkey |
|
|
Cascade on delete | ||
| posting_approvers_approver_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_step_delays_nurture_campaign_step_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_step_delays_nurture_campaign_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_step_delays_delay_type_id_fkey |
|
|
Null on delete | ||
| external_message_participants_external_message_service_id_fkey |
|
|
Null on delete | ||
| external_message_participants_external_message_id_fkey |
|
|
Null on delete | ||
| external_message_participants_external_message_participant_fkey |
|
|
Null on delete | ||
| external_message_participants_external_message_entity_id_fkey |
|
|
Null on delete | ||
| api_credentials_tags_api_credential_id_fkey |
|
|
Null on delete | ||
| api_credentials_tags_tag_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_step_emails_nurture_campaign_step_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_step_emails_nurture_campaign_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_step_emails_email_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_step_emails_from_user_id_fkey |
|
|
Null on delete | ||
| account_survey_email_settings_email_template_id_fkey |
|
|
Null on delete | ||
| account_survey_email_settings_survey_trigger_id_fkey |
|
|
Null on delete | ||
| account_survey_email_settings_account_survey_id_fkey |
|
|
Null on delete | ||
| account_stages_stage_pipeline_id_fkey |
|
|
Null on delete | ||
| account_stages_stage_milestone_id_fkey |
|
|
Null on delete | ||
| users_user_role_id_fkey |
|
|
Null on delete | ||
| job_department_teams_department_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_step_snoozes_nurture_campaign_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_step_snoozes_nurture_campaign_step_id_fkey |
|
|
Null on delete | ||
| api_credentials_sources_api_credential_id_fkey |
|
|
Null on delete | ||
| api_credentials_sources_source_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_stage_pipeline_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_job_work_type_id_fkey |
|
|
Null on delete | ||
| opportunity_progress_events_previous_account_stage_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_job_department_team_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_opportunity_progress_event_i_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_opportunity_id_fkey |
|
|
Cascade on delete | ||
| opportunities_progress_events_actor_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_survey_response_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_event_date_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_archive_reason_id_fkey |
|
|
Null on delete | ||
| opportunity_progress_events_contact_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_agency_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_job_level_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_job_location_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_account_survey_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_posting_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_requisition_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_job_department_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_account_stage_id_fkey |
|
|
Null on delete | ||
| opportunities_progress_events_stage_milestone_id_fkey |
|
|
Null on delete | ||
| survey_response_answers_survey_response_id_fkey |
|
|
Null on delete | ||
| agency_sources_agency_id_fkey |
|
|
Null on delete | ||
| agency_sources_source_id_fkey |
|
|
Null on delete | ||
| contact_residing_country_contact_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_steps_nurture_campaign_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_steps_delay_type_fkey |
|
|
Null on delete | ||
| nurture_campaign_steps_action_type_fkey |
|
|
Null on delete | ||
| posting_tags_tag_id_fkey |
|
|
Null on delete | ||
| posting_tags_posting_id_fkey |
|
|
Cascade on delete | ||
| interview_panels_account_stage_id_fkey |
|
|
Cascade on delete | ||
| interview_panels_creator_id_fkey |
|
|
Null on delete | ||
| interview_panels_opportunity_id_fkey |
|
|
Cascade on delete | ||
| opportunities_feedback_events_interview_date_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_opportunity_form_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_posting_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_requisition_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_actor_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_interview_panel_interview_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_job_level_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_form_template_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_job_department_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_job_department_team_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_opportunity_form_field_score_fkey |
|
|
Cascade on delete | ||
| opportunities_feedback_events_job_location_id_fkey |
|
|
Null on delete | ||
| opportunity_feedback_events_contact_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_feedback_date_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_job_work_type_id_fkey |
|
|
Null on delete | ||
| opportunities_feedback_events_opportunity_id_fkey |
|
|
Cascade on delete | ||
| opportunities_feedback_events_account_stage_id_fkey |
|
|
Null on delete | ||
| interview_panel_interviewers_form_template_id_fkey |
|
|
Null on delete | ||
| interview_panels_interviews_interviewers_interview_id_fkey |
|
|
Null on delete | ||
| interview_panels_interviews_interviewer_interview_panel_id_fkey |
|
|
Null on delete | ||
| interview_panels_interviews_interviewers_user_id_fkey |
|
|
Null on delete | ||
| offer_approvers_offer_id_fkey |
|
|
Cascade on delete | ||
| offer_approvers_approver_id_fkey |
|
|
Null on delete | ||
| offer_revisions_approval_status_id_fkey |
|
|
Cascade on delete | ||
| offer_revisions_job_department_team_id_fkey |
|
|
Null on delete | ||
| offer_revisions_offer_id_fkey |
|
|
Null on delete | ||
| offer_revisions_job_level_id_fkey |
|
|
Null on delete | ||
| offer_revisions_job_location_id_fkey |
|
|
Null on delete | ||
| offer_revisions_job_work_type_id_fkey |
|
|
Null on delete | ||
| offer_revisions_offer_status_id_fkey |
|
|
Null on delete | ||
| offer_revisions_job_department_id_fkey |
|
|
Null on delete | ||
| offers_posting_id_fkey |
|
|
Null on delete | ||
| offers_requisition_id_fkey |
|
|
Null on delete | ||
| offers_offer_status_id_fkey |
|
|
Null on delete | ||
| offers_opportunity_id_fkey |
|
|
Cascade on delete | ||
| contact_name_contact_id_fkey |
|
|
Null on delete | ||
| form_templates_creator_id_fkey |
|
|
Null on delete | ||
| form_templates_form_type_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_events_account_stage_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_events_external_message_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_events_actor_id_fkey |
|
|
|||
| nurture_campaign_events_nurture_template_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_events_archive_reason_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_events_email_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_events_opportunity_id_fkey |
|
|
Cascade on delete | ||
| nurture_campaign_events_event_date_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_events_contact_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_events_posting_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_events_requisition_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_events_nurture_campaign_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_events_nurture_campaign_event_id_fkey |
|
|
Null on delete | ||
| external_messages_opportunity_id_fkey |
|
|
Cascade on delete | ||
| external_messages_external_message_service_id_fkey |
|
|
Null on delete | ||
| opportunity_form_field_values_contact_id_fkey |
|
|
Null on delete | ||
| opportunity_form_field_values_opportunity_form_field_id_fkey |
|
|
Cascade on delete | ||
| opportunity_form_field_values_form_id_fkey |
|
|
Null on delete | ||
| requisition_approvers_requisition_id_fkey |
|
|
Cascade on delete | ||
| requisition_approvers_approver_id_fkey |
|
|
Null on delete | ||
| opportunity_form_field_scores_form_id_fkey |
|
|
Null on delete | ||
| opportunity_form_field_scores_contact_id_fkey |
|
|
Null on delete | ||
| opportunity_form_field_scores_opportunity_id_fkey |
|
|
Cascade on delete | ||
| opportunity_form_field_scores_opportunity_form_field_id_fkey |
|
|
Cascade on delete | ||
| offer_events_offer_revision_id_fkey |
|
|
Cascade on delete | ||
| offer_events_archive_reason_id_fkey |
|
|
Null on delete | ||
| offer_events_offer_event_id_fkey |
|
|
Null on delete | ||
| offer_events_contact_id_fkey |
|
|
Null on delete | ||
| offer_events_offer_status_id_fkey |
|
|
Null on delete | ||
| offer_events_job_work_type_id_fkey |
|
|
Null on delete | ||
| offer_events_job_location_id_fkey |
|
|
Null on delete | ||
| offer_events_job_department_id_fkey |
|
|
Null on delete | ||
| offer_events_requisition_id_fkey |
|
|
Null on delete | ||
| offer_events_job_level_id_fkey |
|
|
Null on delete | ||
| offer_events_offer_id_fkey |
|
|
Null on delete | ||
| offer_events_event_date_id_fkey |
|
|
Null on delete | ||
| offer_events_opportunity_id_fkey |
|
|
Cascade on delete | ||
| offer_events_actor_id_fkey |
|
|
Null on delete | ||
| offer_events_hiring_manager_user_id_fkey |
|
|
Null on delete | ||
| offer_events_job_department_team_id_fkey |
|
|
Null on delete | ||
| offer_events_posting_id_fkey |
|
|
Null on delete | ||
| posting_lists_posting_id_fkey |
|
|
Cascade on delete | ||
| requisition_fields_requisition_id_fkey |
|
|
Cascade on delete | ||
| requisition_fields_form_field_type_id_fkey |
|
|
Null on delete | ||
| nurture_campaigns_status_fkey |
|
|
Null on delete | ||
| nurture_campaigns_nurture_template_id_fkey |
|
|
Null on delete | ||
| nurture_campaigns_opportunity_id_fkey |
|
|
Cascade on delete | ||
| posting_events_actor_id_fkey |
|
|
Null on delete | ||
| posting_events_previous_posting_status_id_fkey |
|
|
Null on delete | ||
| posting_events_job_location_id_fkey |
|
|
Null on delete | ||
| posting_events_job_department_team_id_fkey |
|
|
Null on delete | ||
| posting_events_event_date_id_fkey |
|
|
Null on delete | ||
| posting_events_posting_location_type_id_fkey |
|
|
Null on delete | ||
| posting_events_distribution_channel_id_fkey |
|
|
Null on delete | ||
| posting_events_posting_event_id_fkey |
|
|
Null on delete | ||
| posting_events_job_level_id_fkey |
|
|
Null on delete | ||
| posting_events_job_work_type_id_fkey |
|
|
Null on delete | ||
| posting_events_posting_id_fkey |
|
|
Null on delete | ||
| posting_events_job_department_id_fkey |
|
|
Null on delete | ||
| posting_events_posting_status_id_fkey |
|
|
Null on delete | ||
| account_survey_triggers_account_stage_id_fkey |
|
|
Null on delete | ||
| account_survey_triggers_account_survey_id_fkey |
|
|
Null on delete | ||
| account_survey_triggers_archive_reason_id_fkey |
|
|
Null on delete | ||
| emails_events_account_stage_id_fkey |
|
|
Null on delete | ||
| emails_events_posting_id_fkey |
|
|
Null on delete | ||
| emails_events_requisition_id_fkey |
|
|
Null on delete | ||
| emails_events_event_date_id_fkey |
|
|
Null on delete | ||
| emails_events_opportunity_id_fkey |
|
|
Cascade on delete | ||
| emails_events_email_event_id_fkey |
|
|
Null on delete | ||
| emails_events_contact_id_fkey |
|
|
Null on delete | ||
| emails_events_email_id_fkey |
|
|
Null on delete | ||
| account_surveys_type_enum_fkey |
|
|
Null on delete | ||
| account_surveys_form_template_id_fkey |
|
|
Null on delete | ||
| contact_organization_summary_contact_id_fkey |
|
|
Null on delete | ||
| data_requests_contact_id_fkey |
|
|
Null on delete | ||
| posting_locations_posting_id_fkey |
|
|
Restrict delete | ||
| posting_locations_job_location_id_fkey |
|
|
Restrict delete | ||
| form_template_fields_form_field_type_id_fkey |
|
|
Null on delete | ||
| form_template_fields_form_template_id_fkey |
|
|
Null on delete | ||
| survey_responses_account_survey_id_fkey |
|
|
Null on delete | ||
| survey_responses_opportunity_id_fkey |
|
|
Cascade on delete | ||
| contacts_consent_events_contact_consent_event_id_fkey |
|
|
Null on delete | ||
| contacts_consent_events_event_date_id_fkey |
|
|
Null on delete | ||
| contacts_consent_events_user_id_fkey |
|
|
Null on delete | ||
| contacts_consent_events_contact_id_fkey |
|
|
Null on delete | ||
| requisition_events_posting_id_fkey |
|
|
Null on delete | ||
| requisition_events_requisition_status_id_fkey |
|
|
Null on delete | ||
| requisition_events_previous_requisition_status_id_fkey |
|
|
Null on delete | ||
| requisition_events_job_department_id_fkey |
|
|
Null on delete | ||
| requisition_events_job_location_id_fkey |
|
|
Null on delete | ||
| requisition_events_requisition_event_id_fkey |
|
|
Null on delete | ||
| requisition_events_job_department_team_id_fkey |
|
|
Null on delete | ||
| requisition_events_requisition_id_fkey |
|
|
Null on delete | ||
| requisition_events_hiring_manager_user_id_fkey |
|
|
Null on delete | ||
| requisition_events_owner_user_id_fkey |
|
|
Null on delete | ||
| requisition_events_creator_user_id_fkey |
|
|
Null on delete | ||
| requisition_events_event_date_id_fkey |
|
|
Null on delete | ||
| requisition_events_actor_id_fkey |
|
|
Null on delete | ||
| interview_panel_interviews_interview_panel_id_fkey |
|
|
Null on delete | ||
| interview_panel_interviews_form_template_id_fkey |
|
|
Null on delete | ||
| opportunity_forms_contact_id_fkey |
|
|
Null on delete | ||
| opportunity_forms_interview_panel_id_fkey |
|
|
Null on delete | ||
| opportunity_forms_form_template_id_fkey |
|
|
Null on delete | ||
| opportunity_forms_account_stage_id_fkey |
|
|
Null on delete | ||
| opportunity_forms_user_id_fkey |
|
|
Null on delete | ||
| opportunity_forms_interview_panel_interview_id_fkey |
|
|
Null on delete | ||
| opportunity_forms_opportunity_id_fkey |
|
|
Cascade on delete | ||
| nurture_campaign_email_addresses_nurture_campaign_id_fkey |
|
|
Null on delete | ||
| opportunity_tags_opportunity_id_fkey |
|
|
Cascade on delete | ||
| opportunity_tags_tag_id_fkey |
|
|
Null on delete | ||
| external_message_participant_contacts_external_message_id_fkey |
|
|
Null on delete | ||
| external_message_participant_external_message_participant_fkey1 |
|
|
Null on delete | ||
| external_message_participant_contacts_contact_id_fkey |
|
|
Null on delete | ||
| agency_jobs_agency_id_fkey |
|
|
Null on delete | ||
| agency_jobs_posting_id_fkey |
|
|
Null on delete | ||
| opportunity_eeo_opportunity_id_fkey |
|
|
Cascade on delete | ||
| opportunity_eeo_eeo_response_id_fkey |
|
|
Cascade on delete | ||
| contact_web_links_contact_id_fkey |
|
|
Null on delete | ||
| form_template_field_options_form_template_id_fkey |
|
|
Null on delete | ||
| form_template_field_options_field_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_opportunity_id_fkey |
|
|
Cascade on delete | ||
| opportunities_form_events_job_department_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_contact_id_fkey |
|
|
Null on delete | ||
| opportunity_form_events_opportunity_form_event_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_job_department_team_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_posting_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_form_template_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_account_stage_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_job_location_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_job_level_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_opportunity_form_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_actor_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_event_date_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_job_work_type_id_fkey |
|
|
Null on delete | ||
| opportunities_form_events_requisition_id_fkey |
|
|
Null on delete | ||
| postings_job_department_team_id_fkey |
|
|
Null on delete | ||
| postings_job_work_type_id_fkey |
|
|
Null on delete | ||
| postings_hiring_manager_user_id_fkey |
|
|
Null on delete | ||
| postings_owner_user_id_fkey |
|
|
Null on delete | ||
| postings_job_location_id_fkey |
|
|
Null on delete | ||
| postings_posting_status_id_fkey |
|
|
Restrict delete | ||
| postings_job_department_id_fkey |
|
|
Null on delete | ||
| postings_job_level_id_fkey |
|
|
Null on delete | ||
| postings_posting_location_type_id_fkey |
|
|
Null on delete | ||
| contact_phones_contact_id_fkey |
|
|
Null on delete | ||
| contact_location_contact_id_fkey |
|
|
Null on delete | ||
| api_credentials_creator_id_fkey |
|
|
Null on delete | ||
| requisition_postings_posting_id_fkey |
|
|
Cascade on delete | ||
| requisition_postings_requisition_id_fkey |
|
|
Cascade on delete | ||
| contact_emails_contact_id_fkey |
|
|
Null on delete | ||
| opportunity_form_fields_form_field_type_id_fkey |
|
|
Null on delete | ||
| opportunity_form_fields_form_template_field_id_fkey |
|
|
|||
| opportunity_form_fields_opportunity_form_id_fkey |
|
|
Null on delete | ||
| opportunity_form_fields_contact_id_fkey |
|
|
Null on delete | ||
| offer_revision_fields_offer_id_fkey |
|
|
Null on delete | ||
| offer_revision_fields_offer_revision_id_fkey |
|
|
Null on delete | ||
| opportunity_sources_source_id_fkey |
|
|
Null on delete | ||
| opportunity_sources_opportunity_id_fkey |
|
|
Cascade on delete | ||
| opportunity_sources_opportunity_source_type_id_fkey |
|
|
Null on delete | ||
| opportunity_referrals_posting_id_fkey |
|
|
Null on delete | ||
| opportunity_referrals_opportunity_id_fkey |
|
|
Cascade on delete | ||
| opportunity_referrals_opportunity_form_id_fkey |
|
|
Cascade on delete | ||
| opportunity_referrals_contact_id_fkey |
|
|
Null on delete | ||
| opportunity_referrals_user_id_fkey |
|
|
Null on delete | ||
| eeo_responses_eeo_source_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_step_archives_nurture_campaign_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_step_archives_archive_reason_id_fkey |
|
|
Null on delete | ||
| nurture_campaign_step_archives_nurture_campaign_step_id_fkey |
|
|
Null on delete | ||
| survey_response_tracking_survey_response_id_fkey |
|
|
Null on delete | ||
| posting_followers_posting_id_fkey |
|
|
Cascade on delete | ||
| posting_followers_user_id_fkey |
|
|
Cascade on delete | ||
| requisitions_job_department_team_id_fkey |
|
|
Null on delete | ||
| requisitions_requisition_status_id_fkey |
|
|
Restrict delete | ||
| requisitions_owner_user_id_fkey |
|
|
Null on delete | ||
| requisitions_job_department_id_fkey |
|
|
Null on delete | ||
| requisitions_creator_user_id_fkey |
|
|
Null on delete | ||
| requisitions_job_location_id_fkey |
|
|
Null on delete | ||
| requisitions_hiring_manager_user_id_fkey |
|
|
Null on delete | ||
| nurture_templates_owner_user_id_fkey |
|
|
Null on delete | ||
| opportunity_form_field_files_opportunity_form_field_id_fkey |
|
|
Cascade on delete | ||
| opportunity_form_field_files_form_id_fkey |
|
|
Null on delete | ||
| opportunity_form_field_files_contact_id_fkey |
|
|
Null on delete | ||
| opportunity_form_field_files_opportunity_id_fkey |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|