Table JiveCore900.public.jivefieldtype Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
fieldtypeid int8 19
jivefield.fieldtypeid jivefield_ftype_fk R
jivefieldfrmtprop.fieldtypeid jffprp_ftid_fk R
jivefieldvldtrprop.fieldtypeid jfvprp_frid_fk R
name varchar 20
displayname varchar 100
description varchar 1000  √  null
datatypeid int8 19
jivedatatype.datatypeid jft_dtid_fk R
formatter varchar 255  √  null
validator varchar 255  √  null
modifiable int4 10

Table contained 11 rows at Fri Jan 13 13:20 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
fieldtypeid Primary key Asc jivefieldtype_pk
displayname Must be unique Asc jivefieldtype_displayname_key
name Must be unique Asc jivefieldtype_name_key

Close relationships  within of separation: