Table sbs6a.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
containertype int4 10
containerid int8 19
rootmessageid int8 19
rewardpoints int4 10
creationdate int8 19
modificationdate int8 19
status int4 10

Table contained 0 rows at Fri Aug 24 10:15 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
threadid Primary key Asc jivethread_pk
creationdate Performance Asc jvthrd_cdate_idx
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: