JobOrderSkills


Columns

Column Type Size Nulls Auto Default Children Parents Comments
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
skillId uuid 2147483647 null
Skills.id JobOrderSkills_skillId_fkey C

Foreign key to Skills table
jobOrderId uuid 2147483647 null
JobOrders.id JobOrderSkills_jobOrderId_fkey C

Foreign key to superpowered.JobOrder table
mustHave bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
JobOrderSkills_pkey Primary key Asc/Asc skillId + jobOrderId
superpowered_JobOrderSkills_jobOrderId_idx Performance Asc jobOrderId
superpowered_JobOrderSkills_skillId_idx Performance Asc skillId

Relationships

Close relationships within degrees of separation