Table JiveCore800.public.jivetileinstance 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
tileinstanceid int8 19
jiveextcomments.tileinstanceid Implied Constraint R
jivetileinstgone.tileinstanceid Implied Constraint R
jivetilestreamentry.tileinstanceid Implied Constraint R
tileid int8 19
jivetile.tileid jivetileinst_tile_fk R
instanceorder int4 10
instancecolumn int4 10
state varchar 64
instancedata text 2147483647  √  null
config text 2147483647  √  null
status text 2147483647  √  null
parentobjecttype int4 10
parentobjectid int8 19
userid int8 19
jiveuser.userid Implied Constraint R
lastdatapush int8 19  √  null
lastregister int8 19  √  null
creationdate int8 19
modificationdate int8 19

Analyzed at Mon Apr 27 15:32 PDT 2015

Indexes:
Column(s) Type Sort Constraint Name
tileinstanceid Primary key Asc jivetileinst__pk
parentobjecttype + parentobjectid Performance Asc/Asc jivetile_parent_ix

Close relationships  within of separation: