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

Close relationships within degrees of separation