JobOrderPrioritizeds


Description

This table stores the details of which a job is prioritized

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
JobOrderPrioritizedReasons.jobOrderPrioritizedId JobOrderPrioritizedReasons_jobOrderPrioritizedId_fkey C
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
jobOrderId uuid 2147483647 null
JobOrders.id JobOrderPrioritizeds_jobOrderId_fkey C
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id JobOrderPrioritizeds_createdByRecruiterId_fkey R

Recruiter id that prioritized the job

Indexes

Constraint Name Type Sort Column(s)
JobOrderPrioritizeds_pkey Primary key Asc id
JobOrderPrioritizeds_createdAt_idx Performance Asc createdAt
JobOrderPrioritizeds_createdByRecruiterId_idx Performance Asc createdByRecruiterId
JobOrderPrioritizeds_jobOrderId_idx Performance Asc jobOrderId

Relationships

Close relationships within degrees of separation