store

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
customersession.store_id FK_98B2EE06B092A811R
store_disabledwidgets.store_id FK_69AD90FFB092A811C
store_fullpagecachingcontent.store_id FK_580D120FB092A811C
store_nonpubliccontent.store_id FK_D046C167B092A811C
store_seocachedcontent.store_id FK_E76CB8E0B092A811C
storebanner.store_id FK_999B0262B092A811R
storecache.store_id FK_FEDBB532B092A811R
storefeedback.store_id FK_BF6984C2B092A811R
storemenu.store_id FK_31BAF9A0B092A811R
storeseourl.store_id FK_F3D2E79DB092A811R
storesession.store_id FK_4D60A4C1B092A811R
client_id VARCHAR 36 √ null
client.id FK_FF57587719EB6921R
blocked BIT 1 null
title VARCHAR 255 null
url VARCHAR 255 null
ident VARCHAR 255 null
VARCHAR 255 √ null
productsPerPage INT 10 null
productThumbnailWidth INT 10 null
productThumbnailHeight INT 10 null
productIconWidth INT 10 null
productIconHeight INT 10 null
productDetailsImageWidth INT 10 null
productDetailsImageHeight INT 10 null
devMode BIT 1 null
language_id VARCHAR 36 √ null
language.id FK_FF57587782F1BAF4R
productionMode INT 10 null
metakeywords LONGTEXT 2147483647 √ null
metadescription LONGTEXT 2147483647 √ null
titlePrefix VARCHAR 255 √ null
titleSuffix VARCHAR 255 √ null
headerHtml LONGTEXT 2147483647 √ null
footerHtml LONGTEXT 2147483647 √ null
startPageTitle VARCHAR 255 √ null
additionalSearchGrid_id VARCHAR 36 √ null
customformgrid.id FK_FF5758775654BF34R
productMetaTitle VARCHAR 255 √ null
productMetaKeywords VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_FF57587719EB6921 Performance Asc client_id
IDX_FF5758775654BF34 Performance Asc additionalSearchGrid_id
IDX_FF57587782F1BAF4 Performance Asc language_id

Relationships

Close relationships within degrees of separation