SchemaSpy - Table dba800.public.jivethread

Generated by
SchemaSpy

Legend:

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

jivecarouselcontainer.containerid

Implied Constraint R

rootmessageid

int8

19

rewardpoints

int4

10

creationdate

int8

19

modificationdate

int8

19

status

int4

10

Analyzed at Mon Apr 27 15:32 PDT 2015

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