Table sbs6a.public.jiveuserprofile 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
userprofileid int8 19
userid int8 19
jiveuser.userid Implied Constraint R
fieldid int8 19
jiveprofilefield.fieldid jiveup_fid_fk R
levelid int8 19  √  null
jiveprofileseclvl.levelid jiveup_lid_fk R
value varchar 3500  √  null
primaryval int2 5

Table contained 0 rows at Fri Aug 24 10:15 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
userprofileid Primary key Asc jiveuserprofile_pk
fieldid Performance Asc jup_fldid
userid + fieldid Performance Asc/Asc jup_uid_fid_idx

Close relationships  within of separation: