CandidateJobCategoryPreferences


Columns

Column Type Size Nulls Auto Default Children Parents Comments
candidateId uuid 2147483647 null
Candidates.id CandidateJobCategoryPreferences_candidateId_fkey C
hierarchicalJobCategoryId uuid 2147483647 null
HierarchicalJobCategories.id CandidateJobCategoryPreferences_hierarchicalJobCategoryId_fkey C
yearsOfExperience int4 10 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
id uuid 2147483647 gen_random_uuid()
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateJobCategoryPreferences_createdByRecruiterId_fkey N
updatedByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateJobCategoryPreferences_updatedByRecruiterId_fkey N

Indexes

Constraint Name Type Sort Column(s)
CandidateJobCategoryPreferences_pkey Primary key Asc id
CandidateJobCategoryPreferences_candidateId Performance Asc candidateId
CandidateJobCategoryPreferences_candidateId_hierarchicalJobCate Must be unique Asc/Asc candidateId + hierarchicalJobCategoryId
CandidateJobCategoryPreferences_hierarchicalJobCategoryId Performance Asc hierarchicalJobCategoryId

Relationships

Close relationships within degrees of separation