SchemaSpy - Table db_700clean.public.jivedashboard

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

dashboardid

int8

19

jiveappview.dashboardid

jvappview_dash_fk R

userid

int8

19

jiveuser.userid

jivedash_user_fk R

containertype

int4

10

containerid

int8

19

jivecarouselcontainer.containerid

Implied Constraint R

displayname

varchar

128

orderindex

int4

10

columncount

int4

10

creationdate

int8

19

modificationdate

int8

19

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
dashboardid	Primary key	Asc	jivedashboard_pk
containertype + containerid	Performance	Asc/Asc	jivedash_ctnr_idx
userid	Performance	Asc	jivedash_user_idx