SchemaSpy - Table dba800a.public.jivedw_acclaimvote

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

vote_id

int8

19

jivedw_acclaimvote_stage.vote_id

Implied Constraint R

voter_id

int8

19

acclaim_id

int8

19

jivedw_acclaim.acclaim_id

Implied Constraint R

creation_ts

timestamp

29,6

√

null

modification_ts

timestamp

29,6

√

null

vote_value

int4

10

0

Analyzed at Mon Apr 27 15:39 PDT 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
vote_id	Primary key	Asc	jdw_acclaimvote_pk
acclaim_id	Performance	Asc	jdw_av_acclaim_idx
voter_id	Performance	Asc	jdw_av_votertype_idx