Org Competencies Table Schema (org_competencies)


Description

Track competencies assigned to a particular organisation

org_competencies table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
organisationid BIGINT 19 null
org.id orgcomp_org2_fk R
competencyid BIGINT 19 √ null
comp.id orgcomp_com2_fk R
templateid BIGINT 19 √ null
timecreated BIGINT 19 null
usermodified BIGINT 19 null
linktype TINYINT 3 0

Table contained -1 rows

org_competencies table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
orgcomp_com_ix Performance Asc competencyid
orgcomp_org_ix Performance Asc organisationid

org_competencies table relationships

Close relationships within degrees of separation