Table JiveCore900.public.jivetile 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
tileid int8 19
jivetilecategory.tileid Implied Constraint R
jivetilei18n.tileid Implied Constraint R
jivetileinstance.tileid jivetileinst_tile_fk R
jivetileprops.tileid Implied Constraint R
jivetilestreamentry.tileid Implied Constraint R
jivetiletmplassoc.tileid jivetiletp_tile_fk R
tilename varchar 127
displayname varchar 255  √  null
clientid varchar 127  √  null
description varchar 4000  √  null
productname varchar 255  √  null
visualstyle varchar 64
displaywidth varchar 64 'NARROW'::character varying
pagetype varchar 256 'PLACE'::character varying
defaultsharing varchar 64 'SHOULD'::character varying
sampledata text 2147483647  √  null
configurationurl varchar 1024  √  null
actionurl varchar 1024  √  null
registerurl varchar 2500  √  null
unregisterurl varchar 2500  √  null
viewurl varchar 2500  √  null
dataproviderkey varchar 127 'external'::character varying
enabledproviderkey varchar 127 'alwaysEnabled'::character varying
state varchar 64 'PUBLISHED'::character varying
creationdate int8 19
modificationdate int8 19
extensionuuid varchar 48  √  null
internali18nkeys varchar 1024  √  null
oauth2dependent int2 5 0
ownerid int8 19  √  null
jivecnxtsvcowner.ownerid Implied Constraint R

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

Indexes:
Column(s) Type Sort Constraint Name
tileid Primary key Asc jivetile__pk
extensionuuid + tilename Must be unique Asc/Asc jivetile_extension_id_idx
tilename Performance Asc jivetile_name_idx
state Performance Asc jivetile_state_idx
visualstyle Performance Asc jivetile_style_idx

Close relationships  within of separation: