InferredCandidateWorkExperienceSkills


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
inferredCandidateWorkExperienceId uuid 2147483647 null
InferredCandidateWorkExperiences.id InferredCandidateWorkExperien_inferredCandidateWorkExperie_fkey C
skillText text 2147483647 null
skillId uuid 2147483647 √ null
Skills.id InferredCandidateWorkExperienceSkills_skillId_fkey N
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
skillInferenceScore float4 8,8 √ null
normalizedSkillId uuid 2147483647 √ null
NormalizedSkills.id InferredCandidateWorkExperienceSkills_normalizedSkillId_fkey N
normalizedSkillInferenceScore float4 8,8 √ null

Indexes

Constraint Name Type Sort Column(s)
InferredCandidateWorkExperienceSkills_pkey Primary key Asc id
InferredCandidateWorkExperienceSkills_inferredCandidateWorkExpe Performance Asc inferredCandidateWorkExperienceId
InferredCandidateWorkExperienceSkills_skillId_idx Performance Asc skillId

Relationships

Close relationships within degrees of separation