Table JiveCore900.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

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

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: