Shopware 5.7.19 s_categories
Hierarchical product category tree — the primary shop navigation and catalog structure.
| Column | Type | Nullable | Additional |
| id | int(11) unsigned | NO | Primary Key, auto_increment |
| parent | int(11) unsigned | YES | Index |
| path | varchar(255) | YES | |
| description | varchar(255) | NO | Index |
| position | int(11) unsigned | YES | Index, Default: 0 |
| left | int(11) unsigned | NO | Index |
| right | int(11) unsigned | NO | |
| level | int(11) unsigned | NO | Index |
| added | datetime | NO | |
| changed | datetime | NO | |
| metakeywords | mediumtext | YES | |
| metadescription | mediumtext | YES | |
| cmsheadline | varchar(255) | YES | |
| cmstext | mediumtext | YES | |
| template | varchar(255) | YES | |
| active | int(1) | NO | |
| blog | int(11) | NO | |
| external | varchar(255) | YES | |
| hidefilter | int(1) | NO | |
| hidetop | int(1) | NO | |
| mediaID | int(11) unsigned | YES | |
| product_box_layout | varchar(50) | YES | |
| meta_title | varchar(255) | YES | |
| stream_id | int(11) unsigned | YES | Index
Foreign Key → s_product_streams.id |
| hide_sortings | int(1) | NO | Default: 0 |
| sorting_ids | text | YES | |
| facet_ids | text | YES | |
| external_target | varchar(32) | YES | Default: |
| shops | varchar(255) | YES | |
| Index Name | Columns | Unique |
| active_query_builder | parent,position,id | No |
| description | description | No |
| left | left,right | No |
| level | level | No |
| parent | parent | No |
| position | position | No |
| PRIMARY | id | Yes |
| stream_id | stream_id | No |
Relations (from this table)
1 relations
Relations (to this table)
1 relations
