Table JiveEAE700.public.jiverecentuserstreamupdate 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
id bigserial 19  √  nextval('jiverctusrstrmup_id_seq'::regclass)
activitycontextid int8 19
activitycontexttype int4 10
activitydescriptorid int8 19
activitydescriptortype int4 10
activityidhi int8 19
activityidlo int8 19
activityparentid int8 19
activityparenttype int4 10
activitytime int8 19
activitytype int4 10
activityuserid int8 19
lastprocesstime int8 19
takeableaftertime int8 19 0
processingnodeid varchar 255  √  null
processingstate int4 10
updatetime int8 19
users text 2147483647

Analyzed at Fri Dec 20 10:15 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc jivercntuserstrmup_pk
activityidhi + activityidlo Performance Asc/Asc jivercntinbox_act_idx
processingstate + takeableaftertime Performance Asc/Asc jivercntinbox_state_idx