Pos Competencies Table Schema (pos_competencies)


Description

Tracks competencies assigned to a particular position

pos_competencies table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
positionid BIGINT 19 null
pos.id poscomp_pos2_fk R
competencyid BIGINT 19 √ null
comp.id poscomp_com2_fk R
templateid BIGINT 19 √ null
timecreated BIGINT 19 null
usermodified BIGINT 19 null
linktype TINYINT 3 0

Table contained -1 rows

pos_competencies table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
poscomp_com_ix Performance Asc competencyid
poscomp_pos_ix Performance Asc positionid

pos_competencies table relationships

Close relationships within degrees of separation