SchemaSpy - Table dba800.public.jiveinboxentry

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

entryid

int8

19

jivewebhookqueue.entryid

Implied Constraint R

categoryid

int8

19

(-1)

jivetemplatecategorydef.categoryid

Implied Constraint R

entrytype

int4

10

userid

int8

19

jiveuser.userid

Implied Constraint R

targetobjecttype

int4

10

targetobjectid

int8

19

state

int2

5

inboxtype

int2

5

requestmessage

varchar

255

√

null

responsemessage

varchar

255

√

null

creationdate

int8

19

modificationdate

int8

19

√

null

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:

Column(s)	Type	Sort	Constraint Name
entryid + entrytype + userid + targetobjecttype + targetobjectid + state	Primary key	Asc/Asc/Asc/Asc/Asc/Asc	jinbox_entry_pk
targetobjectid + targetobjecttype	Performance	Asc/Asc	jinbox_entry_oidotyp
userid + categoryid + modificationdate	Performance	Asc/Asc/Asc	jinbox_entry_ucm_dx
userid + modificationdate	Performance	Asc/Asc	jinbox_entry_um_dx
targetobjecttype + targetobjectid + entrytype	Performance	Asc/Asc/Asc	jinbox_targetidx