Table JiveCore700.public.jiveinboxentry 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
entryid int8 19
jivewebhookqueue.entryid Implied Constraint R
categoryid int8 19 (-1)
jivetemplatecategorydef.categoryid Implied Constraint R
entrytype int4 10
userid int8 19
jiveuser.userid Implied Constraint R
targetobjecttype int4 10
targetobjectid int8 19
state int2 5
inboxtype int2 5
requestmessage varchar 255  √  null
responsemessage varchar 255  √  null
creationdate int8 19
modificationdate int8 19  √  null

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
entryid + entrytype + userid + targetobjecttype + targetobjectid + state Primary key Asc/Asc/Asc/Asc/Asc/Asc jinbox_entry_pk
userid + categoryid + modificationdate Performance Asc/Asc/Asc jinbox_entry_ucm_dx
userid + modificationdate Performance Asc/Asc jinbox_entry_um_dx
targetobjecttype + targetobjectid + entrytype Performance Asc/Asc/Asc jinbox_targetidx

Close relationships: