CandidateWorkExperiences


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
CandidateWorkExperienceSkills.candidateWorkExperienceId CandidateWorkExperienceSkills_candidateWorkExperienceId_fkey R
candidateId uuid 2147483647 null
Candidates.id CandidateWorkExperiences_candidateId_fkey C
title varchar 255 null
startDate timestamptz 35,6 √ null
endDate timestamptz 35,6 √ null
isPresent bool 1 false
companyName varchar 255 √ null
description text 2147483647 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateWorkExperiences_createdByRecruiterId_fkey N
updatedByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateWorkExperiences_updatedByRecruiterId_fkey N
hierarchicalJobCategoryId uuid 2147483647 √ null
HierarchicalJobCategories.id CandidateWorkExperiences_hierarchicalJobCategoryId_fkey N
industryId int4 10 √ null
IndustriesV2.id CandidateWorkExperiences_industryId_fkey N
inferredHJCId uuid 2147483647 √ null
HierarchicalJobCategories.id fk_inferredhjcid N
inferredHJCScore float4 8,8 √ null
hasInferredHJC bool 1 false

To indicate that it has gone through the HJC inference process

Indexes

Constraint Name Type Sort Column(s)
CandidateWorkExperiences_pkey Primary key Asc id
CandidateWorkExperiences_candidateId_idx Performance Asc candidateId
CandidateWorkExperiences_createdAt_id_idx Performance Asc/Asc createdAt + id
glints_match_CandidateWorkExperiences_inferredHJCId_idx Performance Asc inferredHJCId

Relationships

Close relationships within degrees of separation