Table JiveCore700.public.jivestreamentry 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
streamentryid int8 19
jivestreamaction.streamentryid jivestrm_action_fk R
jivestreamapprover.streamentryid jivestrm_apprv_fk R
jivestreamentprop.streamentryid jivestrmprp_sid_fk R
jivestreamenttext.streamentryid jivestrmtxt_sid_fk R
streamchannelid int8 19
jivestreamchannel.streamchannelid jivestrm_prnt_fk R
userid int8 19
jiveuser.userid jivestrm_user_fk R
verb varchar 128
title varchar 420  √  null
body varchar 1024  √  null
summary varchar 3500  √  null
objecttype int4 10  √  null
objectid int8 19  √  null
targettype int4 10  √  null
targetid int8 19  √  null
activityidmd5 varchar 127  √  null
activityid varchar 3500  √  null
activityfaviconurl varchar 1024  √  null
objecttitle varchar 1024  √  null
objectmediatype varchar 32  √  null
unmappedvalues text 2147483647  √  null
releasekeysha1 varchar 40  √  null
activityspec varchar 32  √  null
creationdate int8 19
modificationdate int8 19

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
streamentryid Primary key Asc jivestreament_pk
activityidmd5 Performance Asc jivestrm_actid_idx
streamchannelid Performance Asc jivestrm_chnl_idx
releasekeysha1 Performance Asc jivestrm_relky_idx
userid Performance Asc jivestrm_user_idx

Close relationships  within of separation: