app_org_type

0 rows


Description

Organisation types are used to manage custom fields

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_org_type_id_seq'::regclass)
app_org.typeid Defined in XMLR
app_org_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_orgtype_id_pk Primary key Asc id
app_orgtype_idn_ix Performance Asc idnumber

Relationships