app_comp_type

0 rows


Description

Competency types are used to manage custom fields

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_comp_type_id_seq'::regclass)
app_comp.typeid Defined in XMLR
app_comp_type_info_field.typeid Defined in XMLR
shortname varchar 100 √ null
description text 2147483647 √ null
timecreated int8 19 null
timemodified int8 19 null
usermodified int8 19 null
fullname varchar 1024 √ null
idnumber varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
app_comptype_id_pk Primary key Asc id
app_comptype_idn_ix Performance Asc idnumber

Relationships

Close relationships within degrees of separation