CandidateNotes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
CandidateNoteJobOrders.candidateNoteId CandidateNoteJobOrders_candidateNoteId_fkey C
candidateId uuid 2147483647 null
Candidates.id CandidateNotes_candidateId_fkey C
content text 2147483647 null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
deletedAt timestamptz 35,6 √ null
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateNotes_createdByRecruiterId_fkey N
updatedByRecruiterId uuid 2147483647 √ null
Recruiters.id CandidateNotes_updatedByRecruiterId_fkey N

Indexes

Constraint Name Type Sort Column(s)
CandidateNotes_pkey Primary key Asc id
CandidateNotes_candidateId_createdAt_idx Performance Asc/Asc candidateId + createdAt

Relationships

Close relationships within degrees of separation