SchemaSpy - Table dba8c1cmrana.public.jivedw_acclaim

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

acclaim_id

int8

19

jivedw_acclaim_stage.acclaim_id	Implied Constraint R
jivedw_acclaimvote.acclaim_id	Implied Constraint R
jivedw_acclaimvote_stage.acclaim_id	Implied Constraint R

object_type

int4

10

object_id

int8

19

acclaim_type

varchar

20

score

numeric

131089

0

score_display

numeric

131089

0

visibility

int4

10

1

creation_ts

timestamp

29,6

√

null

modification_ts

timestamp

29,6

√

null

Analyzed at Fri May 09 11:35 PDT 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
acclaim_id	Primary key	Asc	jdw_acclaim_pk
object_type + object_id	Performance	Asc/Asc	jdw_acclaim_typeid_idx
object_type + object_id + acclaim_type	Must be unique	Asc/Asc/Asc	jdw_acclaim_uk_idx