← Shopware 6.7.8.1

Shopware 6.7.8.1 custom_entity

Registry of custom entities defined by apps or plugins (dynamic DB tables via Admin SDK).

Columns

11 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
name varchar(255) NO Unique
fields json NO
app_id binary(16) YES Index Foreign Key → app.id
created_at datetime(3) NO
updated_at datetime(3) YES
flags json YES
plugin_id binary(16) YES Index Foreign Key → plugin.id
custom_fields_aware tinyint(1) NO Default: 0
label_property varchar(255) YES
deleted_at datetime(3) YES

Indexes

4 indexes

Index Name Columns Unique
app_id app_id No
fk.custom_entity.plugin_id plugin_id No
name name Yes
PRIMARY id Yes

Relations (from this table)

2 relations

Local Field Foreign Table Foreign Field
app_id app id
plugin_id plugin id

Relations (to this table)

1 relations

Local Field Foreign Table Foreign Field
id category custom_entity_type_id