Table JiveCore900.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
jivetileinstgone.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
lastdatapusherror int8 19  √  null
pusherrordetail text 2147483647  √  null
externalid varchar 127  √  null
privatepath varchar 127  √  null
displayname varchar 255  √  null
streamiconurl varchar 1024  √  null

Table contained 0 rows at Fri Jan 13 13:20 PST 2017

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

Close relationships  within of separation: