Table JiveCore900.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
jiveprofilefldopt.fieldid jivepfo_fid_fk R
jiveprofilefldsec.fieldid jivepfsl_fid_fk R
jiveuserprofile.fieldid jiveup_fid_fk R
jivefield.fieldid Implied Constraint R
name varchar 255
jivepermmask.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'::integer
fieldtype int4 10
idx int4 10
isdefault int2 5
extmanaged int2 5
extmapping varchar 2048  √  null
islist int2 5 0
regidx int4 10 '-1'::integer
defaultseclvlid int8 19 1001
jiveprofileseclvl.levelid jivepfield_lid_fk R
pseudo int2 5 0

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

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

Close relationships: