Recruiters


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
CandidateFiles.createdByRecruiterId CandidateFiles_createdByRecruiterId_fkey N
CandidateFiles.updatedByRecruiterId CandidateFiles_updatedByRecruiterId_fkey N
CandidateJobCategoryPreferences.createdByRecruiterId CandidateJobCategoryPreferences_createdByRecruiterId_fkey N
CandidateJobCategoryPreferences.updatedByRecruiterId CandidateJobCategoryPreferences_updatedByRecruiterId_fkey N
CandidateLanguages.createdByRecruiterId CandidateLanguages_createdByRecruiterId_fkey N
CandidateLanguages.updatedByRecruiterId CandidateLanguages_updatedByRecruiterId_fkey N
CandidateLocationPreferences.createdByRecruiterId CandidateLocationPreferences_createdByRecruiterId_fkey N
CandidateLocationPreferences.updatedByRecruiterId CandidateLocationPreferences_updatedByRecruiterId_fkey N
CandidateNotes.createdByRecruiterId CandidateNotes_createdByRecruiterId_fkey N
CandidateNotes.updatedByRecruiterId CandidateNotes_updatedByRecruiterId_fkey N
CandidatePreferredJobCategories.createdByRecruiterId CandidatePreferredJobCategories_createdByRecruiterId_fkey R
CandidatePreferredJobCategories.updatedByRecruiterId CandidatePreferredJobCategories_updatedByRecruiterId_fkey R
CandidateRelocations.createdByRecruiterId CandidateRelocations_createdByRecruiterId_fkey R
CandidateRelocations.updatedByRecruiterId CandidateRelocations_updatedByRecruiterId_fkey R
Candidates.createdByRecruiterId Candidates_createdByRecruiterId_fkey N
Candidates.updatedByRecruiterId Candidates_updatedByRecruiterId_fkey N
CandidateSkills.createdByRecruiterId CandidateSkills_createdByRecruiterId_fkey N
CandidateSkills.updatedByRecruiterId CandidateSkills_updatedByRecruiterId_fkey N
CandidateWorkArrangements.createdByRecruiterId CandidateWorkArrangements_createdByRecruiterId_fkey N
CandidateWorkArrangements.updatedByRecruiterId CandidateWorkArrangements_updatedByRecruiterId_fkey N
CandidateWorkExperiences.createdByRecruiterId CandidateWorkExperiences_createdByRecruiterId_fkey N
CandidateWorkExperiences.updatedByRecruiterId CandidateWorkExperiences_updatedByRecruiterId_fkey N
JobOrderCandidates.assignedToRecruiterId JobOrderCandidates_assignedToRecruiterId_fkey N
JobOrderCandidates.createdByRecruiterId JobOrderCandidates_createdByRecruiterId_fkey N
JobOrderCandidates.updatedByRecruiterId JobOrderCandidates_updatedByRecruiterId_fkey N
TalentConsultantNotifications.recruiterId TalentConsultantNotifications_recruiterId_fkey C
Candidacies.recruiterId Candidacies_recruiterId_fkey R
CandidacyComments.createdByRecruiterId CandidacyComments_createdByRecruiterId_fkey R
CandidacyHandovereds.recruiterId CandidacyHandovereds_recruiterId_fkey C
CandidacyHireds.recruiterId CandidacyHireds_recruiterId_fkey R
CandidacyOffereds.recruiterId CandidacyOffereds_recruiterId_fkey R
CandidacyRecommendeds.recruiterId CandidacyRecommendeds_recruiterId_fkey R
CandidacySelectionHappeneds.recruiterId CandidacySelectionHappeneds_recruiterId_fkey R
CandidacySelectionScheduleds.recruiterId CandidacySelectionScheduleds_recruiterId_fkey R
CandidacySourceds.recruiterId CandidacySourceds_recruiterId_fkey R
CandidacyUnsuiteds.recruiterId CandidacyUnsuiteds_recruiterId_fkey R
JobOrderAssignmentTags.recruiterId JobOrderAssignments_recruiterId_fkey C
JobOrderChangeLogs.recruiterId JobOrderChangeLogs_recruiterId_fkey C
JobOrderCloseds.createdByRecruiterId JobOrderCloseds_createdByRecruiterId_fkey R
JobOrderDeprioritizeds.createdByRecruiterId JobOrderDeprioritizeds_createdByRecruiterId_fkey R
JobOrderFiles.createdByRecruiterId JobOrderFiles_createdByRecruiterId_fkey N
JobOrderFiles.updatedByRecruiterId JobOrderFiles_updatedByRecruiterId_fkey N
JobOrderForecast.createdByRecruiterId JobOrderForecast_createdByRecruiterId_fkey N
JobOrderForecast.updatedByRecruiterId JobOrderForecast_updatedByRecruiterId_fkey N
JobOrderForecastReview.createdByRecruiterId JobOrderForecastReview_createdByRecruiterId_fkey N
JobOrderForecastReview.updatedByRecruiterId JobOrderForecastReview_updatedByRecruiterId_fkey N
JobOrderPrioritizeds.createdByRecruiterId JobOrderPrioritizeds_createdByRecruiterId_fkey R
JobOrderReopeneds.createdByRecruiterId JobOrderReopeneds_createdByRecruiterId_fkey R
JobOrders.createdByRecruiterId JobOrders_createdByRecruiterId_fkey R
JobOrders.inChargedRecruiterId JobOrders_inChargedRecruiterId_fkey R
JobOrders.recruitmentConsultantId JobOrders_recruitmentConsultantId_fkey N
RecruiterSavedTalentCollections.recruiterId Recruiters_recruiterId_fkey C
RecruiterSavedTalents.recruiterId Recruiters_recruiterId_fkey C
ReportingGroups.createdBy ReportingGroups_createdBy_fkey R
SupersourceRejecteds.createdByRecruiterId SupersourceRejecteds_createdByRecruiterId_fkey R
SupersourceSaveds.createdByRecruiterId SupersourceSaveds_createdByRecruiterId_fkey R

Primary key.
isAdmin bool 1 false

Is recruiter an admin.
onboardingPhase int4 10 0

Onboarding phase of recruiter.
createdAt timestamptz 35,6 now()

Time of creation.
updatedAt timestamptz 35,6 now()

Time of last update.
businessUnitRecruiterId uuid 2147483647 √ null
BusinessUnitRecruiters.id Recruiters_businessUnitRecruiterId_fkey R
teamRecruiterId uuid 2147483647 √ null
TeamRecruiters.id Recruiters_teamRecruiterId_fkey R
fullName text 2147483647 √ null
displayName text 2147483647 √ null
jobTitle text 2147483647 √ null
userId uuid 2147483647 null
Users.id Recruiters_userId_fkey R
deletedAt timestamptz 35,6 √ null
savedConfig jsonb 2147483647 √ null
profilePicUrl varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
Recruiters_pkey Primary key Asc id
Recruiters_businessUnitRecruiterId_key Must be unique Asc businessUnitRecruiterId
Recruiters_deletedAt_id_idx Performance Asc/Asc deletedAt + id
Recruiters_teamRecruiterId_key Must be unique Asc teamRecruiterId
Recruiters_userId_key Must be unique Asc userId

Check Constraints

Constraint Name Constraint
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)))))

Relationships

Close relationships within degrees of separation