Constraints

286 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
agency_contacts_agency_id_fkey
agency_contacts.agency_id
agencies.agency_id
Null on delete
opportunities_archive_reason_id_fkey
opportunities.archive_reason_id
archive_reasons.archive_reason_id
Null on delete
opportunities_contact_id_fkey
opportunities.contact_id
contacts.contact_id
Null on delete
opportunities_owner_user_id_fkey
opportunities.owner_user_id
users.user_id
Null on delete
opportunities_sourced_by_user_id_fkey
opportunities.sourced_by_user_id
users.user_id
Null on delete
opportunities_account_stage_id_fkey
opportunities.account_stage_id
account_stages.account_stage_id
Null on delete
opportunities_requisition_id_fkey
opportunities.requisition_id
requisitions.requisition_id
Null on delete
opportunities_posting_id_fkey
opportunities.posting_id
postings.posting_id
Null on delete
opportunities_archived_by_user_id_fkey
opportunities.archived_by_user_id
users.user_id
Null on delete
opportunities_origin_id_fkey
opportunities.origin_id
origin_enum.origin_id
Null on delete
external_message_participant_id_names_external_message_id_fkey
external_message_participant_id_names.external_message_id
external_messages.external_message_id
Null on delete
external_message_participant__external_message_participant_fkey
external_message_participant_id_names.external_message_participant_id
external_message_participants.external_message_participant_id
Null on delete
opportunity_education_start_date_id_fkey
opportunity_education.start_date_id
dates.date_id
Null on delete
opportunity_education_end_date_id_fkey
opportunity_education.end_date_id
dates.date_id
Null on delete
opportunity_education_opportunity_id_fkey
opportunity_education.opportunity_id
opportunities.opportunity_id
Cascade on delete
email_participants_participant_type_fkey
email_participants.participant_type
email_participant_enum.email_participant_enum_id
Null on delete
email_participants_email_id_fkey
email_participants.email_id
emails.email_id
Null on delete
distribution_channels_posting_id_fkey
posting_distribution_channels.posting_id
postings.posting_id
Null on delete
posting_distribution_channels_distribution_channel_id_fkey
posting_distribution_channels.distribution_channel_id
distribution_channel_enum.distribution_channel_id
Null on delete
posting_approvers_posting_id_fkey
posting_approvers.posting_id
postings.posting_id
Cascade on delete
posting_approvers_approver_id_fkey
posting_approvers.approver_id
users.user_id
Null on delete
nurture_campaign_step_delays_nurture_campaign_step_id_fkey
nurture_campaign_step_delays.nurture_campaign_step_id
nurture_campaign_steps.nurture_campaign_step_id
Null on delete
nurture_campaign_step_delays_nurture_campaign_id_fkey
nurture_campaign_step_delays.nurture_campaign_id
nurture_campaigns.nurture_campaign_id
Null on delete
nurture_campaign_step_delays_delay_type_id_fkey
nurture_campaign_step_delays.delay_type_id
nurture_campaign_delay_enum.nurture_campaign_delay_id
Null on delete
external_message_participants_external_message_service_id_fkey
external_message_participants.external_message_service_id
external_message_service_enum.external_message_service_id
Null on delete
external_message_participants_external_message_id_fkey
external_message_participants.external_message_id
external_messages.external_message_id
Null on delete
external_message_participants_external_message_participant_fkey
external_message_participants.external_message_participant_enum_id
external_message_participant_enum.external_message_participant_id
Null on delete
external_message_participants_external_message_entity_id_fkey
external_message_participants.external_message_entity_id
external_message_entity_enum.external_message_entity_id
Null on delete
api_credentials_tags_api_credential_id_fkey
api_credential_tags.api_credential_id
api_credentials.api_credential_id
Null on delete
api_credentials_tags_tag_id_fkey
api_credential_tags.tag_id
tags.tag_id
Null on delete
nurture_campaign_step_emails_nurture_campaign_step_id_fkey
nurture_campaign_step_emails.nurture_campaign_step_id
nurture_campaign_steps.nurture_campaign_step_id
Null on delete
nurture_campaign_step_emails_nurture_campaign_id_fkey
nurture_campaign_step_emails.nurture_campaign_id
nurture_campaigns.nurture_campaign_id
Null on delete
nurture_campaign_step_emails_email_id_fkey
nurture_campaign_step_emails.email_id
emails.email_id
Null on delete
nurture_campaign_step_emails_from_user_id_fkey
nurture_campaign_step_emails.from_user_id
users.user_id
Null on delete
account_survey_email_settings_email_template_id_fkey
account_survey_email_settings.email_template_id
email_templates.email_template_id
Null on delete
account_survey_email_settings_survey_trigger_id_fkey
account_survey_email_settings.survey_trigger_id
account_survey_triggers.account_survey_trigger_id
Null on delete
account_survey_email_settings_account_survey_id_fkey
account_survey_email_settings.account_survey_id
account_surveys.account_survey_id
Null on delete
account_stages_stage_pipeline_id_fkey
account_stages.stage_pipeline_id
stage_pipeline_enum.stage_pipeline_id
Null on delete
account_stages_stage_milestone_id_fkey
account_stages.stage_milestone_id
stage_milestone_enum.stage_milestone_id
Null on delete
job_department_teams_department_id_fkey
job_department_teams.job_department_id
job_departments.job_department_id
Null on delete
nurture_campaign_step_snoozes_nurture_campaign_id_fkey
nurture_campaign_step_snoozes.nurture_campaign_id
nurture_campaigns.nurture_campaign_id
Null on delete
nurture_campaign_step_snoozes_nurture_campaign_step_id_fkey
nurture_campaign_step_snoozes.nurture_campaign_step_id
nurture_campaign_steps.nurture_campaign_step_id
Null on delete
api_credentials_sources_api_credential_id_fkey
api_credential_sources.api_credential_id
api_credentials.api_credential_id
Null on delete
api_credentials_sources_source_id_fkey
api_credential_sources.source_id
sources.source_id
Null on delete
opportunities_progress_events_stage_pipeline_id_fkey
opportunity_progress_events.stage_pipeline_id
stage_pipeline_enum.stage_pipeline_id
Null on delete
opportunities_progress_events_job_work_type_id_fkey
opportunity_progress_events.job_work_type_id
job_work_types.job_work_type_id
Null on delete
opportunity_progress_events_previous_account_stage_id_fkey
opportunity_progress_events.previous_account_stage_id
account_stages.account_stage_id
Null on delete
opportunities_progress_events_job_department_team_id_fkey
opportunity_progress_events.job_department_team_id
job_department_teams.job_department_team_id
Null on delete
opportunities_progress_events_opportunity_progress_event_i_fkey
opportunity_progress_events.opportunity_progress_event_id
opportunity_progress_event_enum.opportunity_progress_event_id
Null on delete
opportunities_progress_events_opportunity_id_fkey
opportunity_progress_events.opportunity_id
opportunities.opportunity_id
Cascade on delete
opportunities_progress_events_actor_id_fkey
opportunity_progress_events.actor_id
users.user_id
Null on delete
opportunities_progress_events_survey_response_id_fkey
opportunity_progress_events.survey_response_id
survey_responses.survey_response_id
Null on delete
opportunities_progress_events_event_date_id_fkey
opportunity_progress_events.event_date_id
dates.date_id
Null on delete
opportunities_progress_events_archive_reason_id_fkey
opportunity_progress_events.archive_reason_id
archive_reasons.archive_reason_id
Null on delete
opportunity_progress_events_contact_id_fkey
opportunity_progress_events.contact_id
contacts.contact_id
Null on delete
opportunities_progress_events_agency_id_fkey
opportunity_progress_events.agency_id
agencies.agency_id
Null on delete
opportunities_progress_events_job_level_id_fkey
opportunity_progress_events.job_level_id
job_levels.job_level_id
Null on delete
opportunities_progress_events_job_location_id_fkey
opportunity_progress_events.job_location_id
job_locations.job_location_id
Null on delete
opportunities_progress_events_account_survey_id_fkey
opportunity_progress_events.account_survey_id
account_surveys.account_survey_id
Null on delete
opportunities_progress_events_posting_id_fkey
opportunity_progress_events.posting_id
postings.posting_id
Null on delete
opportunities_progress_events_requisition_id_fkey
opportunity_progress_events.requisition_id
requisitions.requisition_id
Null on delete
opportunities_progress_events_job_department_id_fkey
opportunity_progress_events.job_department_id
job_departments.job_department_id
Null on delete
opportunities_progress_events_account_stage_id_fkey
opportunity_progress_events.account_stage_id
account_stages.account_stage_id
Null on delete
opportunities_progress_events_stage_milestone_id_fkey
opportunity_progress_events.stage_milestone_id
stage_milestone_enum.stage_milestone_id
Null on delete
survey_response_answers_survey_response_id_fkey
survey_response_answers.survey_response_id
survey_responses.survey_response_id
Null on delete
agency_sources_agency_id_fkey
agency_sources.agency_id
agencies.agency_id
Null on delete
agency_sources_source_id_fkey
agency_sources.source_id
sources.source_id
Null on delete
contact_residing_country_contact_id_fkey
contact_residing_country.contact_id
contacts.contact_id
Null on delete
nurture_campaign_steps_nurture_campaign_id_fkey
nurture_campaign_steps.nurture_campaign_id
nurture_campaigns.nurture_campaign_id
Null on delete
nurture_campaign_steps_delay_type_fkey
nurture_campaign_steps.delay_type
nurture_campaign_delay_enum.nurture_campaign_delay_id
Null on delete
nurture_campaign_steps_action_type_fkey
nurture_campaign_steps.action_type
nurture_campaign_action_enum.nurture_campaign_action_id
Null on delete
posting_tags_tag_id_fkey
posting_tags.tag_id
tags.tag_id
Null on delete
posting_tags_posting_id_fkey
posting_tags.posting_id
postings.posting_id
Cascade on delete
interview_panels_account_stage_id_fkey
interview_panels.account_stage_id
account_stages.account_stage_id
Cascade on delete
interview_panels_creator_id_fkey
interview_panels.creator_id
users.user_id
Null on delete
interview_panels_opportunity_id_fkey
interview_panels.opportunity_id
opportunities.opportunity_id
Cascade on delete
opportunities_feedback_events_interview_date_id_fkey
opportunity_feedback_events.interview_date_id
dates.date_id
Null on delete
opportunities_feedback_events_opportunity_form_id_fkey
opportunity_feedback_events.opportunity_form_id
opportunity_forms.opportunity_form_id
Null on delete
opportunities_feedback_events_posting_id_fkey
opportunity_feedback_events.posting_id
postings.posting_id
Null on delete
opportunities_feedback_events_requisition_id_fkey
opportunity_feedback_events.requisition_id
requisitions.requisition_id
Null on delete
opportunities_feedback_events_actor_id_fkey
opportunity_feedback_events.actor_id
users.user_id
Null on delete
opportunities_feedback_events_interview_panel_interview_id_fkey
opportunity_feedback_events.interview_panel_interview_id
interview_panel_interviews.interview_panel_interview_id
Null on delete
opportunities_feedback_events_job_level_id_fkey
opportunity_feedback_events.job_level_id
job_levels.job_level_id
Null on delete
opportunities_feedback_events_form_template_id_fkey
opportunity_feedback_events.form_template_id
form_templates.form_template_id
Null on delete
opportunities_feedback_events_job_department_id_fkey
opportunity_feedback_events.job_department_id
job_departments.job_department_id
Null on delete
opportunities_feedback_events_job_department_team_id_fkey
opportunity_feedback_events.job_department_team_id
job_department_teams.job_department_team_id
Null on delete
opportunities_feedback_events_opportunity_form_field_score_fkey
opportunity_feedback_events.opportunity_form_field_score_id
opportunity_form_field_scores.opportunity_form_field_score_id
Cascade on delete
opportunities_feedback_events_job_location_id_fkey
opportunity_feedback_events.job_location_id
job_locations.job_location_id
Null on delete
opportunity_feedback_events_contact_id_fkey
opportunity_feedback_events.contact_id
contacts.contact_id
Null on delete
opportunities_feedback_events_feedback_date_id_fkey
opportunity_feedback_events.feedback_date_id
dates.date_id
Null on delete
opportunities_feedback_events_job_work_type_id_fkey
opportunity_feedback_events.job_work_type_id
job_work_types.job_work_type_id
Null on delete
opportunities_feedback_events_opportunity_id_fkey
opportunity_feedback_events.opportunity_id
opportunities.opportunity_id
Cascade on delete
opportunities_feedback_events_account_stage_id_fkey
opportunity_feedback_events.account_stage_id
account_stages.account_stage_id
Null on delete
interview_panels_interviews_interviewers_interview_id_fkey
interview_panel_interviewers.interview_panel_interview_id
interview_panel_interviews.interview_panel_interview_id
Null on delete
interview_panels_interviews_interviewer_interview_panel_id_fkey
interview_panel_interviewers.interview_panel_id
interview_panels.interview_panel_id
Null on delete
interview_panels_interviews_interviewers_user_id_fkey
interview_panel_interviewers.user_id
users.user_id
Null on delete
offer_approvers_offer_id_fkey
offer_approvers.offer_id
offers.offer_id
Cascade on delete
offer_approvers_approver_id_fkey
offer_approvers.approver_id
users.user_id
Null on delete
offer_revisions_job_department_team_id_fkey
offer_revisions.job_department_team_id
job_department_teams.job_department_team_id
Null on delete
offer_revisions_offer_id_fkey
offer_revisions.offer_id
offers.offer_id
Null on delete
offer_revisions_job_level_id_fkey
offer_revisions.job_level_id
job_levels.job_level_id
Null on delete
offer_revisions_job_location_id_fkey
offer_revisions.job_location_id
job_locations.job_location_id
Null on delete
offer_revisions_job_work_type_id_fkey
offer_revisions.job_work_type_id
job_work_types.job_work_type_id
Null on delete
offer_revisions_offer_status_id_fkey
offer_revisions.offer_status_id
offer_status_enum.offer_status_id
Null on delete
offer_revisions_job_department_id_fkey
offer_revisions.job_department_id
job_departments.job_department_id
Null on delete
offers_posting_id_fkey
offers.posting_id
postings.posting_id
Null on delete
offers_requisition_id_fkey
offers.requisition_id
requisitions.requisition_id
Null on delete
offers_opportunity_id_fkey
offers.opportunity_id
opportunities.opportunity_id
Cascade on delete
contact_name_contact_id_fkey
contact_name.contact_id
contacts.contact_id
Null on delete
form_templates_creator_id_fkey
form_templates.creator_id
users.user_id
Null on delete
form_templates_form_type_id_fkey
form_templates.form_type_id
form_type_enum.form_type_id
Null on delete
nurture_campaign_events_account_stage_id_fkey
nurture_campaign_events.account_stage_id
account_stages.account_stage_id
Null on delete
nurture_campaign_events_external_message_id_fkey
nurture_campaign_events.external_message_id
external_messages.external_message_id
Null on delete
nurture_campaign_events_actor_id_fkey
nurture_campaign_events.actor_id
users.user_id
nurture_campaign_events_nurture_template_id_fkey
nurture_campaign_events.nurture_template_id
nurture_templates.nurture_template_id
Null on delete
nurture_campaign_events_archive_reason_id_fkey
nurture_campaign_events.archive_reason_id
archive_reasons.archive_reason_id
Null on delete
nurture_campaign_events_email_id_fkey
nurture_campaign_events.email_id
emails.email_id
Null on delete
nurture_campaign_events_opportunity_id_fkey
nurture_campaign_events.opportunity_id
opportunities.opportunity_id
Cascade on delete
nurture_campaign_events_event_date_id_fkey
nurture_campaign_events.event_date_id
dates.date_id
Null on delete
nurture_campaign_events_contact_id_fkey
nurture_campaign_events.contact_id
contacts.contact_id
Null on delete
nurture_campaign_events_posting_id_fkey
nurture_campaign_events.posting_id
postings.posting_id
Null on delete
nurture_campaign_events_requisition_id_fkey
nurture_campaign_events.requisition_id
requisitions.requisition_id
Null on delete
nurture_campaign_events_nurture_campaign_id_fkey
nurture_campaign_events.nurture_campaign_id
nurture_campaigns.nurture_campaign_id
Null on delete
nurture_campaign_events_nurture_campaign_event_id_fkey
nurture_campaign_events.nurture_campaign_event_id
nurture_campaign_event_enum.nurture_campaign_event_id
Null on delete
external_messages_opportunity_id_fkey
external_messages.opportunity_id
opportunities.opportunity_id
Cascade on delete
external_messages_external_message_service_id_fkey
external_messages.external_message_service_id
external_message_service_enum.external_message_service_id
Null on delete
opportunity_form_field_values_contact_id_fkey
opportunity_form_field_values.contact_id
contacts.contact_id
Null on delete
opportunity_form_field_values_opportunity_form_field_id_fkey
opportunity_form_field_values.opportunity_form_field_id
opportunity_form_fields.opportunity_form_field_id
Cascade on delete
opportunity_form_field_values_form_id_fkey
opportunity_form_field_values.opportunity_form_id
opportunity_forms.opportunity_form_id
Null on delete
requisition_approvers_requisition_id_fkey
requisition_approvers.requisition_id
requisitions.requisition_id
Cascade on delete
requisition_approvers_approver_id_fkey
requisition_approvers.approver_id
users.user_id
Null on delete
opportunity_form_field_scores_form_id_fkey
opportunity_form_field_scores.opportunity_form_id
opportunity_forms.opportunity_form_id
Null on delete
opportunity_form_field_scores_contact_id_fkey
opportunity_form_field_scores.contact_id
contacts.contact_id
Null on delete
opportunity_form_field_scores_opportunity_id_fkey
opportunity_form_field_scores.opportunity_id
opportunities.opportunity_id
Cascade on delete
opportunity_form_field_scores_opportunity_form_field_id_fkey
opportunity_form_field_scores.opportunity_form_field_id
opportunity_form_fields.opportunity_form_field_id
Cascade on delete
offer_events_offer_revision_id_fkey
offer_events.offer_revision_id
offer_revisions.offer_revision_id
Cascade on delete
offer_events_archive_reason_id_fkey
offer_events.archive_reason_id
archive_reasons.archive_reason_id
Null on delete
offer_events_offer_event_id_fkey
offer_events.offer_event_id
offer_event_enum.offer_event_id
Null on delete
offer_events_contact_id_fkey
offer_events.contact_id
contacts.contact_id
Null on delete
offer_events_offer_status_id_fkey
offer_events.offer_status_id
offer_status_enum.offer_status_id
Null on delete
offer_events_job_work_type_id_fkey
offer_events.job_work_type_id
job_work_types.job_work_type_id
Null on delete
offer_events_job_location_id_fkey
offer_events.job_location_id
job_locations.job_location_id
Null on delete
offer_events_job_department_id_fkey
offer_events.job_department_id
job_departments.job_department_id
Null on delete
offer_events_requisition_id_fkey
offer_events.requisition_id
requisitions.requisition_id
Null on delete
offer_events_job_level_id_fkey
offer_events.job_level_id
job_levels.job_level_id
Null on delete
offer_events_offer_id_fkey
offer_events.offer_id
offers.offer_id
Null on delete
offer_events_event_date_id_fkey
offer_events.event_date_id
dates.date_id
Null on delete
offer_events_opportunity_id_fkey
offer_events.opportunity_id
opportunities.opportunity_id
Cascade on delete
offer_events_actor_id_fkey
offer_events.actor_id
users.user_id
Null on delete
offer_events_hiring_manager_user_id_fkey
offer_events.hiring_manager_user_id
users.user_id
Null on delete
offer_events_job_department_team_id_fkey
offer_events.job_department_team_id
job_department_teams.job_department_team_id
Null on delete
offer_events_posting_id_fkey
offer_events.posting_id
postings.posting_id
Null on delete
posting_lists_posting_id_fkey
posting_lists.posting_id
postings.posting_id
Cascade on delete
requisition_fields_requisition_id_fkey
requisition_fields.requisition_id
requisitions.requisition_id
Cascade on delete
requisition_fields_form_field_type_id_fkey
requisition_fields.form_field_type_id
form_field_type_enum.form_field_type_id
Null on delete
nurture_campaigns_status_fkey
nurture_campaigns.status
nurture_campaign_status_enum.nurture_campaign_status_id
Null on delete
nurture_campaigns_nurture_template_id_fkey
nurture_campaigns.nurture_template_id
nurture_templates.nurture_template_id
Null on delete
nurture_campaigns_opportunity_id_fkey
nurture_campaigns.opportunity_id
opportunities.opportunity_id
Cascade on delete
posting_events_actor_id_fkey
posting_events.actor_id
users.user_id
Null on delete
posting_events_posting_event_id_fkey
posting_events.posting_event_id
posting_event_enum.posting_event_id
Null on delete
posting_events_previous_posting_status_id_fkey
posting_events.previous_posting_status_id
posting_status_enum.posting_status_id
Null on delete
posting_events_job_location_id_fkey
posting_events.job_location_id
job_locations.job_location_id
Null on delete
posting_events_job_level_id_fkey
posting_events.job_level_id
job_levels.job_level_id
Null on delete
posting_events_job_department_team_id_fkey
posting_events.job_department_team_id
job_department_teams.job_department_team_id
Null on delete
posting_events_job_work_type_id_fkey
posting_events.job_work_type_id
job_work_types.job_work_type_id
Null on delete
posting_events_posting_id_fkey
posting_events.posting_id
postings.posting_id
Null on delete
posting_events_event_date_id_fkey
posting_events.event_date_id
dates.date_id
Null on delete
posting_events_distribution_channel_id_fkey
posting_events.distribution_channel_id
distribution_channel_enum.distribution_channel_id
Null on delete
posting_events_job_department_id_fkey
posting_events.job_department_id
job_departments.job_department_id
Null on delete
posting_events_posting_status_id_fkey
posting_events.posting_status_id
posting_status_enum.posting_status_id
Null on delete
account_survey_triggers_account_stage_id_fkey
account_survey_triggers.account_stage_id
account_stages.account_stage_id
Null on delete
account_survey_triggers_account_survey_id_fkey
account_survey_triggers.account_survey_id
account_surveys.account_survey_id
Null on delete
account_survey_triggers_archive_reason_id_fkey
account_survey_triggers.archive_reason_id
archive_reasons.archive_reason_id
Null on delete
emails_events_account_stage_id_fkey
email_events.account_stage_id
account_stages.account_stage_id
Null on delete
emails_events_posting_id_fkey
email_events.posting_id
postings.posting_id
Null on delete
emails_events_requisition_id_fkey
email_events.requisition_id
requisitions.requisition_id
Null on delete
emails_events_event_date_id_fkey
email_events.event_date_id
dates.date_id
Null on delete
emails_events_opportunity_id_fkey
email_events.opportunity_id
opportunities.opportunity_id
Cascade on delete
emails_events_email_event_id_fkey
email_events.email_event_id
email_event_enum.email_event_id
Null on delete
emails_events_contact_id_fkey
email_events.contact_id
contacts.contact_id
Null on delete
emails_events_email_id_fkey
email_events.email_id
emails.email_id
Null on delete
account_surveys_type_enum_fkey
account_surveys.type
account_survey_type_enum.account_survey_type_id
Null on delete
account_surveys_form_template_id_fkey
account_surveys.form_template_id
form_templates.form_template_id
Null on delete
contact_organization_summary_contact_id_fkey
contact_organization_summary.contact_id
contacts.contact_id
Null on delete
data_requests_contact_id_fkey
data_requests.contact_id
contacts.contact_id
Null on delete
form_template_fields_form_field_type_id_fkey
form_template_fields.form_field_type_id
form_field_type_enum.form_field_type_id
Null on delete
form_template_fields_form_template_id_fkey
form_template_fields.form_template_id
form_templates.form_template_id
Null on delete
survey_responses_account_survey_id_fkey
survey_responses.account_survey_id
account_surveys.account_survey_id
Null on delete
survey_responses_opportunity_id_fkey
survey_responses.opportunity_id
opportunities.opportunity_id
Cascade on delete
contacts_consent_events_contact_consent_event_id_fkey
contact_consent_events.contact_consent_event_id
contact_consent_event_enum.contact_consent_event_id
Null on delete
contacts_consent_events_event_date_id_fkey
contact_consent_events.event_date_id
dates.date_id
Null on delete
contacts_consent_events_user_id_fkey
contact_consent_events.user_id
users.user_id
Null on delete
contacts_consent_events_contact_id_fkey
contact_consent_events.contact_id
contacts.contact_id
Null on delete
requisition_events_posting_id_fkey
requisition_events.posting_id
postings.posting_id
Null on delete
requisition_events_requisition_status_id_fkey
requisition_events.requisition_status_id
requisition_status_enum.requisition_status_id
Null on delete
requisition_events_previous_requisition_status_id_fkey
requisition_events.previous_requisition_status_id
requisition_status_enum.requisition_status_id
Null on delete
requisition_events_job_department_id_fkey
requisition_events.job_department_id
job_departments.job_department_id
Null on delete
requisition_events_job_location_id_fkey
requisition_events.job_location_id
job_locations.job_location_id
Null on delete
requisition_events_requisition_event_id_fkey
requisition_events.requisition_event_id
requisition_event_enum.requisition_event_id
Null on delete
requisition_events_job_department_team_id_fkey
requisition_events.job_department_team_id
job_department_teams.job_department_team_id
Null on delete
requisition_events_requisition_id_fkey
requisition_events.requisition_id
requisitions.requisition_id
Null on delete
requisition_events_hiring_manager_user_id_fkey
requisition_events.hiring_manager_user_id
users.user_id
Null on delete
requisition_events_owner_user_id_fkey
requisition_events.owner_user_id
users.user_id
Null on delete
requisition_events_creator_user_id_fkey
requisition_events.creator_user_id
users.user_id
Null on delete
requisition_events_event_date_id_fkey
requisition_events.event_date_id
dates.date_id
Null on delete
requisition_events_actor_id_fkey
requisition_events.actor_id
users.user_id
Null on delete
interview_panel_interviews_interview_panel_id_fkey
interview_panel_interviews.interview_panel_id
interview_panels.interview_panel_id
Null on delete
opportunity_forms_contact_id_fkey
opportunity_forms.contact_id
contacts.contact_id
Null on delete
opportunity_forms_form_template_id_fkey
opportunity_forms.form_template_id
form_templates.form_template_id
Null on delete
opportunity_forms_user_id_fkey
opportunity_forms.user_id
users.user_id
Null on delete
opportunity_forms_opportunity_id_fkey
opportunity_forms.opportunity_id
opportunities.opportunity_id
Cascade on delete
nurture_campaign_email_addresses_nurture_campaign_id_fkey
nurture_campaign_email_addresses.nurture_campaign_id
nurture_campaigns.nurture_campaign_id
Null on delete
opportunity_tags_opportunity_id_fkey
opportunity_tags.opportunity_id
opportunities.opportunity_id
Cascade on delete
opportunity_tags_tag_id_fkey
opportunity_tags.tag_id
tags.tag_id
Null on delete
external_message_participant_contacts_external_message_id_fkey
external_message_participant_contacts.external_message_id
external_messages.external_message_id
Null on delete
external_message_participant_external_message_participant_fkey1
external_message_participant_contacts.external_message_participant_id
external_message_participants.external_message_participant_id
Null on delete
external_message_participant_contacts_contact_id_fkey
external_message_participant_contacts.contact_id
contacts.contact_id
Null on delete
agency_jobs_agency_id_fkey
agency_jobs.agency_id
agencies.agency_id
Null on delete
agency_jobs_posting_id_fkey
agency_jobs.posting_id
postings.posting_id
Null on delete
opportunity_eeo_opportunity_id_fkey
opportunity_eeo.opportunity_id
opportunities.opportunity_id
Cascade on delete
opportunity_eeo_eeo_response_id_fkey
opportunity_eeo.eeo_response_id
eeo_responses.eeo_response_id
Cascade on delete
contact_web_links_contact_id_fkey
contact_web_links.contact_id
contacts.contact_id
Null on delete
form_template_field_options_form_template_id_fkey
form_template_field_options.form_template_id
form_templates.form_template_id
Null on delete
form_template_field_options_field_id_fkey
form_template_field_options.form_template_field_id
form_template_fields.form_template_field_id
Null on delete
opportunities_form_events_opportunity_id_fkey
opportunity_form_events.opportunity_id
opportunities.opportunity_id
Cascade on delete
opportunities_form_events_job_department_id_fkey
opportunity_form_events.job_department_id
job_departments.job_department_id
Null on delete
opportunities_form_events_contact_id_fkey
opportunity_form_events.contact_id
contacts.contact_id
Null on delete
opportunity_form_events_opportunity_form_event_id_fkey
opportunity_form_events.opportunity_form_event_id
opportunity_form_event_enum.opportunity_form_event_id
Null on delete
opportunities_form_events_job_department_team_id_fkey
opportunity_form_events.job_department_team_id
job_department_teams.job_department_team_id
Null on delete
opportunities_form_events_posting_id_fkey
opportunity_form_events.posting_id
postings.posting_id
Null on delete
opportunities_form_events_form_template_id_fkey
opportunity_form_events.form_template_id
form_templates.form_template_id
Null on delete
opportunities_form_events_account_stage_id_fkey
opportunity_form_events.account_stage_id
account_stages.account_stage_id
Null on delete
opportunities_form_events_job_location_id_fkey
opportunity_form_events.job_location_id
job_locations.job_location_id
Null on delete
opportunities_form_events_job_level_id_fkey
opportunity_form_events.job_level_id
job_levels.job_level_id
Null on delete
opportunities_form_events_opportunity_form_id_fkey
opportunity_form_events.opportunity_form_id
opportunity_forms.opportunity_form_id
Null on delete
opportunities_form_events_actor_id_fkey
opportunity_form_events.actor_id
users.user_id
Null on delete
opportunities_form_events_event_date_id_fkey
opportunity_form_events.event_date_id
dates.date_id
Null on delete
opportunities_form_events_job_work_type_id_fkey
opportunity_form_events.job_work_type_id
job_work_types.job_work_type_id
Null on delete
opportunities_form_events_requisition_id_fkey
opportunity_form_events.requisition_id
requisitions.requisition_id
Null on delete
postings_job_department_team_id_fkey
postings.job_department_team_id
job_department_teams.job_department_team_id
Null on delete
postings_job_work_type_id_fkey
postings.job_work_type_id
job_work_types.job_work_type_id
Null on delete
postings_hiring_manager_user_id_fkey
postings.hiring_manager_user_id
users.user_id
Null on delete
postings_owner_user_id_fkey
postings.owner_user_id
users.user_id
Null on delete
postings_job_location_id_fkey
postings.job_location_id
job_locations.job_location_id
Null on delete
postings_posting_status_id_fkey
postings.posting_status_id
posting_status_enum.posting_status_id
Restrict delete
postings_job_department_id_fkey
postings.job_department_id
job_departments.job_department_id
Null on delete
postings_job_level_id_fkey
postings.job_level_id
job_levels.job_level_id
Null on delete
contact_phones_contact_id_fkey
contact_phones.contact_id
contacts.contact_id
Null on delete
contact_location_contact_id_fkey
contact_location.contact_id
contacts.contact_id
Null on delete
api_credentials_creator_id_fkey
api_credentials.creator_id
users.user_id
Null on delete
requisition_postings_posting_id_fkey
requisition_postings.posting_id
postings.posting_id
Cascade on delete
requisition_postings_requisition_id_fkey
requisition_postings.requisition_id
requisitions.requisition_id
Cascade on delete
contact_emails_contact_id_fkey
contact_emails.contact_id
contacts.contact_id
Null on delete
opportunity_form_fields_form_field_type_id_fkey
opportunity_form_fields.form_field_type_id
form_field_type_enum.form_field_type_id
Null on delete
opportunity_form_fields_form_template_field_id_fkey
opportunity_form_fields.form_template_field_id
form_template_fields.form_template_field_id
opportunity_form_fields_opportunity_form_id_fkey
opportunity_form_fields.opportunity_form_id
opportunity_forms.opportunity_form_id
Null on delete
opportunity_form_fields_contact_id_fkey
opportunity_form_fields.contact_id
contacts.contact_id
Null on delete
offer_revision_fields_offer_id_fkey
offer_revision_fields.offer_id
offers.offer_id
Null on delete
offer_revision_fields_offer_revision_id_fkey
offer_revision_fields.offer_revision_id
offer_revisions.offer_revision_id
Null on delete
opportunity_sources_source_id_fkey
opportunity_sources.source_id
sources.source_id
Null on delete
opportunity_sources_opportunity_id_fkey
opportunity_sources.opportunity_id
opportunities.opportunity_id
Cascade on delete
opportunity_sources_opportunity_source_type_id_fkey
opportunity_sources.opportunity_source_type_id
opportunity_source_type_enum.opportunity_source_type_id
Null on delete
opportunity_referrals_posting_id_fkey
opportunity_referrals.posting_id
postings.posting_id
Null on delete
opportunity_referrals_opportunity_id_fkey
opportunity_referrals.opportunity_id
opportunities.opportunity_id
Cascade on delete
opportunity_referrals_opportunity_form_id_fkey
opportunity_referrals.opportunity_form_id
opportunity_forms.opportunity_form_id
Cascade on delete
opportunity_referrals_contact_id_fkey
opportunity_referrals.contact_id
contacts.contact_id
Null on delete
opportunity_referrals_user_id_fkey
opportunity_referrals.user_id
users.user_id
Null on delete
eeo_responses_eeo_source_id_fkey
eeo_responses.eeo_source_id
eeo_source_enum.eeo_source_id
Null on delete
nurture_campaign_step_archives_nurture_campaign_id_fkey
nurture_campaign_step_archives.nurture_campaign_id
nurture_campaigns.nurture_campaign_id
Null on delete
nurture_campaign_step_archives_archive_reason_id_fkey
nurture_campaign_step_archives.archive_reason_id
archive_reasons.archive_reason_id
Null on delete
nurture_campaign_step_archives_nurture_campaign_step_id_fkey
nurture_campaign_step_archives.nurture_campaign_step_id
nurture_campaign_steps.nurture_campaign_step_id
Null on delete
survey_response_tracking_survey_response_id_fkey
survey_response_tracking.survey_response_id
survey_responses.survey_response_id
Null on delete
posting_followers_posting_id_fkey
posting_followers.posting_id
postings.posting_id
Cascade on delete
posting_followers_user_id_fkey
posting_followers.user_id
users.user_id
Cascade on delete
requisitions_job_department_team_id_fkey
requisitions.job_department_team_id
job_department_teams.job_department_team_id
Null on delete
requisitions_requisition_status_id_fkey
requisitions.requisition_status_id
requisition_status_enum.requisition_status_id
Restrict delete
requisitions_owner_user_id_fkey
requisitions.owner_user_id
users.user_id
Null on delete
requisitions_job_department_id_fkey
requisitions.job_department_id
job_departments.job_department_id
Null on delete
requisitions_creator_user_id_fkey
requisitions.creator_user_id
users.user_id
Null on delete
requisitions_job_location_id_fkey
requisitions.job_location_id
job_locations.job_location_id
Null on delete
requisitions_hiring_manager_user_id_fkey
requisitions.hiring_manager_user_id
users.user_id
Null on delete
nurture_templates_owner_user_id_fkey
nurture_templates.owner_user_id
users.user_id
Null on delete
opportunity_form_field_files_opportunity_form_field_id_fkey
opportunity_form_field_files.opportunity_form_field_id
opportunity_form_fields.opportunity_form_field_id
Cascade on delete
opportunity_form_field_files_form_id_fkey
opportunity_form_field_files.opportunity_form_id
opportunity_forms.opportunity_form_id
Null on delete
opportunity_form_field_files_contact_id_fkey
opportunity_form_field_files.contact_id
contacts.contact_id
Null on delete
opportunity_form_field_files_opportunity_id_fkey
opportunity_form_field_files.opportunity_id
opportunities.opportunity_id
Cascade on delete

Check Constraints

Table Constraint Name Constraint