storemenu

16 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
category_id VARCHAR 36 null
category.id FK_31BAF9A012469DE2R
store_id VARCHAR 36 null
store.id FK_31BAF9A0B092A811R
title VARCHAR 255 null
url VARCHAR 255 null
hidden BIT 1 null
sort INT 10 null
menuType INT 10 null
maxAmountOfCategoryMenuItems INT 10 null
content_id VARCHAR 36 null
content.id FK_31BAF9A084A0A3EDR
ident VARCHAR 255 null
position INT 10 null
parentMenu VARCHAR 255 null
cssRule VARCHAR 255 null
cssInlineStyle LONGTEXT 2147483647 null
customPosition VARCHAR 255 null
html LONGTEXT 2147483647 null
customForm_id VARCHAR 36 null
customform.id FK_31BAF9A05DD59166R
imageName VARCHAR 255 null
blockBegin BIT 1 null
blockEnd BIT 1 null
blockCssRule VARCHAR 255 null
dql LONGTEXT 2147483647 null
htmlCodeBefore VARCHAR 255 null
htmlCodeAfter VARCHAR 255 null
widgetType VARCHAR 255 null
displayCondition VARCHAR 255 null
menuGroup VARCHAR 255 null
filterGrid_id VARCHAR 36 null
customformgrid.id FK_31BAF9A03754E8F4R
filterOptions LONGTEXT 2147483647 null
customFormGrid_id VARCHAR 36 null
customformgrid.id FK_31BAF9A0C2B92121R
fixedSubmenu BIT 1 null
lastInGroup BIT 1 null
htmlCaching BIT 1 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
customPosition_idx Performance Asc customPosition
ident_idx Performance Asc ident
IDX_31BAF9A012469DE2 Performance Asc category_id
IDX_31BAF9A03754E8F4 Performance Asc filterGrid_id
IDX_31BAF9A05DD59166 Performance Asc customForm_id
IDX_31BAF9A084A0A3ED Performance Asc content_id
IDX_31BAF9A0B092A811 Performance Asc store_id
IDX_31BAF9A0C2B92121 Performance Asc customFormGrid_id
position_idx Performance Asc position

Relationships