CandidateLocationPreferences


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
candidateId uuid 2147483647 null
Candidates.id CandidateLocationPreferences_candidateId_fkey C
locationId uuid 2147483647 √ null
Locations.id CandidateLocationPreferences_locationId_fkey N
countryCode varchar 255 √ null
Countries.code CandidateLocationPreferences_countryCode_fkey N
cityId int4 10 √ null
Cities.id CandidateLocationPreferences_cityId_fkey N
needsVisa bool 1 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateLocationPreferences_createdByRecruiterId_fkey N
updatedByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateLocationPreferences_updatedByRecruiterId_fkey N

Indexes

Constraint Name Type Sort Column(s)
CandidateLocationPreferences_pkey Primary key Asc id
CandidateLocationPreferences_candidateId Performance Asc candidateId
CandidateLocationPreferences_locationId Performance Asc locationId

Relationships

Close relationships within degrees of separation