Shopware 5.6.9 s_media
Central media library — stores metadata for uploaded files (images, documents, videos).
| Column | Type | Nullable | Additional |
| id | int(11) | NO | Primary Key, auto_increment |
| albumID | int(11) | NO | Index |
| name | varchar(255) | NO | |
| description | text | NO | |
| path | varchar(255) | NO | Index |
| type | varchar(50) | NO | |
| extension | varchar(20) | NO | |
| file_size | int(10) unsigned | NO | |
| width | int(11) unsigned | YES | |
| height | int(11) unsigned | YES | |
| userID | int(11) | NO | |
| created | date | NO | |
| Index Name | Columns | Unique |
| Album | albumID | No |
| path | path | No |
| PRIMARY | id | Yes |
Relations (to this table)
1 relations
