CandidacyHandovereds


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
candidacyId uuid 2147483647 null
Candidacies.id CandidacyHandovereds_candidacyId_fkey C

The candidacy id
recruiterId uuid 2147483647 null
Recruiters.id CandidacyHandovereds_recruiterId_fkey C

The new recruiter of the candidacy
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
deletedAt timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
CandidacyHandovers_pkey Primary key Asc id
CandidacyHandovereds_candidacyId_deletedAt_unique_idx Must be unique Asc candidacyId
CandidacyHandovereds_candidacyId_idx Performance Asc candidacyId
CandidacyHandovereds_recruiterId_idx Performance Asc recruiterId

Relationships

Close relationships within degrees of separation