Comp Template Assignment Table Schema (comp_template_assignment)


Description

Track competencies belonging to a template

comp_template_assignment table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
templateid BIGINT 19 null
comp_template.id comptempassi_tem2_fk R
type TINYINT 3 null
instanceid BIGINT 19 null
comp.id comptempassi_ins2_fk R
timecreated BIGINT 19 null
usermodified BIGINT 19 null
user.id comptempassi_use2_fk R

Table contained -1 rows

comp_template_assignment table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
comptempassi_ins_ix Performance Asc instanceid
comptempassi_tem_ix Performance Asc templateid
comptempassi_use_ix Performance Asc usermodified

comp_template_assignment table relationships

Close relationships within degrees of separation