Table JiveCore800.public.jiveprofilefield 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
jivefield.fieldid Implied Constraint R
jivefieldvalue.fieldid Implied Constraint R
jiveprofilefldopt.fieldid jivepfo_fid_fk R
jiveprofilefldsec.fieldid jivepfsl_fid_fk R
jiveuserprofile.fieldid jiveup_fid_fk R
name varchar 255
jiveproperty.name Implied Constraint R
isrequired int2 5
isfilterable int2 5
issearchable int2 5
isvisibletousers int2 5
isvisibletoguests int2 5
iseditable int2 5
isshowsummarylabel int2 5 1
summaryindex int2 5 (-1)
fieldtype int4 10
idx int4 10
isdefault int2 5
extmanaged int2 5
extmapping varchar 2048  √  null
islist int2 5 0
regidx int4 10 (-1)
defaultseclvlid int8 19 1001
jiveprofileseclvl.levelid jivepfield_lid_fk R
pseudo int2 5 0

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
fieldid Primary key Asc jivepfield_pk
name Must be unique Asc jivepfield_nm_idx

Close relationships: