Table JiveCore800.public.jivegroupuser 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
groupid int8 19
jivesgroup.groupid Implied Constraint R
userid int8 19
jiveuser.userid juser_userid_fk R
administrator int4 10

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
groupid + userid + administrator Primary key Asc/Asc/Asc jivegroupuser_pk
userid Performance Asc jgu_userid_idx

Close relationships  within of separation: