JobOrderDeprioritizeds


Description

This table stores the details of which a job is deprioritized

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
JobOrderDeprioritizedReasons.jobOrderDeprioritizedId JobOrderDeprioritizedReasons_jobOrderDeprioritizedId_fkey C
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
jobOrderId uuid 2147483647 null
JobOrders.id JobOrderDeprioritizeds_jobOrderId_fkey C
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id JobOrderDeprioritizeds_createdByRecruiterId_fkey R

Recruiter id that deprioritized the job

Indexes

Constraint Name Type Sort Column(s)
JobOrderDeprioritizeds_pkey Primary key Asc id
JobOrderDeprioritizeds_createdAt_idx Performance Asc createdAt
JobOrderDeprioritizeds_createdByRecruiterId_idx Performance Asc createdByRecruiterId
JobOrderDeprioritizeds_jobOrderId_idx Performance Asc jobOrderId

Relationships

Close relationships within degrees of separation