SchemaSpy - Table db_700clean.public.jivedocument

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

internaldocid

int8

19

jiveattachversion.internaldocid	jattv_idocid_fk R
jivedocbodyversion.internaldocid	jdbv_idocid_fk R
jivedoccollab.internaldocid	jdc_idocid_fk R
jivedocumentaudit.internaldocid	Implied Constraint R
jivedocumentprop.internaldocid	jdprp_ildocid_fk R
jivedocversion.internaldocid	jdv_ildocid_fk R
jivedocversioncmmt.internaldocid	jdvcmmt_idocid_fk R
jivefieldvalue.internaldocid	Implied Constraint R
jiveimageversion.internaldocid	jiv_idocid_fk R

userid

int8

19

jiveuser.userid

Implied Constraint R

documentid

varchar

255

containertype

int4

10

containerid

int8

19

jivecarouselcontainer.containerid

Implied Constraint R

typeid

int8

19

jivedoctype.typeid

jd_typeid_fk R

editpolicy

int4

10

creationdate

int8

19

expirationdate

int8

19

recommended

int2

5

meanrating

int4

10

readcount

int4

10

commentstatus

int4

10

workflowid

int8

19

√

null

versionid

int4

10

exstoragefileid

int8

19

√

null

jivestoragefile.exstoragefileid

jd_exfileid_fk R

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
internaldocid	Primary key	Asc	jivedocument_pk
documentid	Must be unique	Asc	jivedocument_documentid_key
containertype + containerid + internaldocid	Performance	Asc/Asc/Asc	jvdcmnt_ctctit_idx
exstoragefileid	Performance	Asc	jvdcmnt_exfileid_idx
expirationdate	Performance	Asc	jvdcmnt_exprtn_idx
userid	Performance	Asc	jvdcmnt_userid_idx