Shopware 5.7.3 s_articles_img
Product images with position ordering, main image flag, and variant mappings.
| Column | Type | Nullable | Additional |
| id | int(11) | NO | Primary Key, auto_increment |
| articleID | int(11) | YES | Index |
| img | varchar(255) | YES | |
| main | int(1) | NO | |
| description | varchar(255) | NO | |
| position | int(11) | NO | |
| width | int(11) | NO | |
| height | int(11) | NO | |
| relations | mediumtext | NO | |
| extension | varchar(255) | NO | |
| parent_id | int(10) unsigned | YES | Index |
| article_detail_id | int(10) unsigned | YES | Index |
| media_id | int(10) unsigned | YES | Index |
| Index Name | Columns | Unique |
| article_cover_image_query | articleID,main,position | No |
| article_detail_id | article_detail_id | No |
| article_images_query | articleID,position | No |
| artikel_id | articleID | No |
| media_id | media_id | No |
| parent_id | parent_id | No |
| PRIMARY | id | Yes |
Relations (to this table)
1 relations
