SchemaSpy - Table dba800.public.jiveoutcome

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

outcomeid

int8

19

jiveoutcomeprop.outcomeid

jiveout_oid_fk R

parentobjecttype

int4

10

parentobjectid

int8

19

childobjecttype

int4

10

(-1)

childobjectid

int8

19

(-1)

containertype

int4

10

containerid

int8

19

jivecarouselcontainer.containerid

Implied Constraint R

outcometypeid

int4

10

userid

int8

19

jiveuser.userid

Implied Constraint R

creationdate

int8

19

modificationdate

int8

19

note

text

2147483647

''::text

status

int4

10

1

predecessoroutcomeid

int8

19

(-1)

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
outcomeid	Primary key	Asc	jiveoutcome_pk
containertype + containerid + outcometypeid	Performance	Asc/Asc/Asc	jiveoutcome_container_idx
parentobjecttype + parentobjectid	Performance	Asc/Asc	jiveoutcome_parent_idx
parentobjecttype + parentobjectid + outcometypeid	Performance	Asc/Asc/Asc	jiveoutcome_parent_type_idx
status	Performance	Asc	jiveoutcome_status_idx
userid	Performance	Asc	jiveoutcome_user_idx
childobjecttype + childobjectid	Performance	Asc/Asc	joutcme_child_otypoid