CandidateRelocations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
candidateId uuid 2147483647 null
Candidates.id CandidateRelocations_candidateId_fkey C
relocationCityId uuid 2147483647 null
RelocationCities.id CandidateRelocations_relocationCityId_fkey C
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateRelocations_createdByRecruiterId_fkey R
updatedByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateRelocations_updatedByRecruiterId_fkey R
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
CandidateRelocations_pkey Primary key Asc id
CandidateRelocations_candidateId_relocationCityId_idx Must be unique Asc/Asc candidateId + relocationCityId

Relationships

Close relationships within degrees of separation