SupersourceRejecteds


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
SupersourceRejectedReasons.supersourceRejectedId SupersourceRejectedReasons_supersourceRejectedId_fkey C
jobOrderId uuid 2147483647 null
JobOrders.id SupersourceRejecteds_jobOrderId_fkey C
mergedTalentProfileId uuid 2147483647 null
MergedTalentProfiles.id SupersourceRejecteds_mergedTalentProfileId_fkey R
createdByRecruiterId uuid 2147483647 null
Recruiters.id SupersourceRejecteds_createdByRecruiterId_fkey R

Recruiter id who rejects this candidate
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
recommendationModelName text 2147483647 null

Expected model names to include TF and the rest to be in camelCase

Indexes

Constraint Name Type Sort Column(s)
SupersourceRejecteds_pkey Primary key Asc id
SupersourceRejecteds_createdByRecruiterId_idx Performance Asc createdByRecruiterId
SupersourceRejecteds_jobOrderId_idx Performance Asc jobOrderId
SupersourceRejecteds_mergedTalentProfileId_idx Performance Asc mergedTalentProfileId
SupersourceRejecteds_mergedTalentProfileId_jobOrderId_key Must be unique Asc/Asc mergedTalentProfileId + jobOrderId

Relationships

Close relationships within degrees of separation