Constraints

111 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

CandidacyUnsuiteds_candidacyId_fkey

CandidacyUnsuiteds.candidacyId

Cascade on delete

CandidacyUnsuiteds_recruiterId_fkey

CandidacyUnsuiteds.recruiterId

Restrict delete

HubspotJobOrders_associatedDealId_fkey

HubspotJobOrders.associatedDealId

HubspotDeals.id

Null on delete

Candidacies_mergedTalentProfileId_fkey

Candidacies.mergedTalentProfileId

MergedTalentProfiles.id

Restrict delete

Candidacies_inboundApplicationId_fkey

Candidacies.inboundApplicationId

InboundApplications.id

Cascade on delete

Candidacies_jobOrderId_fkey

Candidacies.jobOrderId

Cascade on delete

Candidacies_recruiterId_fkey

Candidacies.recruiterId

Restrict delete

HubspotCompanyDeals_hubspotCompanyId_fkey

HubspotCompanyDeals.hubspotCompanyId

HubspotCompanies.id

Cascade on delete

HubspotCompanyDeals_hubspotDealId_fkey

HubspotCompanyDeals.hubspotDealId

HubspotDeals.id

Cascade on delete

Rstc_recruiterSavedTalentCollectionId_fkey

RecruiterSavedTalentCollectionTalents.recruiterSavedTalentCollectionId

RecruiterSavedTalentCollections.id

Cascade on delete

Rst_recruiterSavedTalentId_fkey

RecruiterSavedTalentCollectionTalents.recruiterSavedTalentId

RecruiterSavedTalents.id

Cascade on delete

JobOrderBenefits_jobOrderId_fkey

JobOrderBenefits.jobOrderId

Cascade on delete

JobOrderChangeLogs_jobOrderId_fkey

JobOrderChangeLogs.jobOrderId

Cascade on delete

JobOrderChangeLogs_recruiterId_fkey

JobOrderChangeLogs.recruiterId

Cascade on delete

CandidacyHireds_recruiterId_fkey

CandidacyHireds.recruiterId

Restrict delete

CandidacyHireds_candidacyId_fkey

CandidacyHireds.candidacyId

Cascade on delete

SupersourceRejecteds_jobOrderId_fkey

SupersourceRejecteds.jobOrderId

Cascade on delete

SupersourceRejecteds_createdByRecruiterId_fkey

SupersourceRejecteds.createdByRecruiterId

Restrict delete

SupersourceRejecteds_mergedTalentProfileId_fkey

SupersourceRejecteds.mergedTalentProfileId

MergedTalentProfiles.id

Restrict delete

ReportingGroups_createdBy_fkey

ReportingGroups.createdBy

Restrict delete

InboundMarketplaceApplications_inboundApplicationId_fkey

InboundMarketplaceApplications.inboundApplicationId

InboundApplications.id

Cascade on delete

RecruiterSavedTalentStatusLogs_recruiterSavedTalentId_fkey

RecruiterSavedTalentStatusLogs.recruiterSavedTalentId

RecruiterSavedTalents.id

Cascade on delete

RecruiterSavedTalentStatusLogs_jobOrderId_fkey

RecruiterSavedTalentStatusLogs.jobOrderId

Cascade on delete

SupersourceSaveds_mergedTalentProfileId_fkey

SupersourceSaveds.mergedTalentProfileId

MergedTalentProfiles.id

Restrict delete

SupersourceSaveds_createdByRecruiterId_fkey

SupersourceSaveds.createdByRecruiterId

Restrict delete

SupersourceSaveds_jobOrderId_fkey

SupersourceSaveds.jobOrderId

Cascade on delete

UserJobOrderSearchConditions_userId_fkey

UserJobOrderSearchConditions.userId

Cascade on delete

JobOrderContacts_jobOrderId_fkey

JobOrderContacts.jobOrderId

Cascade on delete

JobOrderCloseds_jobOrderId_fkey

JobOrderCloseds.jobOrderId

Cascade on delete

JobOrderCloseds_createdByRecruiterId_fkey

JobOrderCloseds.createdByRecruiterId

Restrict delete

InternalMessagingPlatformUsers_userId_fkey

InternalMessagingPlatformUsers.userId

Cascade on delete

CandidacyRecommendeds_candidacyId_fkey

CandidacyRecommendeds.candidacyId

Cascade on delete

CandidacyRecommendeds_recruiterId_fkey

CandidacyRecommendeds.recruiterId

Restrict delete

BusinessUnitRecruiters_businessUnitId_fkey

BusinessUnitRecruiters.businessUnitId

BusinessUnits.id

Restrict delete

CandidacySelectionHappeneds_recruiterId_fkey

CandidacySelectionHappeneds.recruiterId

Restrict delete

CandidacySelectionHappeneds_candidacySelectionScheduledId_fkey

CandidacySelectionHappeneds.candidacySelectionScheduledId

CandidacySelectionScheduleds.id

Cascade on delete

JobOrderCities_jobOrderId_fkey

JobOrderCities.jobOrderId

Cascade on delete

JobOrderCities_cityId_fkey

JobOrderCities.cityId

Restrict delete

JobOrderCities_locationId_fkey

JobOrderCities.locationId

Null on delete

Recruiters_businessUnitRecruiterId_fkey

Recruiters.businessUnitRecruiterId

BusinessUnitRecruiters.id

Restrict delete

Recruiters_teamRecruiterId_fkey

Recruiters.teamRecruiterId

TeamRecruiters.id

Restrict delete

Recruiters_userId_fkey

Recruiters.userId

Restrict delete

JobOrderAssignments_recruiterId_fkey

JobOrderAssignmentTags.recruiterId

Cascade on delete

JobOrderAssignments_jobOrderId_fkey

JobOrderAssignmentTags.jobOrderId

Cascade on delete

JobOrderFiles_jobOrderId_fkey

JobOrderFiles.jobOrderId

Cascade on delete

JobOrderFiles_updatedByRecruiterId_fkey

JobOrderFiles.updatedByRecruiterId

Null on delete

JobOrderFiles_createdByRecruiterId_fkey

JobOrderFiles.createdByRecruiterId

Null on delete

CandidacyHandovereds_candidacyId_fkey

CandidacyHandovereds.candidacyId

Cascade on delete

CandidacyHandovereds_recruiterId_fkey

CandidacyHandovereds.recruiterId

Cascade on delete

JobOrderForecastReview_createdByRecruiterId_fkey

JobOrderForecastReview.createdByRecruiterId

Null on delete

JobOrderForecastReview_updatedByRecruiterId_fkey

JobOrderForecastReview.updatedByRecruiterId

Null on delete

JobOrderForecastReview_jobOrderId_fkey

JobOrderForecastReview.jobOrderId

Cascade on delete

JobOrderClosedReasons_jobOrderClosedId_fkey

JobOrderClosedReasons.jobOrderClosedId

JobOrderCloseds.id

Cascade on delete

JobOrderSkills_skillId_fkey

JobOrderSkills.skillId

Cascade on delete

JobOrderSkills_jobOrderId_fkey

JobOrderSkills.jobOrderId

Cascade on delete

JobOrders_jobCategoryId_fkey

JobOrders.jobCategoryId

JobCategories.id

Restrict delete

fk_hubspot_job_order_id

JobOrders.hubspotJobOrderId

HubspotJobOrders.id

Null on delete

JobOrders_inChargedRecruiterId_fkey

JobOrders.inChargedRecruiterId

Restrict delete

JobOrders_hubspotTicketId_fkey

JobOrders.hubspotTicketId

HubspotTickets.id

Restrict delete

JobOrders_lastJobOrderForecastReviewId_fkey

JobOrders.lastJobOrderForecastReviewId

JobOrderForecastReview.id

Null on delete

JobOrders_recruitmentConsultantId_fkey

JobOrders.recruitmentConsultantId

Null on delete

JobOrders_currencyId_fkey

JobOrders.currencyId

Currencies.code

Restrict delete

JobOrders_associatedJobOrderId_fkey

JobOrders.associatedJobOrderId

Null on delete

JobOrders_teamId_fkey

JobOrders.teamId

Restrict delete

JobOrders_hubspotDealId_fkey

JobOrders.hubspotDealId

HubspotDeals.id

Null on delete

JobOrders_createdByRecruiterId_fkey

JobOrders.createdByRecruiterId

Restrict delete

JobOrders_recommendedSourcingSalariesCurrencyId_fkey

JobOrders.recommendedSourcingSalariesCurrencyId

Currencies.code

Restrict delete

SupersourceRejectedReasons_supersourceRejectedId_fkey

SupersourceRejectedReasons.supersourceRejectedId

SupersourceRejecteds.id

Cascade on delete

hubspotdeals_dealstage_fkey

HubspotDeals.dealStage

HubspotDealStages.id

Restrict delete

Teams_businessUnitId_fkey

Teams.businessUnitId

BusinessUnits.id

Restrict delete

TeamReportingGroups_reportingGroupId_fkey

TeamReportingGroups.reportingGroupId

ReportingGroups.id

Cascade on delete

TeamReportingGroups_teamId_fkey

TeamReportingGroups.teamId

Restrict delete

JobOrderMarketplaceListings_jobOrderId_fkey

JobOrderMarketplaceListings.jobOrderId

Cascade on delete

TeamRecruiters_teamId_fkey

TeamRecruiters.teamId

Restrict delete

JobOrderLanguages_jobOrderId_fkey

JobOrderLanguages.jobOrderId

Cascade on delete

JobOrderLanguages_languageCode_fkey

JobOrderLanguages.languageCode

Cascade on delete

JobOrderPrioritizedReasons_jobOrderPrioritizedId_fkey

JobOrderPrioritizedReasons.jobOrderPrioritizedId

JobOrderPrioritizeds.id

Cascade on delete

Recruiters_recruiterId_fkey

RecruiterSavedTalents.recruiterId

Cascade on delete

MergedTalentProfiles_mergedTalentProfileId_fkey

RecruiterSavedTalents.mergedTalentProfileId

MergedTalentProfiles.id

Cascade on delete

RecruiterSavedTalents_candidateId_fkey

RecruiterSavedTalents.candidateId

Cascade on delete

CandidacySelectionScheduleds_recruiterId_fkey

CandidacySelectionScheduleds.recruiterId

Restrict delete

CandidacySelectionScheduleds_candidacyId_fkey

CandidacySelectionScheduleds.candidacyId

Cascade on delete

CandidacySelectionScheduledFinals_candidacyId_fkey

CandidacySelectionScheduledFinals.candidacyId

Cascade on delete

CandidacySelectionScheduledFinals_selectionScheduledId_fkey

CandidacySelectionScheduledFinals.candidacySelectionScheduledId

CandidacySelectionScheduleds.id

Cascade on delete

CandidacyUnsuitedReasons_candidacyUnsuitedId_fkey

CandidacyUnsuitedReasons.candidacyUnsuitedId

CandidacyUnsuiteds.id

Cascade on delete

HubspotTicketDeals_hubspotTicketId_fkey

HubspotTicketDeals.hubspotTicketId

HubspotTickets.id

Cascade on delete

HubspotTicketDeals_hubspotDealId_fkey

HubspotTicketDeals.hubspotDealId

HubspotDeals.id

Cascade on delete

JobOrderJobTitles_jobTitleId_fkey

JobOrderJobTitles.jobTitleId

Cascade on delete

JobOrderJobTitles_jobOrderId_fkey

JobOrderJobTitles.jobOrderId

Cascade on delete

JobOrderJobTitles_hierarchicalJobCategoryId_fkey

JobOrderJobTitles.hierarchicalJobCategoryId

HierarchicalJobCategories.id

Cascade on delete

CandidacySourceds_recruiterId_fkey

CandidacySourceds.recruiterId

Restrict delete

CandidacySourceds_candidacyId_fkey

CandidacySourceds.candidacyId

Cascade on delete

InboundApplications_mergedTalentProfileId_fkey

InboundApplications.mergedTalentProfileId

MergedTalentProfiles.id

Cascade on delete

InboundApplications_jobOrderId_fkey

InboundApplications.jobOrderId

Cascade on delete

Recruiters_recruiterId_fkey

RecruiterSavedTalentCollections.recruiterId

Cascade on delete

JobOrders_jobOrderId_fkey

JobOrderReopeneds.jobOrderId

Cascade on delete

JobOrderReopeneds_createdByRecruiterId_fkey

JobOrderReopeneds.createdByRecruiterId

Restrict delete

JobOrderDeprioritizeds_jobOrderId_fkey

JobOrderDeprioritizeds.jobOrderId

Cascade on delete

JobOrderDeprioritizeds_createdByRecruiterId_fkey

JobOrderDeprioritizeds.createdByRecruiterId

Restrict delete

JobOrderIndustryPreferences_jobOrderId_fkey

JobOrderIndustryPreferences.jobOrderId

Cascade on delete

JobOrderIndustryPreferences_industryId_fkey

JobOrderIndustryPreferences.industryId

IndustriesV2.id

Cascade on delete

JobOrderPrioritizeds_createdByRecruiterId_fkey

JobOrderPrioritizeds.createdByRecruiterId

Restrict delete

JobOrderPrioritizeds_jobOrderId_fkey

JobOrderPrioritizeds.jobOrderId

Cascade on delete

CandidacyOffereds_candidacyId_fkey

CandidacyOffereds.candidacyId

Cascade on delete

CandidacyOffereds_recruiterId_fkey

CandidacyOffereds.recruiterId

Restrict delete

CandidacyComments_createdByRecruiterId_fkey

CandidacyComments.createdByRecruiterId

Restrict delete

CandidacyComments_candidacyId_fkey

CandidacyComments.candidacyId

Restrict delete

JobOrderDeprioritizedReasons_jobOrderDeprioritizedId_fkey

JobOrderDeprioritizedReasons.jobOrderDeprioritizedId

JobOrderDeprioritizeds.id

Cascade on delete

JobOrderForecast_jobOrderId_fkey

JobOrderForecast.jobOrderId

Cascade on delete

JobOrderForecast_updatedByRecruiterId_fkey

JobOrderForecast.updatedByRecruiterId

Null on delete

JobOrderForecast_createdByRecruiterId_fkey

JobOrderForecast.createdByRecruiterId

Null on delete

Check Constraints

Table	Constraint Name	Constraint
Recruiters	Recruiters_fk_null_check	(((("isAdmin" = false) OR (("teamRecruiterId" IS NULL) AND ("businessUnitRecruiterId" IS NULL))) AND (NOT (("teamRecruiterId" IS NULL) AND ("businessUnitRecruiterId" IS NULL) AND ("isAdmin" = false)))))
JobOrderClosedReasons	JobOrderClosedReasons_note_check	((((reason = 'OTHER'::superpowered."enum_JobOrderClosedReasons_reason") AND (note IS NOT NULL)) OR (reason <> 'OTHER'::superpowered."enum_JobOrderClosedReasons_reason")))
JobOrders	JobOrders_headcount_check	((headcount <@ '[1,101)'::int4range))
JobOrders	JobOrders_probationInMonth_check	(("probationInMonth" <@ '[1,13)'::int4range))
JobOrders	JobOrders_teamSize_check	(("teamSize" <@ '[0,101)'::int4range))
SupersourceRejectedReasons	SupersourceRejectedReasons_supersourceRejectedId_unique	(((reason = 'OTHER'::superpowered."enum_SupersourceRejectedReasons_reason") <> (note IS NULL)))
JobOrderPrioritizedReasons	JobOrderPrioritizedReasons_note_check	((((reason = 'OTHER'::superpowered."enum_JobOrderPrioritizedReasons_reason") AND (note IS NOT NULL)) OR (reason <> 'OTHER'::superpowered."enum_JobOrderPrioritizedReasons_reason")))
JobOrderDeprioritizedReasons	JobOrderDeprioritizedReasons_note_check	((((reason = 'OTHER'::superpowered."enum_JobOrderDeprioritizedReasons_reason") AND (note IS NOT NULL)) OR (reason <> 'OTHER'::superpowered."enum_JobOrderDeprioritizedReasons_reason")))