Table JiveCore900.public.jivefield 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
fieldid int8 19
jivedocumentaudit.fieldid Implied Constraint R
jivefieldoption.fieldid jfo_fid_fk R
jivefieldvalue.fieldid Implied Constraint R
jiveideaextfield.fieldid Implied Constraint R
jiveideaextfieldvalue.fieldid Implied Constraint R
jiveideaextfldopt.fieldid Implied Constraint R
jiveprofilefield.fieldid Implied Constraint R
fieldtypeid int8 19
jivefieldtype.fieldtypeid jivefield_ftype_fk R
name varchar 100
displayname varchar 100
description varchar 1000  √  null
defvalue varchar 255  √  null
alterable int2 5
searchable int2 5
required int2 5
visible int2 5
filterable int2 5
maxsize int4 10
frowversion int8 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
fieldid Primary key Asc jivefield_pk
displayname Must be unique Asc jivefield_displayname_key
name Must be unique Asc jivefield_name_key

Close relationships  within of separation: