JobSkillDrafts


Description

Joined Table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 public.gen_random_uuid()

Primary Key.

createdAt timestamptz 35,6 null

Entry creation date

updatedAt timestamptz 35,6 null

Datetime of last modification to any attribute

JobDraftId uuid 2147483647 null
JobDrafts.id JobSkillDrafts_JobDraftId_fkey C

Foreign Key to JobDraft Table.

SkillId uuid 2147483647 null
Skills.id JobSkillDrafts_SkillId_fkey C

Foreign Key to Skill Table.

mustHave bool 1 true

Set to true if the skill is a must have for the given job

Indexes

Constraint Name Type Sort Column(s)
JobSkillDrafts_pkey Primary key Asc id
JobSkillDrafts_JobDraftId_SkillId_key Must be unique Asc/Asc JobDraftId + SkillId

Relationships