Table JiveCore900.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
jivesubscriptionassociation.entryid Implied Constraint R
categoryid int8 19 '-1'::integer
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

Table contained 44 rows at Fri Jan 13 13:20 PST 2017

Indexes:
Column(s) Type Sort Constraint Name
entryid + entrytype + userid + targetobjecttype + targetobjectid + state Primary key Asc/Asc/Asc/Asc/Asc/Asc jinbox_entry_pk
targetobjectid + targetobjecttype Performance Asc/Asc jinbox_entry_oidotyp
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: