Candidates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
CandidateActivenessStatusLogs.candidateId CandidateActivenessStatusLogs_candidateId_fkey C
CandidateFiles.candidateId CandidateFiles_candidateId_fkey C
CandidateJobCategoryPreferences.candidateId CandidateJobCategoryPreferences_candidateId_fkey C
CandidateLanguages.candidateId CandidateLanguages_candidateId_fkey C
CandidateLocationPreferences.candidateId CandidateLocationPreferences_candidateId_fkey C
CandidateNotes.candidateId CandidateNotes_candidateId_fkey C
CandidatePreferredJobCategories.candidateId CandidatePreferredJobCategories_candidateId_fkey C
CandidateRelocations.candidateId CandidateRelocations_candidateId_fkey C
CandidateRespondIoSyncMismatch.candidateId CandidateRespondIoSyncMismatch_candidateId_fkey C
CandidateSkills.candidateId CandidateSkills_candidateId_fkey C
CandidateWorkArrangements.candidateId CandidateWorkArrangements_candidateId_fkey C
CandidateWorkExperiences.candidateId CandidateWorkExperiences_candidateId_fkey C
InferredCandidateLanguages.candidateId InferredCandidateLanguages_candidateId_fkey C
InferredCandidates.candidateId InferredCandidates_candidateId_fkey C
JobOrderCandidates.candidateId JobOrderCandidates_candidateId_fkey C
ParsedResumes.candidateId ParsedResumes_candidateId_fkey C
ScheduledEvents.candidateId ScheduledEvents_candidateId_fkey N
TalentCampaigns.candidateId TalentCampaigns_candidateId_fkey N
TalentConsultantNotifications.candidateId TalentConsultantNotifications_candidateId_fkey C
UnifiedTalentProfiles.candidateId UnifiedTalentProfiles_candidateId_fkey C
RecruiterSavedTalents.candidateId RecruiterSavedTalents_candidateId_fkey C
email text 2147483647 √ null
name text 2147483647 √ null
CampaignConfigs.name Implied Constraint R
phoneCallingCode varchar 10 √ null
phoneNumber text 2147483647 √ null
yearsOfExperience int4 10 √ null
expectedSalaryCurrencyCode varchar 255 √ null
Currencies.code Candidates_expectedSalaryCurrencyCode_fkey N
expectedMonthlyGrossSalary numeric 12,3 √ null
locationId uuid 2147483647 √ null
Locations.id Candidates_locationId_fkey N
countryCode varchar 255 √ null
Countries.code Candidates_countryCode_fkey N
cityId int4 10 √ null
Cities.id Candidates_cityId_fkey N
hasConsentToCommunications bool 1 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
profilePic varchar 255 √ null
resume varchar 255 √ null
activenessStatus "glints_match"."enum_candidate_activenessStatus" 2147483647 √ null
noticePeriodInWeeks int4 10 √ null
currentSalaryCurrencyCode varchar 255 √ null
Currencies.code Candidates_currentSalaryCurrencyCode_fkey N
currentMonthlyGrossSalary numeric 12,3 √ null
isConfirmationSent bool 1 false
profileSource "glints_match"."enum_profileSource" 2147483647 'GLINTS_MATCH_2'::glints_match."enum_profileSource"

Default value indicates the current version of GlintsMatch
originalResumeName varchar 255 √ null

Resume name as uploaded by the user
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id Candidates_createdByRecruiterId_fkey N
updatedByRecruiterId uuid 2147483647 √ null
Recruiters.id Candidates_updatedByRecruiterId_fkey N
linkedInUrl text 2147483647 √ null
portfolioUrl text 2147483647 √ null
resumeText text 2147483647 √ null
gender "glints_match"."enum_Candidates_gender" 2147483647 √ null
resumeId uuid 2147483647 √ null
CandidateFiles.id Candidates_resumeId_fkey N
inferredGender "glints_match"."enum_Candidates_gender" 2147483647 √ null
activenessStatusLogId uuid 2147483647 √ null
CandidateActivenessStatusLogs.id Candidates_activenessStatusLogId_fkey N
lastContactedId uuid 2147483647 √ null
RecruiterSavedTalentStatusLogs.id Candidates_lastContactedId_fkey N
isInteractedByRecruiter bool 1 true
parseResumeId uuid 2147483647 √ null
ParsedResumes.id Candidates_parseResumeId_fkey N
metadata jsonb 2147483647 √ json_build_object('email', now(), 'name', now(), 'phoneCallingCode', now(), 'phoneNumber', now(), 'yearsOfExperience', now(), 'expectedSalaryCurrencyCode', now(), 'expectedMonthlyGrossSalary', now(), 'locationId', now(), 'countryCode', now(), 'cityId', now(), 'noticePeriodInWeeks', now(), 'linkedInUrl', now(), 'portfolioUrl', now(), 'gender', now())
inferredCandidateId uuid 2147483647 √ null
InferredCandidates.id Candidates_inferredCandidateId_fkey N

Indexes

Constraint Name Type Sort Column(s)
Candidates_pkey Primary key Asc id
Candidates_activenessStatus Performance Asc activenessStatus
Candidates_email_key Must be unique Asc email
glints_match_Candidates_inferredCandidateId_index Must be unique Asc inferredCandidateId

Relationships

Close relationships within degrees of separation