Shopware 5.7.1 s_core_snippets
Text snippets (translations) — key-value pairs per shop and locale for storefront/email texts.
| Column | Type | Nullable | Additional |
| id | int(11) unsigned | NO | Primary Key, auto_increment |
| namespace | varchar(255) | NO | Index |
| shopID | int(11) unsigned | NO | |
| localeID | int(11) unsigned | NO | |
| name | varchar(255) | NO | |
| value | mediumtext | NO | |
| created | datetime | NO | |
| updated | datetime | NO | |
| dirty | int(1) | YES | Default: 0 |
| Index Name | Columns | Unique |
| namespace | namespace,shopID,name,localeID | Yes |
| PRIMARY | id | Yes |
