Constraints

100 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
CandidateWorkExperienceSkills_normalizedSkillId_fkey
CandidateWorkExperienceSkills.normalizedSkillId
NormalizedSkills.id
Null on delete
CandidateWorkExperienceSkills_candidateWorkExperienceId_fkey
CandidateWorkExperienceSkills.candidateWorkExperienceId
CandidateWorkExperiences.id
Restrict delete
CandidateWorkExperienceSkills_skillId_fkey
CandidateWorkExperienceSkills.skillId
Skills.id
Null on delete
RelocationCities_countryCode_fkey
RelocationCities.countryCode
Countries.code
Cascade on delete
RelocationCities_cityId_fkey
RelocationCities.cityId
Cities.id
Cascade on delete
RelocationCities_locationId_fkey
RelocationCities.locationId
Locations.id
Cascade on delete
InferredCandidateWorkExperienceSkills_normalizedSkillId_fkey
InferredCandidateWorkExperienceSkills.normalizedSkillId
NormalizedSkills.id
Null on delete
InferredCandidateWorkExperien_inferredCandidateWorkExperie_fkey
InferredCandidateWorkExperienceSkills.inferredCandidateWorkExperienceId
InferredCandidateWorkExperiences.id
Cascade on delete
InferredCandidateWorkExperienceSkills_skillId_fkey
InferredCandidateWorkExperienceSkills.skillId
Skills.id
Null on delete
InferredCandidates_locationId_fkey
InferredCandidates.locationId
Locations.id
Null on delete
InferredCandidates_parseResumeId_fkey
InferredCandidates.parseResumeId
ParsedResumes.id
Null on delete
InferredCandidates_candidateId_fkey
InferredCandidates.candidateId
Candidates.id
Cascade on delete
InferredCandidates_cityId_fkey
InferredCandidates.cityId
Cities.id
Null on delete
InferredCandidates_countryCode_fkey
InferredCandidates.countryCode
Countries.code
Null on delete
ParsedResumes_candidateId_fkey
ParsedResumes.candidateId
Candidates.id
Cascade on delete
CandidateLocationPreferences_cityId_fkey
CandidateLocationPreferences.cityId
Cities.id
Null on delete
CandidateLocationPreferences_locationId_fkey
CandidateLocationPreferences.locationId
Locations.id
Null on delete
CandidateLocationPreferences_candidateId_fkey
CandidateLocationPreferences.candidateId
Candidates.id
Cascade on delete
CandidateLocationPreferences_createdByRecruiterId_fkey
CandidateLocationPreferences.createdByRecruiterId
Recruiters.id
Null on delete
CandidateLocationPreferences_countryCode_fkey
CandidateLocationPreferences.countryCode
Countries.code
Null on delete
CandidateLocationPreferences_updatedByRecruiterId_fkey
CandidateLocationPreferences.updatedByRecruiterId
Recruiters.id
Null on delete
RejectedJobOrderCandidates_jobOrderCandidateId_fkey
RejectedJobOrderCandidates.jobOrderCandidateId
JobOrderCandidates.id
Cascade on delete
UnifiedTalentProfiles_candidateId_fkey
UnifiedTalentProfiles.candidateId
Candidates.id
Cascade on delete
UnifiedTalentProfiles_userId_fkey
UnifiedTalentProfiles.userId
Users.id
Null on delete
UnifiedTalentProfiles_mergedTalentProfileId_fkey
UnifiedTalentProfiles.mergedTalentProfileId
MergedTalentProfiles.id
Cascade on delete
CandidateFiles_updatedByRecruiterId_fkey
CandidateFiles.updatedByRecruiterId
Recruiters.id
Null on delete
CandidateFiles_candidateId_fkey
CandidateFiles.candidateId
Candidates.id
Cascade on delete
CandidateFiles_createdByRecruiterId_fkey
CandidateFiles.createdByRecruiterId
Recruiters.id
Null on delete
InferredJobRoles_hierarchicalJobCategoryId_fkey
InferredJobRoles.hierarchicalJobCategoryId
HierarchicalJobCategories.id
Null on delete
CandidateJobCategoryPreferences_createdByRecruiterId_fkey
CandidateJobCategoryPreferences.createdByRecruiterId
Recruiters.id
Null on delete
CandidateJobCategoryPreferences_updatedByRecruiterId_fkey
CandidateJobCategoryPreferences.updatedByRecruiterId
Recruiters.id
Null on delete
CandidateJobCategoryPreferences_candidateId_fkey
CandidateJobCategoryPreferences.candidateId
Candidates.id
Cascade on delete
CandidateJobCategoryPreferences_hierarchicalJobCategoryId_fkey
CandidateJobCategoryPreferences.hierarchicalJobCategoryId
HierarchicalJobCategories.id
Cascade on delete
InferredCandidateWorkExperiences_inferredCandidateId_fkey
InferredCandidateWorkExperiences.inferredCandidateId
InferredCandidates.id
Cascade on delete
InferredCandidateWorkExperiences_hierarchicalJobCategoryId_fkey
InferredCandidateWorkExperiences.hierarchicalJobCategoryId
HierarchicalJobCategories.id
Null on delete
TalentConsultantNotifications_jobOrderId_fkey
TalentConsultantNotifications.jobOrderId
JobOrders.id
Cascade on delete
TalentConsultantNotifications_candidateId_fkey
TalentConsultantNotifications.candidateId
Candidates.id
Cascade on delete
TalentConsultantNotifications_recruiterId_fkey
TalentConsultantNotifications.recruiterId
Recruiters.id
Cascade on delete
CandidateNoteJobOrders_jobOrderId_fkey
CandidateNoteJobOrders.jobOrderId
JobOrders.id
Cascade on delete
CandidateNoteJobOrders_candidateNoteId_fkey
CandidateNoteJobOrders.candidateNoteId
CandidateNotes.id
Cascade on delete
Candidates_parseResumeId_fkey
Candidates.parseResumeId
ParsedResumes.id
Null on delete
Candidates_currentSalaryCurrencyCode_fkey
Candidates.currentSalaryCurrencyCode
Currencies.code
Null on delete
Candidates_inferredCandidateId_fkey
Candidates.inferredCandidateId
InferredCandidates.id
Null on delete
Candidates_activenessStatusLogId_fkey
Candidates.activenessStatusLogId
CandidateActivenessStatusLogs.id
Null on delete
Candidates_countryCode_fkey
Candidates.countryCode
Countries.code
Null on delete
Candidates_lastContactedId_fkey
Candidates.lastContactedId
RecruiterSavedTalentStatusLogs.id
Null on delete
Candidates_resumeId_fkey
Candidates.resumeId
CandidateFiles.id
Null on delete
Candidates_locationId_fkey
Candidates.locationId
Locations.id
Null on delete
Candidates_createdByRecruiterId_fkey
Candidates.createdByRecruiterId
Recruiters.id
Null on delete
Candidates_updatedByRecruiterId_fkey
Candidates.updatedByRecruiterId
Recruiters.id
Null on delete
Candidates_expectedSalaryCurrencyCode_fkey
Candidates.expectedSalaryCurrencyCode
Currencies.code
Null on delete
Candidates_cityId_fkey
Candidates.cityId
Cities.id
Null on delete
CandidateRelocations_relocationCityId_fkey
CandidateRelocations.relocationCityId
RelocationCities.id
Cascade on delete
CandidateRelocations_candidateId_fkey
CandidateRelocations.candidateId
Candidates.id
Cascade on delete
CandidateRelocations_updatedByRecruiterId_fkey
CandidateRelocations.updatedByRecruiterId
Recruiters.id
Restrict delete
CandidateRelocations_createdByRecruiterId_fkey
CandidateRelocations.createdByRecruiterId
Recruiters.id
Restrict delete
CandidateLanguages_candidateId_fkey
CandidateLanguages.candidateId
Candidates.id
Cascade on delete
CandidateLanguages_languageCode_fkey
CandidateLanguages.languageCode
Languages.code
Cascade on delete
CandidateLanguages_createdByRecruiterId_fkey
CandidateLanguages.createdByRecruiterId
Recruiters.id
Null on delete
CandidateLanguages_updatedByRecruiterId_fkey
CandidateLanguages.updatedByRecruiterId
Recruiters.id
Null on delete
CandidateWorkArrangements_candidateId_fkey
CandidateWorkArrangements.candidateId
Candidates.id
Cascade on delete
CandidateWorkArrangements_createdByRecruiterId_fkey
CandidateWorkArrangements.createdByRecruiterId
Recruiters.id
Null on delete
CandidateWorkArrangements_updatedByRecruiterId_fkey
CandidateWorkArrangements.updatedByRecruiterId
Recruiters.id
Null on delete
ParsedResumeWorkExperiences_parsedResumeId_fkey
ParsedResumeWorkExperiences.parsedResumeId
ParsedResumes.id
Cascade on delete
CandidateNotes_createdByRecruiterId_fkey
CandidateNotes.createdByRecruiterId
Recruiters.id
Null on delete
CandidateNotes_updatedByRecruiterId_fkey
CandidateNotes.updatedByRecruiterId
Recruiters.id
Null on delete
CandidateNotes_candidateId_fkey
CandidateNotes.candidateId
Candidates.id
Cascade on delete
CandidateWorkExperiences_candidateId_fkey
CandidateWorkExperiences.candidateId
Candidates.id
Cascade on delete
CandidateWorkExperiences_updatedByRecruiterId_fkey
CandidateWorkExperiences.updatedByRecruiterId
Recruiters.id
Null on delete
CandidateWorkExperiences_hierarchicalJobCategoryId_fkey
CandidateWorkExperiences.hierarchicalJobCategoryId
HierarchicalJobCategories.id
Null on delete
fk_inferredhjcid
CandidateWorkExperiences.inferredHJCId
HierarchicalJobCategories.id
Null on delete
CandidateWorkExperiences_industryId_fkey
CandidateWorkExperiences.industryId
IndustriesV2.id
Null on delete
CandidateWorkExperiences_createdByRecruiterId_fkey
CandidateWorkExperiences.createdByRecruiterId
Recruiters.id
Null on delete
CandidateActivenessStatusLogs_candidateId_fkey
CandidateActivenessStatusLogs.candidateId
Candidates.id
Cascade on delete
CandidatePreferredJobCategories_createdByRecruiterId_fkey
CandidatePreferredJobCategories.createdByRecruiterId
Recruiters.id
Restrict delete
CandidatePreferredJobCategories_candidateId_fkey
CandidatePreferredJobCategories.candidateId
Candidates.id
Cascade on delete
CandidatePreferredJobCategories_hierarchicalJobCategoryId_fkey
CandidatePreferredJobCategories.hierarchicalJobCategoryId
HierarchicalJobCategories.id
Cascade on delete
CandidatePreferredJobCategories_updatedByRecruiterId_fkey
CandidatePreferredJobCategories.updatedByRecruiterId
Recruiters.id
Restrict delete
CandidateSkills_updatedByRecruiterId_fkey
CandidateSkills.updatedByRecruiterId
Recruiters.id
Null on delete
CandidateSkills_candidateId_fkey
CandidateSkills.candidateId
Candidates.id
Cascade on delete
CandidateSkills_skillId_fkey
CandidateSkills.skillId
Skills.id
Cascade on delete
CandidateSkills_createdByRecruiterId_fkey
CandidateSkills.createdByRecruiterId
Recruiters.id
Null on delete
JobOrderCandidates_candidateId_fkey
JobOrderCandidates.candidateId
Candidates.id
Cascade on delete
JobOrderCandidates_updatedByRecruiterId_fkey
JobOrderCandidates.updatedByRecruiterId
Recruiters.id
Null on delete
JobOrderCandidates_jobOrderId_fkey
JobOrderCandidates.jobOrderId
JobOrders.id
Cascade on delete
JobOrderCandidates_createdByRecruiterId_fkey
JobOrderCandidates.createdByRecruiterId
Recruiters.id
Null on delete
JobOrderCandidates_assignedToRecruiterId_fkey
JobOrderCandidates.assignedToRecruiterId
Recruiters.id
Null on delete
InferredCandidateSkills_skillId_fkey
InferredCandidateSkills.skillId
Skills.id
Null on delete
InferredCandidateSkills_inferredCandidateId_fkey
InferredCandidateSkills.inferredCandidateId
InferredCandidates.id
Cascade on delete
InferredCandidateSkills_normalizedSkillId_fkey
InferredCandidateSkills.normalizedSkillId
NormalizedSkills.id
Null on delete
CampaignStepConfigs_campaignName_fkey
CampaignStepConfigs.campaignName
CampaignConfigs.name
Restrict delete
InferredCandidateLanguages_candidateId_fkey
InferredCandidateLanguages.candidateId
Candidates.id
Cascade on delete
InferredCandidateLanguages_languageCode_fkey
InferredCandidateLanguages.languageCode
Languages.code
Cascade on delete
InferredCandidateLanguages_inferredCandidateId_fkey
InferredCandidateLanguages.inferredCandidateId
InferredCandidates.id
Cascade on delete
ScheduledEvents_candidateId_fkey
ScheduledEvents.candidateId
Candidates.id
Null on delete
ScheduledEvents_campaignName_fkey
ScheduledEvents.campaignName
CampaignConfigs.name
Restrict delete
TalentCampaigns_campaignName_fkey
TalentCampaigns.campaignName
CampaignConfigs.name
Restrict delete
TalentCampaigns_candidateId_fkey
TalentCampaigns.candidateId
Candidates.id
Null on delete
ShortlistedJobOrderCandidates_jobOrderCandidateId_fkey
ShortlistedJobOrderCandidates.jobOrderCandidateId
JobOrderCandidates.id
Cascade on delete
CandidateRespondIoSyncMismatch_candidateId_fkey
CandidateRespondIoSyncMismatch.candidateId
Candidates.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint