Table JiveCore700.public.jivetilestreamentry 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
tilestreamentryid int8 19
jiveextcomments.tilestreamentryid Implied Constraint R
userid int8 19
jiveuser.userid Implied Constraint R
tileid int8 19
jivetile.tileid Implied Constraint R
tileinstanceid int8 19
jivetileinstance.tileinstanceid Implied Constraint R
containertype int4 10
containerid int8 19
jivecarouselcontainer.containerid Implied Constraint R
opengraphtype varchar 127
externalurl varchar 1024
imageurl varchar 1024
subject varchar 255  √  null
body text 2147483647  √  null
attributionemail varchar 127  √  null
attributionname varchar 127  √  null
actionname varchar 127
actiondescription varchar 255  √  null
creationdate int8 19
modificationdate int8 19
status int4 10
externalid varchar 255  √  null
context text 2147483647  √  null
modifiername text 2147483647  √  null
modifieremail text 2147483647  √  null

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
tilestreamentryid Primary key Asc jivetse_pk
containertype + containerid Performance Asc/Asc jivetse_cntr_ix
modificationdate Performance Asc jivetse_date_ix
tileinstanceid + externalid Performance Asc/Asc jivetse_ext_ix
tileinstanceid Performance Asc jivetse_tile_ix

Close relationships: