app_org_type

0 rows

Description

Organisation types are used to manage custom fields

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

bigserial

19

√

nextval('app_org_type_id_seq'::regclass)

app_org.typeid	Defined in XML	R
app_org_type_info_field.typeid	Defined in XML	R

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

Showing 1 to 8 of 8 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
app_orgtype_id_pk	Primary key	Asc	id
app_orgtype_idn_ix	Performance	Asc	idnumber

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees