Table JiveEAE700.public.jivemovedcontent 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
objecttype int4 10
objectid int8 19
contexttype int4 10
contextid int8 19
activitytime int8 19

Analyzed at Fri Dec 20 10:15 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
objecttype + objectid + contexttype + contextid Primary key Asc/Asc/Asc/Asc jivemvdcnt_pk
contexttype + contextid + activitytime Performance Asc/Asc/Asc jivemvdcnt_ctx_dx
activitytime Performance Asc jivemvdcnt_time_dx