Table JiveCore900.public.jivedocument Generated by
SchemaSpy
Legend: SourceForge.net
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

Table contained 9 rows at Fri Jan 13 13:20 PST 2017

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

Close relationships  within of separation: