Table JiveCore800.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

Analyzed at Mon Apr 27 15:32 PDT 2015

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: