InferredCandidateSkills


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
inferredCandidateId uuid 2147483647 null
InferredCandidates.id InferredCandidateSkills_inferredCandidateId_fkey C
skillText text 2147483647 null
skillId uuid 2147483647 √ null
Skills.id InferredCandidateSkills_skillId_fkey N
skillInferenceScore float4 8,8 √ null
normalizedSkillId uuid 2147483647 √ null
NormalizedSkills.id InferredCandidateSkills_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)
InferredCandidateSkills_pkey Primary key Asc id
InferredCandidateSkills_inferredCandidateId_skillText Must be unique Asc/Asc inferredCandidateId + skillText

Relationships

Close relationships within degrees of separation