Table sbs6a.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
activitytype int4 10
userid int8 19  √  null
jiveuser.userid Implied Constraint R
creationdate int8 19

Table contained 0 rows at Fri Aug 24 10:15 PDT 2012

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: