Comp Type Table Schema (comp_type)


Description

Competency types are used to manage custom fields

comp_type table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
comp.typeid comp_typ2_fk R
comp_type_info_field.typeid comptypeinfofiel_typ2_fk R
shortname VARCHAR 100 null
description LONGTEXT 2147483647 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
fullname VARCHAR 1024 null
idnumber VARCHAR 100 null

Table contained -1 rows

comp_type table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
comptype_idn_ix Performance Asc idnumber

comp_type table relationships