JobOrderCandidates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
RejectedJobOrderCandidates.jobOrderCandidateId RejectedJobOrderCandidates_jobOrderCandidateId_fkey C
ShortlistedJobOrderCandidates.jobOrderCandidateId ShortlistedJobOrderCandidates_jobOrderCandidateId_fkey C
candidateId uuid 2147483647 null
Candidates.id JobOrderCandidates_candidateId_fkey C
jobOrderId uuid 2147483647 null
JobOrders.id JobOrderCandidates_jobOrderId_fkey C
status "glints_match"."enum_JobOrderCandidate_status" 2147483647 'RC_TO_REVIEW'::glints_match."enum_JobOrderCandidate_status"
expectedCost numeric 12,3 √ null
highlight text 2147483647 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
source "glints_match"."enum_JobOrderCandidate_source" 2147483647 'RECRUITER_SOURCED'::glints_match."enum_JobOrderCandidate_source"
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id JobOrderCandidates_createdByRecruiterId_fkey N
updatedByRecruiterId uuid 2147483647 √ null
Recruiters.id JobOrderCandidates_updatedByRecruiterId_fkey N
assignedToRecruiterId uuid 2147483647 √ null
Recruiters.id JobOrderCandidates_assignedToRecruiterId_fkey N

Indexes

Constraint Name Type Sort Column(s)
JobOrderCandidates_pkey Primary key Asc id
JobOrderCandidates_candidateId Performance Asc candidateId
JobOrderCandidates_candidateId_jobOrderId_key Must be unique Asc/Asc candidateId + jobOrderId
JobOrderCandidates_jobOrderId Performance Asc jobOrderId
JobOrderCandidates_status Performance Asc status

Relationships

Close relationships within degrees of separation