Table sbs6a.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
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

Table contained 0 rows at Fri Aug 24 10:15 PDT 2012

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: