Skills


Description

Skills.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
CandidateSkills.skillId CandidateSkills_skillId_fkey C
CandidateWorkExperienceSkills.skillId CandidateWorkExperienceSkills_skillId_fkey N
InferredCandidateSkills.skillId InferredCandidateSkills_skillId_fkey N
InferredCandidateWorkExperienceSkills.skillId InferredCandidateWorkExperienceSkills_skillId_fkey N
ExpertClassSkills.SkillId EventSkills_SkillId_fkey C
JobCategorySkills.SkillId JobCategorySkills_SkillId_fkey C
JobRoleSkills.SkillId JobRoleSkills_SkillId_fkey C
JobSkillDrafts.SkillId JobSkillDrafts_SkillId_fkey C
JobSkills.SkillId JobSkills_SkillId_fkey C
JobTitleSkills.SkillId JobTitleSkills_SkillId_fkey C
NormalizedSkillsMapping.SkillId NormalizedSkillsMapping_SkillId_fkey R
UserSkills.SkillId UserSkills_SkillId_fkey C
JobOrderSkills.skillId JobOrderSkills_skillId_fkey C

Primary Key.
name varchar 255 √ null

Name of Skill.
createdAt timestamptz 35,6 null

Entry creation date
updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute
popularity int8 19 0
flagRecount bool 1 false
isNormalized bool 1 √ false
translationKey varchar 255 √ null
isCustom bool 1 false

Boolean to signify if it is a custom skill added by a user

Indexes

Constraint Name Type Sort Column(s)
Skills_pkey Primary key Asc id
Skills_name_idx Performance Asc name
Skills_name_trgm_idx Performance Asc name

Relationships

Close relationships within degrees of separation