CandidateLanguages


Columns

Column Type Size Nulls Auto Default Children Parents Comments
candidateId uuid 2147483647 null
Candidates.id CandidateLanguages_candidateId_fkey C
languageCode text 2147483647 null
Languages.code CandidateLanguages_languageCode_fkey C
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
id uuid 2147483647 gen_random_uuid()
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateLanguages_createdByRecruiterId_fkey N
updatedByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateLanguages_updatedByRecruiterId_fkey N

Indexes

Constraint Name Type Sort Column(s)
CandidateLanguages_pkey Primary key Asc id
CandidateLanguages_candidateId Performance Asc candidateId
CandidateLanguages_candidateId_languageCode_idx Must be unique Asc/Asc candidateId + languageCode
CandidateLanguages_languageCode Performance Asc languageCode

Relationships

Close relationships within degrees of separation