Comp Scale Table Schema (comp_scale)


Description

Competency scale represents the different levels of achievement of a competency

comp_scale table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
comp_scale_assignments.scaleid compscalassi_sca2_fk R
comp_scale_values.scaleid compscalvalu_sca2_fk R
name VARCHAR 255 √ null
description LONGTEXT 2147483647 √ null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
defaultid BIGINT 19 √ null
comp_scale_values.id compscal_def2_fk R

Table contained -1 rows

comp_scale table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
compscal_def_ix Performance Asc defaultid

comp_scale table relationships

Close relationships within degrees of separation