Table JiveCore700.public.jivecomment 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
commentid int8 19
jivecommentprop.commentid jcmmprp_cmtid_fk R
jiveextcomments.commentid Implied Constraint R
jivestoragecomment.jivecommentid jivestoragecomment_comment_fk R
parentcommentid int8 19  √  null
objecttype int4 10
objectid int8 19
parentobjecttype int4 10  √  null
parentobjectid int8 19  √  null
userid int8 19  √  null
jiveuser.userid Implied Constraint R
name varchar 100  √  null
email varchar 100  √  null
url varchar 255  √  null
ip varchar 15  √  null
body text 2147483647
creationdate int8 19
modificationdate int8 19
status int4 10

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
commentid Primary key Asc jivecomment_pk
creationdate Performance Asc jcmmt_cdate_idx
modificationdate Performance Asc jcmmt_mdate_idx
objecttype + objectid Performance Asc/Asc jcmmt_o_idx
parentobjecttype + parentobjectid Performance Asc/Asc jcmmt_p_idx
userid Performance Asc jcmmt_userid_idx

Close relationships  within of separation: