Table JiveCore700.public.jiveactivity 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
activityid int8 19
objecttype int4 10
objectid int8 19
containertype int4 10
containerid int8 19
jivecarouselcontainer.containerid Implied Constraint R
activitytype int4 10
userid int8 19  √  null
jiveuser.userid Implied Constraint R
creationdate int8 19

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
activityid Primary key Asc jiveactivity_pk
activitytype + userid Performance Asc/Asc jactiv_at_uid_idx
userid Performance Asc jactiv_uid_idx
containertype + containerid + activitytype Performance Asc/Asc/Asc jiveactiv_cntracttype_idx

Close relationships: