SchemaSpy - Table db_700clean.public.jiveanswer

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

jivethread.threadid

jiveanswer_tid_fk R

messageid

int8

19

jivemessage.messageid

jiveanswer_mid_fk R

containertype

int8

19

containerid

int8

19

jivecarouselcontainer.containerid

Implied Constraint R

userid

int8

19

√

null

jiveuser.userid

Implied Constraint R

helpfulanswer

int2

5

correctanswer

int2

5

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
threadid + messageid	Primary key	Asc/Asc	jiveanswer_pk
userid	Performance	Asc	jvanswr_usr_idx