Table JiveEAE800.public.jiveuserinboxparentgroup 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('jiveusribxprnt_id_seq'::regclass)
isread int4 10
objectid int8 19
objecttype int4 10
parenttime int8 19
prevreadtracktime int8 19
readtracktime int8 19
untracked int4 10
userid int8 19

Analyzed at Mon Apr 27 15:37 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc jiveusrinboxparentgrp_pk
userid + parenttime + isread + objecttype + objectid Performance Asc/Asc/Asc/Asc/Asc jiveuseribx_item
userid + parenttime Performance Asc/Asc jiveuseribxprntgrp_utime
objecttype + objectid + userid Must be unique Asc/Asc/Asc jiveusrinboxparentgrp_dx