JobOrderCloseds


Description

This table stores the details of which a job is closed

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()
JobOrderClosedReasons.jobOrderClosedId JobOrderClosedReasons_jobOrderClosedId_fkey C
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
jobOrderId uuid 2147483647 null
JobOrders.id JobOrderCloseds_jobOrderId_fkey C
createdByRecruiterId uuid 2147483647 √ null
Recruiters.id JobOrderCloseds_createdByRecruiterId_fkey R

Recruiter id that closed the job

Indexes

Constraint Name Type Sort Column(s)
JobOrderCloseds_pkey Primary key Asc id
JobOrderCloseds_createdAt_idx Performance Asc createdAt
JobOrderCloseds_createdByRecruiterId_idx Performance Asc createdByRecruiterId
JobOrderCloseds_jobOrderId_idx Performance Asc jobOrderId

Relationships

Close relationships within degrees of separation