Table JiveCore900.public.jivethread 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
threadid int8 19
jiveanswer.threadid jiveanswer_tid_fk R
jivemessage.threadid jm_threadid_fk R
jivequestion.threadid jivequest_tid_fk R
jivequestionprop.threadid jivequestp_tid_fk R
jivethreadprop.threadid jtp_threadid_fk R
jivecrmescalationqueue.threadid Implied Constraint R
containertype int4 10
containerid int8 19
jivecarouselcontainer.containerid Implied Constraint R
rootmessageid int8 19
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
threadid Primary key Asc jivethread_pk
creationdate Performance Asc jvthrd_cdate_idx
containerid + containertype Performance Asc/Asc jvthrd_cntridx
containertype + containerid Performance Asc/Asc jvthrd_ctrid_idx
modificationdate Performance Asc jvthrd_mdate_idx
rootmessageid Performance Asc jvthrd_root_idx

Close relationships  within of separation: