Table JiveCore700.public.jivedocversion 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
jivedocument.internaldocid jdv_ildocid_fk R
versionid int4 10
state varchar 20
userid int8 19
jiveuser.userid Implied Constraint R
creationdate int8 19
modificationdate int8 19
language bpchar 2
title varchar 255
summary text 2147483647  √  null
minorversion int2 5
status int4 10
recordid int8 19
exstoragefileversionid int8 19  √  null
jivestoragefileversion.exstoragefileversionid jdv_exfileversionid_fk R

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
versionid + internaldocid Primary key Asc/Asc jivedocversion_pk
creationdate Performance Asc jdv_cdate_idx
exstoragefileversionid Performance Asc jdv_exfileversionid_idx
recordid Must be unique Asc jdv_id_idx
internaldocid + state Performance Asc/Asc jdv_idocid_stt_idx
modificationdate Performance Asc jdv_mdate_idx
title Performance Asc jdv_title_idx

Close relationships  within of separation: