Table sbs6a.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
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 1 rows at Fri Aug 24 10:15 PDT 2012

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 Performance Asc jinbox_entry_useridx

Close relationships: