Table JiveCore800.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 Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
activityid Primary key Asc jiveactivity_pk
objectid + objecttype Performance Asc/Asc jact_oid_otype_idx
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: