SchemaSpy - Table dba800a.public.jivedw_thread

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

thread_id

int8

19

jivedw_answer.thread_id	Implied Constraint R
jivedw_answer_stage.thread_id	Implied Constraint R
jivedw_message.thread_id	Implied Constraint R
jivedw_message_stage.thread_id	Implied Constraint R
jivedw_question.thread_id	Implied Constraint R
jivedw_question_stage.thread_id	Implied Constraint R
jivedw_thread_stage.thread_id	Implied Constraint R

creation_ts

timestamp

29,6

modification_ts

timestamp

29,6

container_type

int4

10

17

container_id

int8

19

(-2)

status

int4

10

Analyzed at Mon Apr 27 15:39 PDT 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
thread_id	Primary key	Asc	jivedw_thread_pk
creation_ts	Performance	Asc	jivedw_thd_c_ts_idx
container_id + container_type	Performance	Asc/Asc	jivedw_thd_ctid_idx
modification_ts	Performance	Asc	jivedw_thd_m_ts_idx
status	Performance	Asc	jivedw_thd_status_idx