Table JiveCore800.public.jivebadgerolerel 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
badgerolerelid int8 19
badgeroleid int8 19
jivebadgerole.badgeroleid jbdgrlrel_bdgrl_fk R
relatedobjecttype int4 10
relatedobjectid int8 19
badgeimageuri varchar 2048
userid int8 19
jiveuser.userid jbdgrlrel_user_fk R
creationdate int8 19
modificationdate int8 19
enabled int2 5 0

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
badgerolerelid Primary key Asc jivebadgerolerel_pk
relatedobjecttype + relatedobjectid Must be unique Asc/Asc jbdgrlrel_relobj_uniq

Close relationships  within of separation: