SchemaSpy - Table dba8c1cmrana.public.jivedw_poll

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

poll_id

int8

19

jivedw_poll_stage.poll_id

Implied Constraint R

object_type

int4

10

object_id

int8

19

user_id

int8

19

√

null

jivedw_user_stage.user_id

Implied Constraint R

name

varchar

255

creation_ts

timestamp

29,6

modification_ts

timestamp

29,6

status

int4

10

Analyzed at Fri May 09 11:35 PDT 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
poll_id	Primary key	Asc	jivedw_poll_pk
creation_ts	Performance	Asc	jivedw_poll_cts_idx
modification_ts	Performance	Asc	jivedw_poll_mts_idx
object_id + object_type	Performance	Asc/Asc	jvdw_pll_id_type_idx
status	Performance	Asc	jvdw_poll_status_idx
user_id	Performance	Asc	jvdw_poll_userid_idx