Table JiveEAE700.public.jiveactivityfirehose 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
activityidhi int8 19
activityidlo int8 19
activitysystemid varchar 255
activitycontextid int8 19  √  null
activitycontexttype int4 10  √  null
activitydescriptorid int8 19  √  null
activitydescriptortype int4 10  √  null
activityparentid int8 19  √  null
activityparenttype int4 10  √  null
activitytime int8 19
activitytype int4 10
activityuserid int8 19
activitylocalecode varchar 32  √  null
activityproperties text 2147483647  √  null
activityaddproperties text 2147483647  √  null

Analyzed at Fri Dec 20 10:15 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
activityidhi + activityidlo Primary key Asc/Asc jiveactfirehose_pk
activitytime Performance Asc jiveactfirehose_time