SchemaSpy - Table db_700clean.public.jivequestion

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

jivethreadlatest.threadid

Implied Constraint R

jivethread.threadid

jivequest_tid_fk R

containertype

int8

19

containerid

int8

19

jivecarouselcontainer.containerid

Implied Constraint R

userid

int8

19

jiveuser.userid

Implied Constraint R

creationdate

int8

19

resolutiondate

int8

19

√

null

resolutionstate

int4

10

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
threadid	Primary key	Asc	jivequestion_pk
creationdate	Performance	Asc	jvqstn_cdate_idx
resolutiondate	Performance	Asc	jvqstn_rdate_idx
resolutionstate	Performance	Asc	jvqstn_state_idx
userid + resolutionstate	Performance	Asc/Asc	jvqstn_uid_st_idx