CandidatePreferredJobCategories


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
candidateId uuid 2147483647 null
Candidates.id CandidatePreferredJobCategories_candidateId_fkey C
hierarchicalJobCategoryId uuid 2147483647 null
HierarchicalJobCategories.id CandidatePreferredJobCategories_hierarchicalJobCategoryId_fkey C
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidatePreferredJobCategories_createdByRecruiterId_fkey R
updatedByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidatePreferredJobCategories_updatedByRecruiterId_fkey R

Indexes

Constraint Name Type Sort Column(s)
CandidatePreferredJobCategories_pkey Primary key Asc id
CandidatePreferredJobCategories_candidateId_hjcId_idx Must be unique Asc/Asc candidateId + hierarchicalJobCategoryId

Relationships

Close relationships within degrees of separation