0 rows


Stores the custom fields for each competency type


Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_comp_type_info_field_id_seq'::regclass)
shortname varchar 100 null
typeid int8 19 null
datatype varchar 255 null
description text 2147483647 null
sortorder int8 19 null
hidden int2 5 null
locked int2 5 null
required int2 5 null
forceunique int2 5 null
defaultdata text 2147483647 null
param1 text 2147483647 null
param2 text 2147483647 null
param3 text 2147483647 null
param4 text 2147483647 null
param5 text 2147483647 null
fullname varchar 1024 null
categoryid int8 19 null


Constraint Name Type Sort Column(s)
app_comptypeinfofiel_id_pk Primary key Asc id

Diagram producer might be missing

No diagrams were produced please see application output for any errors