Comp Framework Table Schema (comp_framework)


Description

A collection of competencies that use a common competency scale

comp_framework table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
comp.frameworkid comp_fra2_fk R
comp_scale_assignments.frameworkid compscalassi_fra2_fk R
comp_template.frameworkid comptemp_fra2_fk R
shortname VARCHAR 100 √ null
idnumber VARCHAR 100 √ null
description LONGTEXT 2147483647 √ null
sortorder BIGINT 19 null
visible TINYINT 3 null
hidecustomfields TINYINT 3 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
fullname VARCHAR 1024

Table contained -1 rows

comp_framework table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compfram_sor_uix Must be unique Asc sortorder

comp_framework table relationships

Close relationships within degrees of separation