Shopware 6.5.7.3 app
Registry of installed Shopware apps (third-party extensions using the App System).
| Column | Type | Nullable | Additional |
| id | binary(16) | NO | Primary Key |
| name | varchar(255) | NO | Unique |
| path | varchar(255) | NO | |
| author | varchar(255) | YES | |
| copyright | varchar(255) | YES | |
| license | varchar(255) | YES | |
| privacy | varchar(255) | YES | |
| version | varchar(255) | NO | |
| base_app_url | varchar(1024) | YES | |
| active | tinyint(1) | NO | Default: 0 |
| allow_disable | tinyint(1) | NO | Default: 1 |
| configurable | tinyint(1) | NO | Default: 0 |
| icon | mediumblob | YES | |
| app_secret | varchar(255) | YES | |
| modules | json | YES | |
| main_module | json | YES | |
| cookies | json | YES | |
| allowed_hosts | json | YES | |
| integration_id | binary(16) | NO | Index
Foreign Key → integration.id |
| acl_role_id | binary(16) | NO | Index
Foreign Key → acl_role.id |
| created_at | datetime(3) | NO | |
| updated_at | datetime(3) | YES | |
| template_load_priority | int | YES | Default: 0 |
| Index Name | Columns | Unique |
| fk.app.acl_role_id | acl_role_id | No |
| fk.app.integration_id | integration_id | No |
| PRIMARY | id | Yes |
| uniq.name | name | Yes |
Relations (from this table)
2 relations
Relations (to this table)
15 relations
