Table JiveCore700.public.jivemessage 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
messageid int8 19
jiveanswer.messageid jiveanswer_mid_fk R
jivemessageprop.messageid jmp_msgid_fk R
jivethreadlatest.messageid Implied Constraint R
parentmessageid int8 19  √  null
threadid int8 19
jivethread.threadid jm_threadid_fk R
containertype int4 10
containerid int8 19
jivecarouselcontainer.containerid Implied Constraint R
userid int8 19  √  null
jiveuser.userid Implied Constraint R
subject varchar 255  √  null
body text 2147483647  √  null
rewardpoints int4 10
creationdate int8 19
modificationdate int8 19
status int4 10

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
messageid Primary key Asc jivemessage_pk
creationdate Performance Asc jvmssg_cdate_idx
containerid + containertype + modificationdate Performance Asc/Asc/Asc jvmssg_cidctmd_idx
modificationdate Performance Asc jvmssg_mdate_idx
parentmessageid Performance Asc jvmssg_prntid_idx
threadid Performance Asc jvmssg_thrd_idx
userid Performance Asc jvmssg_usrid_idx

Close relationships  within of separation: