Constraints

InferredCandidateWorkExperiences.id

Cascade on delete

InferredCandidateWorkExperienceSkills_normalizedSkillId_fkey

InferredCandidateWorkExperienceSkills.normalizedSkillId

NormalizedSkills.id

Null on delete

InferredCandidateWorkExperien_inferredCandidateWorkExperie_fkey

InferredCandidateWorkExperienceSkills.inferredCandidateWorkExperienceId

Cascade on delete

InferredCandidateWorkExperienceSkills_skillId_fkey

InferredCandidateWorkExperienceSkills.skillId

Skills.id

Null on delete

InferredCandidates_locationId_fkey

InferredCandidates.locationId

Null on delete

InferredCandidates_parseResumeId_fkey

InferredCandidates.parseResumeId

ParsedResumes.id

Null on delete

InferredCandidates_candidateId_fkey

InferredCandidates.candidateId

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

Cascade on delete

CandidateLocationPreferences_cityId_fkey

CandidateLocationPreferences.cityId

Cities.id

Null on delete

CandidateLocationPreferences_locationId_fkey

CandidateLocationPreferences.locationId

Null on delete

CandidateLocationPreferences_candidateId_fkey

CandidateLocationPreferences.candidateId

Cascade on delete

CandidateLocationPreferences_createdByRecruiterId_fkey

CandidateLocationPreferences.createdByRecruiterId

Null on delete

CandidateLocationPreferences_countryCode_fkey

CandidateLocationPreferences.countryCode

Countries.code

Null on delete

CandidateLocationPreferences_updatedByRecruiterId_fkey

CandidateLocationPreferences.updatedByRecruiterId

Null on delete

RejectedJobOrderCandidates_jobOrderCandidateId_fkey

RejectedJobOrderCandidates.jobOrderCandidateId

JobOrderCandidates.id

Cascade on delete

UnifiedTalentProfiles_candidateId_fkey

UnifiedTalentProfiles.candidateId

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

Null on delete

CandidateFiles_candidateId_fkey

CandidateFiles.candidateId

Cascade on delete

CandidateFiles_createdByRecruiterId_fkey

CandidateFiles.createdByRecruiterId

Null on delete

InferredJobRoles_hierarchicalJobCategoryId_fkey

InferredJobRoles.hierarchicalJobCategoryId

Null on delete

CandidateJobCategoryPreferences_createdByRecruiterId_fkey

CandidateJobCategoryPreferences.createdByRecruiterId

Null on delete

CandidateJobCategoryPreferences_updatedByRecruiterId_fkey

CandidateJobCategoryPreferences.updatedByRecruiterId

Null on delete

CandidateJobCategoryPreferences_candidateId_fkey

CandidateJobCategoryPreferences.candidateId

Cascade on delete

CandidateJobCategoryPreferences_hierarchicalJobCategoryId_fkey

CandidateJobCategoryPreferences.hierarchicalJobCategoryId

Cascade on delete

InferredCandidateWorkExperiences_inferredCandidateId_fkey

InferredCandidateWorkExperiences.inferredCandidateId

Cascade on delete

InferredCandidateWorkExperiences_hierarchicalJobCategoryId_fkey

InferredCandidateWorkExperiences.hierarchicalJobCategoryId

Null on delete

TalentConsultantNotifications_jobOrderId_fkey

TalentConsultantNotifications.jobOrderId

JobOrders.id

Cascade on delete

TalentConsultantNotifications_candidateId_fkey

TalentConsultantNotifications.candidateId

Cascade on delete

TalentConsultantNotifications_recruiterId_fkey

TalentConsultantNotifications.recruiterId

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

CandidateActivenessStatusLogs.id

Null on delete

Candidates_activenessStatusLogId_fkey

Candidates.activenessStatusLogId

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

Null on delete

Candidates_createdByRecruiterId_fkey

Candidates.createdByRecruiterId

Null on delete

Candidates_updatedByRecruiterId_fkey

Candidates.updatedByRecruiterId

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

Cascade on delete

CandidateRelocations_updatedByRecruiterId_fkey

CandidateRelocations.updatedByRecruiterId

Restrict delete

CandidateRelocations_createdByRecruiterId_fkey

CandidateRelocations.createdByRecruiterId

Restrict delete

CandidateLanguages_candidateId_fkey

CandidateLanguages.candidateId

Cascade on delete

CandidateLanguages_languageCode_fkey

CandidateLanguages.languageCode

Languages.code

Cascade on delete

CandidateLanguages_createdByRecruiterId_fkey

CandidateLanguages.createdByRecruiterId

Null on delete

CandidateLanguages_updatedByRecruiterId_fkey

CandidateLanguages.updatedByRecruiterId

Null on delete

CandidateWorkArrangements_candidateId_fkey

CandidateWorkArrangements.candidateId

Cascade on delete

CandidateWorkArrangements_createdByRecruiterId_fkey

CandidateWorkArrangements.createdByRecruiterId

Null on delete

CandidateWorkArrangements_updatedByRecruiterId_fkey

CandidateWorkArrangements.updatedByRecruiterId

Null on delete

ParsedResumeWorkExperiences_parsedResumeId_fkey

ParsedResumeWorkExperiences.parsedResumeId

ParsedResumes.id

Cascade on delete

CandidateNotes_createdByRecruiterId_fkey

CandidateNotes.createdByRecruiterId

Null on delete

CandidateNotes_updatedByRecruiterId_fkey

CandidateNotes.updatedByRecruiterId

Null on delete

CandidateNotes_candidateId_fkey

CandidateNotes.candidateId

Cascade on delete

CandidateWorkExperiences_candidateId_fkey

CandidateWorkExperiences.candidateId

Cascade on delete

CandidateWorkExperiences_updatedByRecruiterId_fkey

CandidateWorkExperiences.updatedByRecruiterId

Null on delete

CandidateWorkExperiences_hierarchicalJobCategoryId_fkey

CandidateWorkExperiences.hierarchicalJobCategoryId

Null on delete

fk_inferredhjcid

CandidateWorkExperiences.inferredHJCId

Null on delete

CandidateWorkExperiences_industryId_fkey

CandidateWorkExperiences.industryId

IndustriesV2.id

Null on delete

CandidateWorkExperiences_createdByRecruiterId_fkey

CandidateWorkExperiences.createdByRecruiterId

Null on delete

CandidateActivenessStatusLogs_candidateId_fkey

CandidateActivenessStatusLogs.candidateId

Cascade on delete

CandidatePreferredJobCategories_createdByRecruiterId_fkey

CandidatePreferredJobCategories.createdByRecruiterId

Restrict delete

CandidatePreferredJobCategories_candidateId_fkey

CandidatePreferredJobCategories.candidateId

Cascade on delete

CandidatePreferredJobCategories_hierarchicalJobCategoryId_fkey

CandidatePreferredJobCategories.hierarchicalJobCategoryId

Cascade on delete

CandidatePreferredJobCategories_updatedByRecruiterId_fkey

CandidatePreferredJobCategories.updatedByRecruiterId

Restrict delete

CandidateSkills_updatedByRecruiterId_fkey

CandidateSkills.updatedByRecruiterId

Null on delete

CandidateSkills_candidateId_fkey

CandidateSkills.candidateId

Cascade on delete

CandidateSkills_skillId_fkey

CandidateSkills.skillId

Skills.id

Cascade on delete

CandidateSkills_createdByRecruiterId_fkey

CandidateSkills.createdByRecruiterId

Null on delete

JobOrderCandidates_candidateId_fkey

JobOrderCandidates.candidateId

Cascade on delete

JobOrderCandidates_updatedByRecruiterId_fkey

JobOrderCandidates.updatedByRecruiterId

Null on delete

JobOrderCandidates_jobOrderId_fkey

JobOrderCandidates.jobOrderId

JobOrders.id

Cascade on delete

JobOrderCandidates_createdByRecruiterId_fkey

JobOrderCandidates.createdByRecruiterId

Null on delete

JobOrderCandidates_assignedToRecruiterId_fkey

JobOrderCandidates.assignedToRecruiterId

Null on delete

InferredCandidateSkills_skillId_fkey

InferredCandidateSkills.skillId

Skills.id

Null on delete

InferredCandidateSkills_inferredCandidateId_fkey

InferredCandidateSkills.inferredCandidateId

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

Cascade on delete

InferredCandidateLanguages_languageCode_fkey

InferredCandidateLanguages.languageCode

Languages.code

Cascade on delete

InferredCandidateLanguages_inferredCandidateId_fkey

InferredCandidateLanguages.inferredCandidateId

Cascade on delete

ScheduledEvents_candidateId_fkey

ScheduledEvents.candidateId

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

Null on delete

ShortlistedJobOrderCandidates_jobOrderCandidateId_fkey

ShortlistedJobOrderCandidates.jobOrderCandidateId

JobOrderCandidates.id

Cascade on delete

CandidateRespondIoSyncMismatch_candidateId_fkey

CandidateRespondIoSyncMismatch.candidateId