Table JiveCore700.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
jivefieldoption.fieldid jfo_fid_fk 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

Analyzed at Fri Dec 20 10:31 PST 2013

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: