JobOrderJobTitles


Columns

Column Type Size Nulls Auto Default Children Parents Comments
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
jobTitleId int4 10 √ null
JobTitles.id JobOrderJobTitles_jobTitleId_fkey C
jobOrderId uuid 2147483647 null
JobOrders.id JobOrderJobTitles_jobOrderId_fkey C
hierarchicalJobCategoryId uuid 2147483647 √ null
HierarchicalJobCategories.id JobOrderJobTitles_hierarchicalJobCategoryId_fkey C
id uuid 2147483647 gen_random_uuid()

Indexes

Constraint Name Type Sort Column(s)
JobOrderJobTitles_pkey Primary key Asc id
JobOrderJobTitles_jobOrderId_idx Performance Asc jobOrderId
JobOrderJobTitles_jobTitleId_idx Performance Asc jobTitleId

Relationships

Close relationships within degrees of separation