Comp Template Table Schema (comp_template)


Description

A template is used to group competencies

comp_template table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
comp_template_assignment.templateid comptempassi_tem2_fk R
frameworkid BIGINT 19 null
comp_framework.id comptemp_fra2_fk R
fullname LONGTEXT 2147483647 null
shortname VARCHAR 100 √ null
description LONGTEXT 2147483647 √ null
visible TINYINT 3 null
competencycount BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null

Table contained -1 rows

comp_template table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
comptemp_fra_ix Performance Asc frameworkid

comp_template table relationships

Close relationships within degrees of separation