InferredCandidates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
Candidates.inferredCandidateId Candidates_inferredCandidateId_fkey N
InferredCandidateLanguages.inferredCandidateId InferredCandidateLanguages_inferredCandidateId_fkey C
InferredCandidateSkills.inferredCandidateId InferredCandidateSkills_inferredCandidateId_fkey C
InferredCandidateWorkExperiences.inferredCandidateId InferredCandidateWorkExperiences_inferredCandidateId_fkey C
candidateId uuid 2147483647 null
Candidates.id InferredCandidates_candidateId_fkey C
name text 2147483647 √ null
CampaignConfigs.name Implied Constraint R
rawEmail text 2147483647 √ null
rawPhoneNumber text 2147483647 √ null
rawBirthYear text 2147483647 √ null
rawGender text 2147483647 √ null
rawCountry text 2147483647 √ null
rawCity text 2147483647 √ null
rawLinkedInUrl text 2147483647 √ null
rawGithubUrl text 2147483647 √ null
email text 2147483647 √ null
phoneCallingCode varchar 10 √ null
phoneNumber text 2147483647 √ null
birthYear int4 10 √ null
gender "glints_match"."enum_Candidates_gender" 2147483647 √ null
countryCode varchar 255 √ null
Countries.code InferredCandidates_countryCode_fkey N
locationId uuid 2147483647 √ null
Locations.id InferredCandidates_locationId_fkey N
cityId int4 10 √ null
Cities.id InferredCandidates_cityId_fkey N
linkedInUrl text 2147483647 √ null
githubUrl text 2147483647 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
inferredGender "glints_match"."enum_Candidates_gender" 2147483647 √ null
parseResumeId uuid 2147483647 √ null
ParsedResumes.id InferredCandidates_parseResumeId_fkey N

Indexes

Constraint Name Type Sort Column(s)
InferredCandidates_pkey Primary key Asc id
glints_match_InferredCandidates_candidateId_index Performance Asc candidateId

Relationships

Close relationships within degrees of separation