TalentConsultantNotifications


Description

Store internal recruiter notifications for jobOrders and candidates

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
recruiterId uuid 2147483647 null
Recruiters.id TalentConsultantNotifications_recruiterId_fkey C
jobOrderId uuid 2147483647 null
JobOrders.id TalentConsultantNotifications_jobOrderId_fkey C
candidateId uuid 2147483647 null
Candidates.id TalentConsultantNotifications_candidateId_fkey C
addedToJobOrderStatus "glints_match"."enum_TalentConsultantNotification_addedToJobOrderStatus" 2147483647 √ null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
TalentConsultantNotifications_pkey Primary key Asc id
TalentConsultantNotifications_createdAt_addedToJobOrderStatus_i Performance Desc createdAt

Relationships

Close relationships within degrees of separation