SchemaSpy - Table dba8c1cmrana.public.jivedw_question

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_thread.thread_id

Implied Constraint R

container_type

int8

19

container_id

int8

19

user_id

int8

19

jivedw_user_stage.user_id

Implied Constraint R

creation_ts

timestamp

29,6

resolution_ts

timestamp

29,6

√

null

resolution_state

int4

10

Analyzed at Fri May 09 11:35 PDT 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
thread_id	Primary key	Asc	jivedw_question_pk
container_id + container_type	Performance	Asc/Asc	jvdw_qstn_c_id_c_tpe_idx
creation_ts	Performance	Asc	jvdw_qstn_cdate_idx
resolution_ts	Performance	Asc	jvdw_qstn_rdate_idx
resolution_state	Performance	Asc	jvdw_qstn_state_idx
user_id	Performance	Asc	jvdw_qstn_u_id_idx