Table JiveCore800.public.jivecontentplacerel 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
relationshipid int8 19
jiveuserrel.relationshipid Implied Constraint R
containertype int4 10
containerid int8 19
jivecarouselcontainer.containerid Implied Constraint R
contentobjecttype int4 10
contentobjectid int8 19
userid int8 19
jiveuser.userid Implied Constraint R
creationdate int8 19
modificationdate int8 19

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
relationshipid Primary key Asc jivecntplacerel_pk
contentobjecttype + contentobjectid Performance Asc/Asc jivecntplacerel_cnt_idx
containertype + containerid Performance Asc/Asc jivecntplacerel_ctr_idx
containertype + containerid + contentobjecttype + contentobjectid Must be unique Asc/Asc/Asc/Asc jivecntplacerel_uniq_idx

Close relationships: