CandidateSkills


Columns

Column Type Size Nulls Auto Default Children Parents Comments
candidateId uuid 2147483647 null
Candidates.id CandidateSkills_candidateId_fkey C
skillId uuid 2147483647 null
Skills.id CandidateSkills_skillId_fkey C
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
yearsOfExperience int4 10 √ null
id uuid 2147483647 gen_random_uuid()
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateSkills_createdByRecruiterId_fkey N
updatedByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateSkills_updatedByRecruiterId_fkey N

Indexes

Constraint Name Type Sort Column(s)
CandidateSkills_pkey Primary key Asc id
CandidateSkills_candidateId_skillId_idx Must be unique Asc/Asc candidateId + skillId
CandidateSkills_candidateId_yearsOfExperience_not_null_idx Performance Asc candidateId
CandidateSkills_candidateId_yearsOfExperience_null_idx Performance Asc candidateId

Relationships

Close relationships within degrees of separation