Table JiveCore900.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
jiveretentionactiance.messageid Implied Constraint R
jiveretentionaggregatebinary.messageid Implied Constraint R
jiveretentionattachment.messageid Implied Constraint R
jiveretentionimage.messageid Implied Constraint R
jiveretentionmessagearchive.messageid Implied Constraint R
jiveretentionmessagebinaries.messageid Implied Constraint R
jiveretentionqueue.messageid Implied Constraint 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

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

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: