Shopware 5.7.16 s_articles_categories_ro
Denormalized product-to-category mapping including parent categories (read-optimized).
| Column | Type | Nullable | Additional |
| id | int(11) unsigned | NO | Primary Key, auto_increment |
| articleID | int(11) unsigned | NO | Index |
| categoryID | int(11) unsigned | NO | Index |
| parentCategoryID | int(11) unsigned | NO | |
| Index Name | Columns | Unique |
| articleID | articleID,categoryID,parentCategoryID | Yes |
| articleID_2 | articleID | No |
| categoryID | categoryID | No |
| categoryID_2 | categoryID,parentCategoryID | No |
| category_id_by_article_id | articleID,id | No |
| elastic_search | categoryID,articleID | No |
| PRIMARY | id | Yes |
