Table JiveCore700.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
jivetilestreamentry.tileid Implied Constraint R
jivetiletmplassoc.tileid jivetiletp_tile_fk R
tilename varchar 127
displayname varchar 255  √  null
clientid varchar 1024  √  null
description varchar 4000  √  null
productname varchar 255  √  null
visualstyle varchar 64
sampledata text 2147483647  √  null
configurationurl varchar 1024  √  null
actionurl varchar 1024  √  null
registerurl varchar 2500  √  null
unregisterurl varchar 2500  √  null
dataproviderkey varchar 127 'external'::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

Analyzed at Fri Dec 20 10:31 PST 2013

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: