CandidateWorkExperienceSkills


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
candidateWorkExperienceId uuid 2147483647 null
CandidateWorkExperiences.id CandidateWorkExperienceSkills_candidateWorkExperienceId_fkey R
skillId uuid 2147483647 null
Skills.id CandidateWorkExperienceSkills_skillId_fkey N
skillInferenceScore float4 8,8 √ null
normalizedSkillId uuid 2147483647 √ null
NormalizedSkills.id CandidateWorkExperienceSkills_normalizedSkillId_fkey N
normalizedSkillInferenceScore float4 8,8 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
CandidateWorkExperienceSkills_pkey Primary key Asc id
glints_match_CandidateWorkExperienceSkills_candidateWorkExperie Performance Asc candidateWorkExperienceId
glints_match_CandidateWorkExperienceSkills_normalizedSkillId_id Performance Asc normalizedSkillId
glints_match_CandidateWorkExperienceSkills_skillId_idx Performance Asc skillId

Relationships

Close relationships within degrees of separation