Table JiveCore900.public.jivedocversion Generated by
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

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

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: