Shopware 5.7.14 s_core_shops
Shop/sub-shop definitions — each represents a storefront with its own domain, language, and theme.
| Column | Type | Nullable | Additional |
| id | int(11) unsigned | NO | Primary Key, auto_increment |
| main_id | int(11) unsigned | YES | Index |
| name | varchar(255) | NO | |
| title | varchar(255) | YES | |
| position | int(11) | NO | |
| host | varchar(255) | YES | Index |
| base_path | varchar(255) | YES | |
| base_url | varchar(255) | YES | |
| hosts | text | NO | |
| secure | int(1) unsigned | NO | |
| template_id | int(11) unsigned | YES | |
| document_template_id | int(11) unsigned | YES | |
| category_id | int(11) unsigned | YES | |
| locale_id | int(11) unsigned | YES | |
| currency_id | int(11) unsigned | YES | |
| customer_group_id | int(11) unsigned | YES | |
| fallback_id | int(11) unsigned | YES | |
| customer_scope | int(1) | NO | |
| default | int(1) unsigned | NO | |
| active | int(1) | NO | |
| Index Name | Columns | Unique |
| host | host | No |
| main_id | main_id | No |
| PRIMARY | id | Yes |
Relations (to this table)
4 relations
