Table JiveCore800.public.jivepopularity 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
popularityid int8 19
objecttype int4 10
objectid int8 19
containertype int4 10
containerid int8 19
jivecarouselcontainer.containerid Implied Constraint R
score int4 10
jiveratingtype.score Implied Constraint R
creationdate int8 19

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
popularityid Primary key Asc jivepopularity_pk
containertype + containerid Performance Asc/Asc jivepopul_cntr_pk

Close relationships: