Database Schema Shopware 6.7.7.1

236 tables found. Click a table to see its columns, indexes, and relations.

Shopware 6.7.7.1

Shopware Version

Shopware 5

Shopware 6

acl_role

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(255)
description	longtext
privileges	json
created_at	datetime(3)
updated_at	datetime(3)
deleted_at	datetime(3)

acl_user_role

4 columns

Column	Type	Additional
user_id	binary(16)	Primary Key Foreign Key → user.id
acl_role_id	binary(16)	Primary Key Foreign Key → acl_role.id
created_at	datetime(3)
updated_at	datetime(3)

admin_elasticsearch_index_task

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
index	varchar(500)
alias	varchar(500)
entity	varchar(500)
doc_count	int

app

30 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(255)	Unique
path	varchar(4096)
author	varchar(255)
copyright	varchar(255)
license	varchar(255)
privacy	varchar(255)
version	varchar(255)
base_app_url	varchar(1024)
active	tinyint(1)
allow_disable	tinyint(1)
configurable	tinyint(1)
icon	mediumblob
app_secret	varchar(255)
modules	json
main_module	json
cookies	json
allowed_hosts	json
integration_id	binary(16)	Index Foreign Key → integration.id
acl_role_id	binary(16)	Index Foreign Key → acl_role.id
created_at	datetime(3)
updated_at	datetime(3)
template_load_priority	int
checkout_gateway_url	varchar(255)
self_managed	tinyint(1)
source_type	varchar(20)
source_config	json
in_app_purchases_gateway_url	varchar(255)
requested_privileges	json
context_gateway_url	varchar(255)

app_action_button

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
entity	varchar(255)
view	varchar(255)
url	varchar(255)
action	varchar(255)	Index
app_id	binary(16)	Index Foreign Key → app.id
created_at	datetime(3)
updated_at	datetime(3)

app_action_button_translation

5 columns

Column	Type	Additional
label	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)
app_action_button_id	binary(16)	Primary Key Foreign Key → app_action_button.id
language_id	binary(16)	Primary Key Foreign Key → language.id

app_administration_snippet

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
app_id	binary(16)	Index Foreign Key → app.id
locale_id	binary(16)	Index Foreign Key → locale.id
value	json
created_at	datetime(3)
updated_at	datetime(3)

app_cms_block

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
app_id	binary(16)	Index Foreign Key → app.id
name	varchar(255)
block	json
template	longtext
styles	longtext
created_at	datetime(3)
updated_at	datetime(3)

app_cms_block_translation

5 columns

Column	Type	Additional
label	varchar(255)
app_cms_block_id	binary(16)	Primary Key Foreign Key → app_cms_block.id
language_id	binary(16)	Primary Key Foreign Key → language.id
created_at	datetime(3)
updated_at	datetime(3)

app_config

2 columns

Column	Type	Additional
key	varchar(255)	Primary Key
value	longtext

app_flow_action

14 columns

Column	Type	Additional
id	binary(16)	Primary Key
app_id	binary(16)	Index Foreign Key → app.id
name	varchar(255)	Unique
badge	varchar(255)
url	varchar(500)
delayable	tinyint(1)
parameters	json
config	json
headers	json
requirements	json
icon	mediumblob
sw_icon	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)

app_flow_action_translation

8 columns

Column	Type	Additional
app_flow_action_id	binary(16)	Primary Key Foreign Key → app_flow_action.id
language_id	binary(16)	Primary Key Foreign Key → language.id
label	varchar(255)
description	longtext
headline	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

app_flow_event

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
app_id	binary(16)	Index Foreign Key → app.id
name	varchar(255)	Unique
aware	json
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

app_payment_method

14 columns

Column	Type	Additional
id	binary(16)	Primary Key
app_id	binary(16)	Index Foreign Key → app.id
payment_method_id	binary(16)	Unique Foreign Key → payment_method.id
app_name	varchar(255)
identifier	varchar(255)
pay_url	varchar(255)
finalize_url	varchar(255)
validate_url	varchar(255)
capture_url	varchar(255)
refund_url	varchar(255)
original_media_id	binary(16)	Index Foreign Key → media.id
created_at	datetime(3)
updated_at	datetime(3)
recurring_url	varchar(255)

app_script_condition

10 columns

Column	Type	Additional
id	binary(16)	Primary Key
app_id	binary(16)	Index Foreign Key → app.id
identifier	varchar(255)
active	tinyint(1)
group	varchar(255)
script	longtext
constraints	longblob
config	json
created_at	datetime(3)
updated_at	datetime(3)

app_script_condition_translation

5 columns

Column	Type	Additional
app_script_condition_id	binary(16)	Primary Key Foreign Key → app_script_condition.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)

app_shipping_method

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
app_id	binary(16)	Index Foreign Key → app.id
app_name	varchar(255)
shipping_method_id	binary(16)	Unique Foreign Key → shipping_method.id
original_media_id	binary(16)	Index Foreign Key → media.id
identifier	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)

app_template

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
template	longtext
path	varchar(1024)	Index
active	tinyint(1)
app_id	binary(16)	Index Foreign Key → app.id
created_at	datetime(3)
updated_at	datetime(3)
hash	varchar(32)

app_translation

8 columns

Column	Type	Additional
app_id	binary(16)	Primary Key Foreign Key → app.id
language_id	binary(16)	Primary Key Foreign Key → language.id
label	varchar(255)
description	longtext
privacy_policy_extensions	mediumtext
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

cart

6 columns

Column	Type	Additional
token	varchar(50)	Primary Key
rule_ids	json
created_at	datetime(3)	Index
auto_increment	bigint	Unique
compressed	tinyint(1)
payload	longblob

category_tag

3 columns

Column	Type	Additional
category_id	binary(16)	Primary Key Foreign Key → category.id
category_version_id	binary(16)	Primary Key Foreign Key → category.version_id
tag_id	binary(16)	Primary Key Foreign Key → tag.id

category_translation

17 columns

Column	Type	Additional
category_id	binary(16)	Primary Key Foreign Key → category.id
category_version_id	binary(16)	Primary Key Foreign Key → category.version_id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
breadcrumb	json
internal_link	binary(16)
link_new_tab	tinyint
link_type	varchar(255)
external_link	mediumtext
description	longtext
meta_title	varchar(255)
meta_description	varchar(255)
keywords	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
slot_config	json

cms_block

21 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
cms_section_id	binary(16)	Index Foreign Key → cms_section.id
cms_section_version_id	binary(16)	Foreign Key → cms_section.version_id
position	int
section_position	varchar(50)
type	varchar(255)
name	varchar(255)
locked	tinyint(1)
margin_top	varchar(255)
margin_bottom	varchar(255)
margin_left	varchar(255)
margin_right	varchar(255)
background_color	varchar(255)
background_media_id	binary(16)	Index Foreign Key → media.id
background_media_mode	varchar(255)
visibility	json
css_class	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

cms_page

10 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
type	varchar(255)
entity	varchar(255)
preview_media_id	binary(16)	Index Foreign Key → media.id
locked	tinyint(1)
css_class	varchar(255)
config	json
created_at	datetime(3)
updated_at	datetime(3)

cms_page_translation

7 columns

Column	Type	Additional
cms_page_id	binary(16)	Primary Key Foreign Key → cms_page.id
cms_page_version_id	binary(16)	Primary Key Foreign Key → cms_page.version_id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

cms_section

18 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
cms_page_id	binary(16)	Index Foreign Key → cms_page.id
cms_page_version_id	binary(16)	Foreign Key → cms_page.version_id
position	int
type	varchar(255)
name	varchar(255)
locked	tinyint(1)
sizing_mode	varchar(255)
mobile_behavior	varchar(255)
background_color	varchar(255)
background_media_id	binary(16)	Index Foreign Key → media.id
background_media_mode	varchar(255)
visibility	json
css_class	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

cms_slot

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
cms_block_id	binary(16)	Index Foreign Key → cms_block.id
cms_block_version_id	binary(16)	Foreign Key → cms_block.version_id
type	varchar(255)
slot	varchar(255)
locked	tinyint(1)
created_at	datetime(3)
updated_at	datetime(3)

cms_slot_translation

7 columns

Column	Type	Additional
cms_slot_id	binary(16)	Primary Key Foreign Key → cms_slot.id
cms_slot_version_id	binary(16)	Primary Key Foreign Key → cms_slot.version_id
language_id	binary(16)	Primary Key Foreign Key → language.id
config	json
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

country

21 columns

Column	Type	Additional
id	binary(16)	Primary Key
iso	varchar(255)
position	int
active	tinyint(1)
iso3	varchar(45)
display_state_in_registration	tinyint(1)
force_state_in_registration	tinyint(1)
check_vat_id_pattern	tinyint(1)
vat_id_pattern	varchar(255)
vat_id_required	tinyint(1)
customer_tax	json
company_tax	json
advanced_postal_code_pattern	varchar(255)
check_advanced_postal_code_pattern	tinyint(1)
check_postal_code_pattern	tinyint(1)
default_postal_code_pattern	varchar(1024)
postal_code_required	tinyint(1)
created_at	datetime(3)
updated_at	datetime(3)
shipping_available	tinyint(1)
is_eu	tinyint(1)

country_state

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
country_id	binary(16)	Index Foreign Key → country.id
short_code	varchar(255)
position	int
active	tinyint(1)
created_at	datetime(3)
updated_at	datetime(3)

country_state_translation

6 columns

Column	Type	Additional
country_state_id	binary(16)	Primary Key Foreign Key → country_state.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

country_translation

7 columns

Column	Type	Additional
country_id	binary(16)	Primary Key Foreign Key → country.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
address_format	json
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

currency

10 columns

Column	Type	Additional
id	binary(16)	Primary Key
iso_code	char(3)	Unique
factor	double
symbol	varchar(255)
position	int
created_at	datetime(3)
updated_at	datetime(3)
item_rounding	json
total_rounding	json
tax_free_from	double

currency_country_rounding

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
currency_id	binary(16)	Index Foreign Key → currency.id
country_id	binary(16)	Index Foreign Key → country.id
item_rounding	json
total_rounding	json
created_at	datetime(3)
updated_at	datetime(3)

currency_translation

7 columns

Column	Type	Additional
currency_id	binary(16)	Primary Key Foreign Key → currency.id
language_id	binary(16)	Primary Key Foreign Key → language.id
short_name	varchar(255)
name	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

custom_entity

11 columns

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

custom_field

12 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(255)	Unique
type	varchar(255)
config	json
active	tinyint(1)
set_id	binary(16)	Index Foreign Key → custom_field_set.id
created_at	datetime(3)
updated_at	datetime(3)
allow_customer_write	tinyint
allow_cart_expose	tinyint(1)
store_api_aware	tinyint(1)
include_in_search	tinyint(1)

custom_field_set

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(255)
config	json
active	tinyint(1)
app_id	binary(16)	Index Foreign Key → app.id
position	int
global	tinyint(1)
created_at	datetime(3)
updated_at	datetime(3)

custom_field_set_relation

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
set_id	binary(16)	Index Foreign Key → custom_field_set.id
entity_name	varchar(64)
created_at	datetime(3)
updated_at	datetime(3)

customer

45 columns

Column	Type	Additional
id	binary(16)	Primary Key
auto_increment	bigint unsigned	Unique
customer_group_id	binary(16)	Index Foreign Key → customer_group.id
requested_customer_group_id	binary(16)	Index
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
language_id	binary(16)
last_payment_method_id	binary(16)	Index Foreign Key → payment_method.id
default_billing_address_id	binary(16)	Index
default_shipping_address_id	binary(16)	Index
customer_number	varchar(255)
salutation_id	binary(16)	Index Foreign Key → salutation.id
first_name	varchar(255)
last_name	varchar(255)
company	varchar(255)
password	varchar(1024)
legacy_password	varchar(255)
legacy_encoder	varchar(255)
email	varchar(254)	Index
title	varchar(100)
vat_ids	json
active	tinyint(1)
double_opt_in_registration	tinyint(1)
double_opt_in_email_sent_date	datetime(3)
double_opt_in_confirm_date	datetime(3)
hash	varchar(255)	Unique
guest	tinyint(1)
first_login	datetime(3)	Index
last_login	datetime(3)	Index
newsletter_sales_channel_ids	json
birthday	date
last_order_date	datetime(3)
order_count	int
order_total_amount	double
custom_fields	json
affiliate_code	varchar(255)
campaign_code	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)
remote_address	varchar(255)
tag_ids	json
bound_sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
created_by_id	binary(16)	Index Foreign Key → user.id
updated_by_id	binary(16)	Index Foreign Key → user.id
account_type	varchar(255)
review_count	int

customer_address

19 columns

Column	Type	Additional
id	binary(16)	Primary Key
customer_id	binary(16)	Index Foreign Key → customer.id
country_id	binary(16)	Index Foreign Key → country.id
country_state_id	binary(16)	Index Foreign Key → country_state.id
company	varchar(255)
department	varchar(255)
salutation_id	binary(16)	Index Foreign Key → salutation.id
title	varchar(100)
first_name	varchar(255)
last_name	varchar(255)
street	varchar(255)
zipcode	varchar(50)
city	varchar(70)
phone_number	varchar(40)
additional_address_line1	varchar(255)
additional_address_line2	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

customer_group

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
display_gross	tinyint(1)
registration_active	tinyint(1)
created_at	datetime(3)
updated_at	datetime(3)

customer_group_registration_sales_channels

3 columns

Column	Type	Additional
customer_group_id	binary(16)	Primary Key Foreign Key → customer_group.id
sales_channel_id	binary(16)	Primary Key Foreign Key → sales_channel.id
created_at	datetime(3)

customer_group_translation

10 columns

Column	Type	Additional
customer_group_id	binary(16)	Primary Key Foreign Key → customer_group.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
custom_fields	json
registration_title	varchar(255)
registration_introduction	longtext
registration_only_company_registration	tinyint(1)
registration_seo_meta_description	longtext
created_at	datetime(3)
updated_at	datetime(3)

customer_recovery

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
customer_id	binary(16)	Unique Foreign Key → customer.id
hash	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)

customer_tag

2 columns

Column	Type	Additional
customer_id	binary(16)	Primary Key Foreign Key → customer.id
tag_id	binary(16)	Primary Key Foreign Key → tag.id

customer_wishlist

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
customer_id	binary(16)	Index Foreign Key → customer.id
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

customer_wishlist_product

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
customer_wishlist_id	binary(16)	Index Foreign Key → customer_wishlist.id
product_id	binary(16)	Index Foreign Key → product.id
product_version_id	binary(16)	Foreign Key → product.version_id
created_at	datetime(3)
updated_at	datetime(3)

delivery_time

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
min	int
max	int
unit	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)

delivery_time_translation

6 columns

Column	Type	Additional
delivery_time_id	binary(16)	Primary Key Foreign Key → delivery_time.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

document

15 columns

Column	Type	Additional
id	binary(16)	Primary Key
document_type_id	binary(16)	Index Foreign Key → document_type.id
referenced_document_id	binary(16)	Index Foreign Key → document.id
order_id	binary(16)	Index Foreign Key → order.id
order_version_id	binary(16)	Foreign Key → order.version_id
config	json
sent	tinyint(1)
static	tinyint(1)
deep_link_code	varchar(32)	Unique
document_media_file_id	binary(16)	Index Foreign Key → media.id
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
document_number	varchar(255)	Index
document_a11y_media_file_id	binary(16)	Index Foreign Key → media.id

document_base_config

12 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(64)
filename_prefix	varchar(64)
filename_suffix	varchar(64)
document_number	varchar(64)
global	tinyint(1)
document_type_id	binary(16)	Index Foreign Key → document_type.id
logo_id	binary(16)	Index Foreign Key → media.id
config	json
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

document_base_config_sales_channel

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
document_base_config_id	binary(16)	Index Foreign Key → document_base_config.id
document_type_id	binary(16)	Index Foreign Key → document_type.id
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
created_at	datetime(3)
updated_at	datetime(3)

document_type

4 columns

Column	Type	Additional
id	binary(16)	Primary Key
technical_name	varchar(255)	Unique
created_at	datetime(3)
updated_at	datetime(3)

document_type_translation

6 columns

Column	Type	Additional
document_type_id	binary(16)	Primary Key Foreign Key → document_type.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

elasticsearch_index_task

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
index	varchar(500)
alias	varchar(500)
entity	varchar(500)
doc_count	int

flow

12 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(255)
description	mediumtext
event_name	varchar(255)	Index
priority	int
payload	longblob
invalid	tinyint(1)
active	tinyint(1)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
app_flow_event_id	binary(16)	Index Foreign Key → app_flow_event.id

flow_sequence

13 columns

Column	Type	Additional
id	binary(16)	Primary Key
flow_id	binary(16)	Index Foreign Key → flow.id
app_flow_action_id	binary(16)	Index Foreign Key → app_flow_action.id
parent_id	binary(16)	Index Foreign Key → flow_sequence.id
rule_id	binary(16)	Index Foreign Key → rule.id
action_name	varchar(255)
config	json
position	int
display_group	int
true_case	tinyint(1)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

flow_template

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(255)
config	json
created_at	datetime(3)
updated_at	datetime(3)

import_export_file

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
original_name	varchar(255)
path	varchar(255)
expire_date	datetime(3)
size	int
updated_at	datetime(3)
created_at	datetime(3)
access_token	varchar(255)

import_export_log

14 columns

Column	Type	Additional
id	binary(16)	Primary Key
activity	varchar(255)
state	varchar(255)
records	int
username	varchar(255)
profile_name	varchar(255)
user_id	binary(16)	Index Foreign Key → user.id
profile_id	binary(16)	Index Foreign Key → import_export_profile.id
file_id	binary(16)	Index Foreign Key → import_export_file.id
created_at	datetime(3)
updated_at	datetime(3)
config	json
result	json
invalid_records_log_id	binary(16)	Index Foreign Key → import_export_log.id

import_export_profile

13 columns

Column	Type	Additional
id	binary(16)	Primary Key
system_default	tinyint unsigned
source_entity	varchar(255)
file_type	varchar(255)
delimiter	varchar(255)
enclosure	varchar(255)
type	varchar(255)
mapping	longtext
update_by	json
created_at	datetime(3)
updated_at	datetime(3)
config	json
technical_name	varchar(255)	Unique

import_export_profile_translation

5 columns

Column	Type	Additional
import_export_profile_id	binary(16)	Primary Key Foreign Key → import_export_profile.id
language_id	binary(16)	Primary Key Foreign Key → language.id
label	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)

increment

6 columns

Column	Type	Additional
pool	varchar(255)	Primary Key
cluster	varchar(255)	Primary Key
key	varchar(255)	Primary Key
count	bigint unsigned
created_at	datetime(3)
updated_at	datetime(3)

integration

10 columns

Column	Type	Additional
id	binary(16)	Primary Key
access_key	varchar(255)	Index
secret_access_key	varchar(255)
label	varchar(255)
admin	tinyint(1)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
last_usage_at	datetime(3)
deleted_at	datetime(3)

integration_role

2 columns

Column	Type	Additional
integration_id	binary(16)	Primary Key Foreign Key → integration.id
acl_role_id	binary(16)	Primary Key Foreign Key → acl_role.id

invalidation_tags

2 columns

Column	Type	Additional
id	binary(16)	Primary Key
tag	varchar(255)	Unique

landing_page

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
active	tinyint(1)
cms_page_id	binary(16)	Index Foreign Key → cms_page.id
cms_page_version_id	binary(16)	Foreign Key → cms_page.version_id
created_at	datetime(3)
updated_at	datetime(3)

landing_page_sales_channel

3 columns

Column	Type	Additional
landing_page_id	binary(16)	Primary Key Foreign Key → landing_page.id
landing_page_version_id	binary(16)	Primary Key Foreign Key → landing_page.version_id
sales_channel_id	binary(16)	Primary Key Foreign Key → sales_channel.id

landing_page_tag

3 columns

Column	Type	Additional
landing_page_id	binary(16)	Primary Key Foreign Key → landing_page.id
landing_page_version_id	binary(16)	Primary Key Foreign Key → landing_page.version_id
tag_id	binary(16)	Primary Key Foreign Key → tag.id

landing_page_translation

12 columns

Column	Type	Additional
landing_page_id	binary(16)	Primary Key Foreign Key → landing_page.id
landing_page_version_id	binary(16)	Primary Key Foreign Key → landing_page.version_id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
url	varchar(255)
meta_title	varchar(255)
meta_description	varchar(255)
keywords	varchar(255)
custom_fields	json
slot_config	json
created_at	datetime(3)
updated_at	datetime(3)

language

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(50)
parent_id	binary(16)	Index Foreign Key → language.id
locale_id	binary(16)	Index Foreign Key → locale.id
translation_code_id	binary(16)	Index Foreign Key → locale.id
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
active	tinyint(1)

locale

4 columns

Column	Type	Additional
id	binary(16)	Primary Key
code	varchar(255)	Unique
created_at	datetime(3)
updated_at	datetime(3)

locale_translation

7 columns

Column	Type	Additional
locale_id	binary(16)	Primary Key Foreign Key → locale.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
territory	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

log_entry

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
message	longtext
level	smallint
channel	varchar(255)
context	json
extra	json
created_at	datetime(3)	Index
updated_at	datetime(3)

mail_header_footer

4 columns

Column	Type	Additional
id	binary(16)	Primary Key
system_default	tinyint unsigned
created_at	datetime(3)
updated_at	datetime(3)

mail_header_footer_translation

10 columns

Column	Type	Additional
mail_header_footer_id	binary(16)	Primary Key Foreign Key → mail_header_footer.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
description	longtext
header_html	longtext
header_plain	longtext
footer_html	longtext
footer_plain	longtext
created_at	datetime(3)
updated_at	datetime(3)

mail_template

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
mail_template_type_id	binary(16)	Index Foreign Key → mail_template_type.id
system_default	tinyint unsigned
created_at	datetime(3)
updated_at	datetime(3)

mail_template_media

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
mail_template_id	binary(16)	Index Foreign Key → mail_template.id
language_id	binary(16)	Index Foreign Key → language.id
media_id	binary(16)	Index Foreign Key → media.id
position	int

mail_template_translation

10 columns

Column	Type	Additional
mail_template_id	binary(16)	Primary Key Foreign Key → mail_template.id
language_id	binary(16)	Primary Key Foreign Key → language.id
sender_name	varchar(255)
subject	varchar(255)
description	longtext
content_html	longtext
content_plain	longtext
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

mail_template_type

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
technical_name	varchar(255)	Unique
available_entities	longtext
created_at	datetime(3)
updated_at	datetime(3)
template_data	longtext

mail_template_type_translation

6 columns

Column	Type	Additional
mail_template_type_id	binary(16)	Primary Key Foreign Key → mail_template_type.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

main_category

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
product_id	binary(16)	Index Foreign Key → product.id
product_version_id	binary(16)	Foreign Key → product.version_id
category_id	binary(16)	Index Foreign Key → category.id
category_version_id	binary(16)	Foreign Key → category.version_id
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
created_at	datetime(3)
updated_at	datetime(3)

measurement_display_unit

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
measurement_system_id	binary(16)	Index Foreign Key → measurement_system.id
default	tinyint(1)
type	varchar(20)
short_name	varchar(20)	Unique
factor	double
precision	int
created_at	datetime(3)
updated_at	datetime(3)

measurement_display_unit_translation

6 columns

Column	Type	Additional
name	varchar(255)
measurement_display_unit_id	binary(16)	Primary Key Foreign Key → measurement_display_unit.id
language_id	binary(16)	Primary Key Foreign Key → language.id
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

measurement_system

4 columns

Column	Type	Additional
id	binary(16)	Primary Key
technical_name	varchar(255)	Unique
created_at	datetime(3)
updated_at	datetime(3)

measurement_system_translation

6 columns

Column	Type	Additional
name	varchar(255)
measurement_system_id	binary(16)	Primary Key Foreign Key → measurement_system.id
language_id	binary(16)	Primary Key Foreign Key → language.id
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

media

17 columns

Column	Type	Additional
id	binary(16)	Primary Key
user_id	binary(16)	Index Foreign Key → user.id
media_folder_id	binary(16)	Index Foreign Key → media_folder.id
mime_type	varchar(255)
file_extension	varchar(50)	Index
file_size	int unsigned
meta_data	json
file_name	longtext	Index
media_type	longblob
thumbnails_ro	longblob
private	tinyint(1)
uploaded_at	datetime(3)
created_at	datetime(3)
updated_at	datetime(3)
path	varchar(2048)
config	json
file_hash	varchar(32)	Index

media_default_folder

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
entity	varchar(255)	Unique
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

media_folder

11 columns

Column	Type	Additional
id	binary(16)	Primary Key
parent_id	binary(16)	Index Foreign Key → media_folder.id
default_folder_id	binary(16)	Unique Foreign Key → media_default_folder.id
name	varchar(255)
child_count	int unsigned
path	longtext
media_folder_configuration_id	binary(16)
use_parent_configuration	tinyint(1)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

media_folder_configuration

10 columns

Column	Type	Additional
id	binary(16)	Primary Key
create_thumbnails	tinyint(1)
thumbnail_quality	int
media_thumbnail_sizes_ro	longblob
keep_aspect_ratio	tinyint(1)
private	tinyint(1)
no_association	tinyint(1)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

media_folder_configuration_media_thumbnail_size

2 columns

Column	Type	Additional
media_folder_configuration_id	binary(16)	Primary Key Foreign Key → media_folder_configuration.id
media_thumbnail_size_id	binary(16)	Primary Key Foreign Key → media_thumbnail_size.id

media_tag

2 columns

Column	Type	Additional
media_id	binary(16)	Primary Key Foreign Key → media.id
tag_id	binary(16)	Primary Key Foreign Key → tag.id

media_thumbnail

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
media_id	binary(16)	Index Foreign Key → media.id
width	int unsigned
height	int unsigned
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
path	varchar(2048)
media_thumbnail_size_id	binary(16)	Index Foreign Key → media_thumbnail_size.id

media_thumbnail_size

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
width	int	Index
height	int
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

media_translation

7 columns

Column	Type	Additional
media_id	binary(16)	Primary Key Foreign Key → media.id
language_id	binary(16)	Primary Key Foreign Key → language.id
alt	varchar(255)
title	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

messenger_messages

7 columns

Column	Type	Additional
id	bigint	Primary Key
body	longtext
headers	longtext
queue_name	varchar(190)	Index
created_at	datetime
available_at	datetime	Index
delivered_at	datetime	Index

messenger_stats

4 columns

Column	Type	Additional
id	bigint unsigned	Primary Key
message_type	varchar(255)
time_in_queue	int
created_at	datetime	Index

migration

5 columns

Column	Type	Additional
class	varchar(255)	Primary Key
creation_timestamp	int
update	timestamp(6)
update_destructive	timestamp(6)
message	text

newsletter_recipient

17 columns

Column	Type	Additional
id	binary(16)	Primary Key
email	varchar(255)	Index
title	varchar(255)
first_name	varchar(255)
last_name	varchar(255)
zip_code	varchar(255)
city	varchar(255)
street	varchar(255)
status	varchar(255)
hash	varchar(255)	Unique
salutation_id	binary(16)	Index Foreign Key → salutation.id
language_id	binary(16)	Index Foreign Key → language.id
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
custom_fields	json
confirmed_at	datetime(3)
created_at	datetime(3)
updated_at	datetime(3)

newsletter_recipient_tag

2 columns

Column	Type	Additional
newsletter_recipient_id	binary(16)	Primary Key Foreign Key → newsletter_recipient.id
tag_id	binary(16)	Primary Key Foreign Key → tag.id

notification

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
status	varchar(255)
message	longtext
admin_only	tinyint(1)
required_privileges	json
created_by_integration_id	binary(16)	Index Foreign Key → integration.id
created_by_user_id	binary(16)	Index Foreign Key → user.id
created_at	datetime(3)
updated_at	datetime(3)

number_range

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
type_id	binary(16)
global	tinyint(1)
pattern	varchar(255)
start	int
created_at	datetime(3)
updated_at	datetime(3)

number_range_sales_channel

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
number_range_id	binary(16)	Index Foreign Key → number_range.id
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
number_range_type_id	binary(16)	Index Foreign Key → number_range_type.id
created_at	datetime(3)
updated_at	datetime(3)

number_range_state

5 columns

Column	Type	Additional
id	binary(16)	Unique
number_range_id	binary(16)	Primary Key
last_value	int
created_at	datetime(3)
updated_at	datetime(3)

number_range_translation

7 columns

Column	Type	Additional
number_range_id	binary(16)	Primary Key Foreign Key → number_range.id
name	varchar(64)
description	varchar(255)
custom_fields	json
language_id	binary(16)	Primary Key Foreign Key → language.id
created_at	datetime(3)
updated_at	datetime(3)

number_range_type

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
technical_name	varchar(64)	Unique
global	tinyint(1)
created_at	datetime(3)
updated_at	datetime(3)

number_range_type_translation

6 columns

Column	Type	Additional
number_range_type_id	binary(16)	Primary Key Foreign Key → number_range_type.id
language_id	binary(16)	Primary Key Foreign Key → language.id
type_name	varchar(64)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

oauth_user

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
user_id	binary(16)	Unique Foreign Key → user.id
user_sub	varchar(255)	Unique
token	json
expiry	datetime
created_at	datetime(3)
updated_at	datetime(3)

order

39 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
state_id	binary(16)	Index Foreign Key → state_machine_state.id
auto_increment	bigint unsigned	Unique
order_number	varchar(64)	Index
currency_id	binary(16)	Index Foreign Key → currency.id
language_id	binary(16)	Index Foreign Key → language.id
currency_factor	double
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
billing_address_id	binary(16)
billing_address_version_id	binary(16)
price	json
order_date_time	datetime(3)
order_date	date	Index
amount_total	double
amount_net	double
position_price	double
tax_status	varchar(255)
shipping_costs	json
shipping_total	double
deep_link_code	varchar(32)	Index
custom_fields	json
affiliate_code	varchar(255)
campaign_code	varchar(255)
customer_comment	longtext
created_at	datetime(3)
updated_at	datetime(3)
item_rounding	json
total_rounding	json
rule_ids	json
created_by_id	binary(16)	Index Foreign Key → user.id
updated_by_id	binary(16)	Index Foreign Key → user.id
source	varchar(255)
primary_order_delivery_id	binary(16)
primary_order_delivery_version_id	binary(16)
primary_order_transaction_id	binary(16)
primary_order_transaction_version_id	binary(16)
internal_comment	longtext
tax_calculation_type	varchar(50)

order_address

22 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
country_id	binary(16)	Index Foreign Key → country.id
country_state_id	binary(16)	Index Foreign Key → country_state.id
order_id	binary(16)	Index Foreign Key → order.id
order_version_id	binary(16)	Foreign Key → order.version_id
company	varchar(255)
department	varchar(255)
salutation_id	binary(16)	Index Foreign Key → salutation.id
title	varchar(100)
first_name	varchar(255)
last_name	varchar(255)
street	varchar(255)
zipcode	varchar(50)
city	varchar(70)
vat_id	varchar(50)
phone_number	varchar(40)
additional_address_line1	varchar(255)
additional_address_line2	varchar(255)
custom_fields	json
created_at	datetime(3)	Index
updated_at	datetime(3)

order_customer

17 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
customer_id	binary(16)	Index Foreign Key → customer.id
order_id	binary(16)	Index Foreign Key → order.id
order_version_id	binary(16)	Foreign Key → order.version_id
email	varchar(254)
salutation_id	binary(16)	Index Foreign Key → salutation.id
first_name	varchar(255)
last_name	varchar(255)
title	varchar(100)
vat_ids	json
company	varchar(255)
customer_number	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
remote_address	varchar(255)

order_delivery

15 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
order_id	binary(16)	Index Foreign Key → order.id
order_version_id	binary(16)	Foreign Key → order.version_id
state_id	binary(16)	Index Foreign Key → state_machine_state.id
shipping_order_address_id	binary(16)	Index Foreign Key → order_address.id
shipping_order_address_version_id	binary(16)	Foreign Key → order_address.version_id
shipping_method_id	binary(16)	Index Foreign Key → shipping_method.id
tracking_codes	json
shipping_date_earliest	date
shipping_date_latest	date
shipping_costs	json
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

order_delivery_position

13 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
order_delivery_id	binary(16)	Index Foreign Key → order_delivery.id
order_delivery_version_id	binary(16)	Foreign Key → order_delivery.version_id
order_line_item_id	binary(16)	Index Foreign Key → order_line_item.id
order_line_item_version_id	binary(16)	Foreign Key → order_line_item.version_id
price	json
total_price	int
unit_price	int
quantity	int
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

order_line_item

29 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
order_id	binary(16)	Index Foreign Key → order.id
order_version_id	binary(16)	Foreign Key → order.version_id
parent_id	binary(16)	Index Foreign Key → order_line_item.id
parent_version_id	binary(16)	Foreign Key → order_line_item.version_id
identifier	varchar(255)
referenced_id	varchar(255)
product_id	binary(16)	Index Foreign Key → product.id
product_version_id	binary(16)	Foreign Key → product.version_id
promotion_id	binary(16)	Index Foreign Key → promotion.id
label	varchar(255)
description	mediumtext
cover_id	binary(16)	Index Foreign Key → media.id
quantity	int
unit_price	double
total_price	double
type	varchar(255)
payload	json
price_definition	json
price	json
stackable	tinyint(1)
removable	tinyint(1)
good	tinyint(1)
position	int
custom_fields	json
created_at	datetime(3)	Index
updated_at	datetime(3)
states	json

order_line_item_download

10 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
position	int
access_granted	tinyint(1)
order_line_item_id	binary(16)	Index Foreign Key → order_line_item.id
order_line_item_version_id	binary(16)	Foreign Key → order_line_item.version_id
media_id	binary(16)	Index Foreign Key → media.id
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

order_tag

3 columns

Column	Type	Additional
order_id	binary(16)	Primary Key Foreign Key → order.id
order_version_id	binary(16)	Primary Key Foreign Key → order.version_id
tag_id	binary(16)	Primary Key Foreign Key → tag.id

order_transaction

11 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
order_id	binary(16)	Index Foreign Key → order.id
order_version_id	binary(16)	Foreign Key → order.version_id
state_id	binary(16)	Index Foreign Key → state_machine_state.id
payment_method_id	binary(16)	Index Foreign Key → payment_method.id
amount	json
custom_fields	json
created_at	datetime(3)	Index
updated_at	datetime(3)
validation_data	json

order_transaction_capture

10 columns

Column	Type	Additional
id	binary(16)	Primary Key
order_transaction_id	binary(16)	Index Foreign Key → order_transaction.id
order_transaction_version_id	binary(16)	Foreign Key → order_transaction.version_id
state_id	binary(16)	Index Foreign Key → state_machine_state.id
external_reference	varchar(255)
amount	json
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
version_id	binary(16)	Primary Key

order_transaction_capture_refund

11 columns

Column	Type	Additional
id	binary(16)	Primary Key
capture_id	binary(16)	Index Foreign Key → order_transaction_capture.id
state_id	binary(16)	Index Foreign Key → state_machine_state.id
reason	varchar(255)
amount	json
custom_fields	json
external_reference	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)
version_id	binary(16)	Primary Key
capture_version_id	binary(16)	Foreign Key → order_transaction_capture.version_id

order_transaction_capture_refund_position

13 columns

Column	Type	Additional
id	binary(16)	Primary Key
refund_id	binary(16)	Index Foreign Key → order_transaction_capture_refund.id
order_line_item_id	binary(16)	Index Foreign Key → order_line_item.id
order_line_item_version_id	binary(16)	Foreign Key → order_line_item.version_id
quantity	int
reason	varchar(255)
external_reference	varchar(255)
amount	json
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
version_id	binary(16)	Primary Key
refund_version_id	binary(16)	Foreign Key → order_transaction_capture_refund.version_id

payment_method

11 columns

Column	Type	Additional
id	binary(16)	Primary Key
handler_identifier	varchar(255)
position	int
active	tinyint(1)
after_order_enabled	tinyint(1)
availability_rule_id	binary(16)	Index Foreign Key → rule.id
plugin_id	binary(16)	Index Foreign Key → plugin.id
media_id	binary(16)	Index Foreign Key → media.id
created_at	datetime(3)
updated_at	datetime(3)
technical_name	varchar(255)	Unique

payment_method_translation

8 columns

Column	Type	Additional
payment_method_id	binary(16)	Primary Key Foreign Key → payment_method.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
distinguishable_name	varchar(255)
description	mediumtext
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

payment_token

3 columns

Column	Type	Additional
token	char(32)	Primary Key
expires	datetime(3)
consumed	tinyint(1)

plugin

18 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(255)	Unique
base_class	varchar(255)	Unique
composer_name	varchar(255)
active	tinyint(1)
managed_by_composer	tinyint(1)
path	varchar(255)
autoload	json
author	varchar(255)
copyright	varchar(255)
license	varchar(255)
version	varchar(255)
upgrade_version	varchar(255)
icon	mediumblob
installed_at	datetime(3)
upgraded_at	datetime(3)
created_at	datetime(3)
updated_at	datetime(3)

plugin_translation

9 columns

Column	Type	Additional
plugin_id	binary(16)	Primary Key Foreign Key → plugin.id
language_id	binary(16)	Primary Key Foreign Key → language.id
label	varchar(255)
description	longtext
manufacturer_link	text
support_link	text
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

product

76 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
auto_increment	int	Unique
product_number	varchar(64)	Index
active	tinyint unsigned
parent_id	binary(16)	Index Foreign Key → product.id
parent_version_id	binary(16)	Foreign Key → product.version_id
tax_id	binary(16)	Index Foreign Key → tax.id
product_manufacturer_id	binary(16)	Index Foreign Key → product_manufacturer.id
product_manufacturer_version_id	binary(16)	Foreign Key → product_manufacturer.version_id
delivery_time_id	binary(16)
deliveryTime	binary(16)
product_media_id	binary(16)	Index
product_media_version_id	binary(16)
cms_page_id	binary(16)	Index Foreign Key → cms_page.id
cms_page_version_id	binary(16)	Foreign Key → cms_page.version_id
unit_id	binary(16)	Index Foreign Key → unit.id
product_feature_set_id	binary(16)	Index Foreign Key → product_feature_set.id
category_tree	json
category_ids	json
stream_ids	json
option_ids	json
property_ids	json
tax	binary(16)
manufacturer	binary(16)
cover	binary(16)
unit	binary(16)
media	binary(16)
prices	binary(16)
visibilities	binary(16)
properties	binary(16)
categories	binary(16)	Index
translations	binary(16)
price	json
manufacturer_number	varchar(255)
ean	varchar(255)
sales	int
stock	int
available_stock	int
available	tinyint(1)
restock_time	int
is_closeout	tinyint(1)
purchase_steps	int unsigned
max_purchase	int unsigned
min_purchase	int unsigned
purchase_unit	decimal(11,4) unsigned
reference_unit	decimal(10,3) unsigned
shipping_free	tinyint(1)
purchase_prices	json
mark_as_topseller	tinyint unsigned
weight	decimal(15,6) unsigned
width	decimal(10,3) unsigned
height	decimal(10,3) unsigned
length	decimal(10,3) unsigned
release_date	datetime(3)
tag_ids	json
tags	binary(16)
variant_restrictions	json
created_at	datetime(3)
updated_at	datetime(3)
rating_average	float
display_group	varchar(50)
child_count	int
crossSellings	binary(16)
featureSet	binary(16)
customFieldSets	binary(16)
custom_field_set_selection_active	tinyint(1)
canonical_product_id	binary(16)	Index Foreign Key → product.id
canonical_product_version_id	binary(16)	Foreign Key → product.version_id
canonicalProduct	binary(16)
cmsPage	binary(16)
cheapest_price	longtext
cheapest_price_accessor	longtext
states	json
variant_listing_config	json
type	varchar(32)	Index

product_category

4 columns

Column	Type	Additional
product_id	binary(16)	Primary Key Foreign Key → product.id
product_version_id	binary(16)	Primary Key Foreign Key → product.version_id
category_id	binary(16)	Primary Key Foreign Key → category.id
category_version_id	binary(16)	Primary Key Foreign Key → category.version_id

product_category_tree

4 columns

Column	Type	Additional
product_id	binary(16)	Primary Key Foreign Key → product.id
product_version_id	binary(16)	Primary Key Foreign Key → product.version_id
category_id	binary(16)	Primary Key Foreign Key → category.id
category_version_id	binary(16)	Primary Key Foreign Key → category.version_id

product_configurator_setting

11 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
product_id	binary(16)	Index Foreign Key → product.id
product_version_id	binary(16)	Foreign Key → product.version_id
property_group_option_id	binary(16)	Index Foreign Key → property_group_option.id
price	json
position	int
media_id	binary(16)	Index Foreign Key → media.id
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

product_cross_selling

12 columns

Column	Type	Additional
id	binary(16)	Primary Key
type	varchar(255)
position	int
sort_by	varchar(255)
sort_direction	varchar(255)
active	tinyint(1)
limit	int
product_id	binary(16)	Index Foreign Key → product.id
product_version_id	binary(16)	Foreign Key → product.version_id
product_stream_id	binary(16)	Index Foreign Key → product_stream.id
created_at	datetime(3)
updated_at	datetime(3)

product_cross_selling_assigned_products

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
cross_selling_id	binary(16)	Index Foreign Key → product_cross_selling.id
product_id	binary(16)	Index Foreign Key → product.id
product_version_id	binary(16)	Foreign Key → product.version_id
position	int
created_at	datetime(3)
updated_at	datetime(3)

product_cross_selling_translation

5 columns

Column	Type	Additional
product_cross_selling_id	binary(16)	Primary Key Foreign Key → product_cross_selling.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)

product_custom_field_set

3 columns

Column	Type	Additional
custom_field_set_id	binary(16)	Primary Key Foreign Key → custom_field_set.id
product_id	binary(16)	Primary Key Foreign Key → product.id
product_version_id	binary(16)	Primary Key Foreign Key → product.version_id

product_download

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
position	int
product_id	binary(16)	Index Foreign Key → product.id
product_version_id	binary(16)	Foreign Key → product.version_id
media_id	binary(16)	Index Foreign Key → media.id
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

product_export

21 columns

Column	Type	Additional
id	binary(16)	Primary Key
product_stream_id	binary(16)	Index Foreign Key → product_stream.id
storefront_sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
sales_channel_domain_id	binary(16)	Index Foreign Key → sales_channel_domain.id
file_name	varchar(255)	Unique
access_key	varchar(255)
encoding	varchar(255)
file_format	varchar(255)
include_variants	tinyint(1)
generate_by_cronjob	tinyint(1)
generated_at	datetime(3)
interval	int
header_template	longtext
body_template	longtext
footer_template	longtext
created_at	datetime(3)
updated_at	datetime(3)
currency_id	binary(16)
paused_schedule	tinyint(1)
is_running	tinyint(1)

product_feature_set

4 columns

Column	Type	Additional
id	binary(16)	Primary Key
features	json
created_at	datetime(3)
updated_at	datetime(3)

product_feature_set_translation

6 columns

Column	Type	Additional
product_feature_set_id	binary(16)	Primary Key Foreign Key → product_feature_set.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
description	mediumtext
created_at	datetime(3)
updated_at	datetime(3)

product_keyword_dictionary

4 columns

Column	Type	Additional
id	binary(16)	Primary Key
language_id	binary(16)	Primary Key Foreign Key → language.id
keyword	varchar(500)
reversed	varchar(500)

product_manufacturer

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
media_id	binary(16)	Index Foreign Key → media.id
created_at	datetime(3)
updated_at	datetime(3)

product_manufacturer_translation

9 columns

Column	Type	Additional
product_manufacturer_id	binary(16)	Primary Key Foreign Key → product_manufacturer.id
product_manufacturer_version_id	binary(16)	Primary Key Foreign Key → product_manufacturer.version_id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
description	longtext
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
link	longtext

product_media

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
position	int
product_id	binary(16)	Index Foreign Key → product.id
product_version_id	binary(16)	Foreign Key → product.version_id
media_id	binary(16)	Index Foreign Key → media.id
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

product_option

3 columns

Column	Type	Additional
product_id	binary(16)	Primary Key Foreign Key → product.id
product_version_id	binary(16)	Primary Key Foreign Key → product.version_id
property_group_option_id	binary(16)	Primary Key Foreign Key → property_group_option.id

product_price

11 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
rule_id	binary(16)	Index Foreign Key → rule.id
product_id	binary(16)	Index Foreign Key → product.id
product_version_id	binary(16)	Foreign Key → product.version_id
price	json
quantity_start	int
quantity_end	int
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

product_property

3 columns

Column	Type	Additional
product_id	binary(16)	Primary Key Foreign Key → product.id
product_version_id	binary(16)	Primary Key Foreign Key → product.version_id
property_group_option_id	binary(16)	Primary Key Foreign Key → property_group_option.id

product_review

16 columns

Column	Type	Additional
id	binary(16)	Primary Key
product_id	binary(16)	Index Foreign Key → product.id
customer_id	binary(16)	Index Foreign Key → customer.id
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
language_id	binary(16)	Index Foreign Key → language.id
external_user	varchar(255)
external_email	varchar(255)
title	varchar(255)
content	longtext
points	double
status	tinyint(1)
comment	longtext
custom_fields	json
updated_at	datetime(3)
created_at	datetime(3)
product_version_id	binary(16)	Foreign Key → product.version_id

product_search_config

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
language_id	binary(16)	Unique Foreign Key → language.id
and_logic	tinyint(1)
min_search_length	smallint
excluded_terms	json
created_at	datetime(3)
updated_at	datetime(3)

product_search_config_field

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
product_search_config_id	binary(16)	Index Foreign Key → product_search_config.id
custom_field_id	binary(16)	Index Foreign Key → custom_field.id
field	varchar(255)	Index
tokenize	tinyint(1)
searchable	tinyint(1)
ranking	int
created_at	datetime(3)
updated_at	datetime(3)

product_search_keyword

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
version_id	binary(16)	Primary Key
language_id	binary(16)	Primary Key Foreign Key → language.id
product_id	binary(16)	Index Foreign Key → product.id
product_version_id	binary(16)	Foreign Key → product.version_id
keyword	varchar(255)	Index
ranking	double
created_at	datetime(3)
updated_at	datetime(3)

product_sorting

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
url_key	varchar(255)	Unique
priority	int unsigned
active	tinyint(1)
fields	json
created_at	datetime(3)
locked	tinyint(1)
updated_at	datetime(3)

product_sorting_translation

5 columns

Column	Type	Additional
product_sorting_id	binary(16)	Primary Key Foreign Key → product_sorting.id
language_id	binary(16)	Primary Key Foreign Key → language.id
label	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)

product_stream

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
api_filter	json
invalid	tinyint(1)
created_at	datetime(3)
updated_at	datetime(3)

product_stream_filter

12 columns

Column	Type	Additional
id	binary(16)	Primary Key
product_stream_id	binary(16)	Index Foreign Key → product_stream.id
parent_id	binary(16)	Index Foreign Key → product_stream_filter.id
type	varchar(255)
field	varchar(255)
operator	varchar(255)
value	longtext
parameters	longtext
position	int
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

product_stream_mapping

3 columns

Column	Type	Additional
product_id	binary(16)	Primary Key Foreign Key → product.id
product_version_id	binary(16)	Primary Key Foreign Key → product.version_id
product_stream_id	binary(16)	Primary Key Foreign Key → product_stream.id

product_stream_translation

7 columns

Column	Type	Additional
product_stream_id	binary(16)	Primary Key Foreign Key → product_stream.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
description	mediumtext
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

product_tag

3 columns

Column	Type	Additional
product_id	binary(16)	Primary Key Foreign Key → product.id
product_version_id	binary(16)	Primary Key Foreign Key → product.version_id
tag_id	binary(16)	Primary Key Foreign Key → tag.id

product_translation

15 columns

Column	Type	Additional
product_id	binary(16)	Primary Key Foreign Key → product.id
product_version_id	binary(16)	Primary Key Foreign Key → product.version_id
language_id	binary(16)	Primary Key Foreign Key → language.id
meta_description	varchar(255)
name	varchar(255)
keywords	mediumtext
description	mediumtext
meta_title	varchar(255)
pack_unit	varchar(255)
custom_fields	json
slot_config	json
created_at	datetime(3)
updated_at	datetime(3)
pack_unit_plural	varchar(255)
custom_search_keywords	json

product_visibility

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
product_id	binary(16)	Index Foreign Key → product.id
product_version_id	binary(16)	Foreign Key → product.version_id
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
visibility	int
created_at	datetime(3)
updated_at	datetime(3)

promotion

20 columns

Column	Type	Additional
id	binary(16)	Primary Key
active	tinyint(1)
valid_from	datetime
valid_until	datetime
max_redemptions_global	int
max_redemptions_per_customer	int
priority	int
order_count	int
orders_per_customer_count	json
exclusive	tinyint(1)
code	varchar(255)	Unique
use_codes	tinyint(1)
created_at	datetime(3)
updated_at	datetime(3)
customer_restriction	tinyint(1)
prevent_combination	tinyint(1)
exclusion_ids	json
use_individual_codes	tinyint(1)
individual_code_pattern	varchar(255)	Unique
use_setgroups	tinyint(1)

promotion_cart_rule

2 columns

Column	Type	Additional
promotion_id	binary(16)	Primary Key Foreign Key → promotion.id
rule_id	binary(16)	Primary Key Foreign Key → rule.id

promotion_discount

13 columns

Column	Type	Additional
id	binary(16)	Primary Key
promotion_id	binary(16)	Index Foreign Key → promotion.id
scope	varchar(32)
type	varchar(32)
value	double
created_at	datetime(3)
updated_at	datetime(3)
consider_advanced_rules	tinyint(1)
max_value	float
sorter_key	varchar(255)
applier_key	varchar(255)
usage_key	varchar(255)
picker_key	varchar(255)

promotion_discount_prices

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
discount_id	binary(16)	Index Foreign Key → promotion_discount.id
currency_id	binary(16)	Index Foreign Key → currency.id
price	float
created_at	datetime(3)
updated_at	datetime(3)

promotion_discount_rule

2 columns

Column	Type	Additional
discount_id	binary(16)	Primary Key Foreign Key → promotion_discount.id
rule_id	binary(16)	Primary Key Foreign Key → rule.id

promotion_individual_code

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
promotion_id	binary(16)	Index Foreign Key → promotion.id
code	varchar(255)	Unique
payload	json
created_at	datetime(3)
updated_at	datetime(3)

promotion_order_rule

2 columns

Column	Type	Additional
promotion_id	binary(16)	Primary Key Foreign Key → promotion.id
rule_id	binary(16)	Primary Key Foreign Key → rule.id

promotion_persona_customer

2 columns

Column	Type	Additional
promotion_id	binary(16)	Primary Key Foreign Key → promotion.id
customer_id	binary(16)	Primary Key Foreign Key → customer.id

promotion_persona_rule

2 columns

Column	Type	Additional
promotion_id	binary(16)	Primary Key Foreign Key → promotion.id
rule_id	binary(16)	Primary Key Foreign Key → rule.id

promotion_sales_channel

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
promotion_id	binary(16)	Index Foreign Key → promotion.id
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
priority	int
created_at	datetime(3)
updated_at	datetime(3)

promotion_setgroup

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
promotion_id	binary(16)	Index Foreign Key → promotion.id
packager_key	varchar(255)
sorter_key	varchar(255)
value	double
created_at	datetime(3)
updated_at	datetime(3)

promotion_setgroup_rule

2 columns

Column	Type	Additional
setgroup_id	binary(16)	Primary Key Foreign Key → promotion_setgroup.id
rule_id	binary(16)	Primary Key Foreign Key → rule.id

promotion_translation

6 columns

Column	Type	Additional
name	varchar(255)
promotion_id	binary(16)	Primary Key Foreign Key → promotion.id
language_id	binary(16)	Primary Key Foreign Key → language.id
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

property_group

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
sorting_type	varchar(50)
display_type	varchar(50)
created_at	datetime(3)
updated_at	datetime(3)
filterable	tinyint(1)
visible_on_product_detail_page	tinyint(1)

property_group_option

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
property_group_id	binary(16)	Index Foreign Key → property_group.id
color_hex_code	varchar(20)
media_id	binary(16)	Index Foreign Key → media.id
created_at	datetime(3)
updated_at	datetime(3)

property_group_option_translation

7 columns

Column	Type	Additional
property_group_option_id	binary(16)	Primary Key Foreign Key → property_group_option.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
position	int
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

property_group_translation

8 columns

Column	Type	Additional
property_group_id	binary(16)	Primary Key Foreign Key → property_group.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
description	longtext
position	int
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

refresh_token

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
user_id	binary(16)
token_id	varchar(80)	Unique
issued_at	datetime(3)
expires_at	datetime(3)

rule

11 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(500)
description	longtext
priority	int
payload	longblob
invalid	tinyint(1)
areas	json
module_types	json
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

rule_condition

10 columns

Column	Type	Additional
id	binary(16)	Primary Key
type	varchar(255)
rule_id	binary(16)	Index Foreign Key → rule.id
script_id	binary(16)	Index Foreign Key → app_script_condition.id
parent_id	binary(16)	Index Foreign Key → rule_condition.id
value	json
position	int
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

rule_tag

2 columns

Column	Type	Additional
rule_id	binary(16)	Primary Key Foreign Key → rule.id
tag_id	binary(16)	Primary Key Foreign Key → tag.id

sales_channel

32 columns

Column	Type	Additional
id	binary(16)	Primary Key
type_id	binary(16)	Index Foreign Key → sales_channel_type.id
short_name	varchar(45)
configuration	json
access_key	varchar(255)	Unique
language_id	binary(16)	Index Foreign Key → language.id
currency_id	binary(16)	Index Foreign Key → currency.id
payment_method_id	binary(16)	Index Foreign Key → payment_method.id
shipping_method_id	binary(16)	Index Foreign Key → shipping_method.id
country_id	binary(16)	Index Foreign Key → country.id
navigation_category_id	binary(16)	Index Foreign Key → category.id
navigation_category_version_id	binary(16)	Foreign Key → category.version_id
navigation_category_depth	int
hreflang_active	tinyint unsigned
hreflang_default_domain_id	binary(16)	Index Foreign Key → sales_channel_domain.id
footer_category_id	binary(16)	Index Foreign Key → category.id
footer_category_version_id	binary(16)	Foreign Key → category.version_id
service_category_id	binary(16)	Index Foreign Key → category.id
service_category_version_id	binary(16)	Foreign Key → category.version_id
active	tinyint(1)
maintenance	tinyint(1)
maintenance_ip_whitelist	json
customer_group_id	binary(16)	Index Foreign Key → customer_group.id
mail_header_footer_id	binary(16)	Index Foreign Key → mail_header_footer.id
payment_method_ids	json
analytics_id	binary(16)	Index Foreign Key → sales_channel_analytics.id
tax_calculation_type	varchar(50)
created_at	datetime(3)
updated_at	datetime(3)
home_cms_page_id	binary(16)	Index Foreign Key → cms_page.id
home_cms_page_version_id	binary(16)	Foreign Key → cms_page.version_id
measurement_units	json

sales_channel_analytics

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
tracking_id	varchar(50)
active	tinyint(1)
track_orders	tinyint(1)
created_at	datetime(3)
updated_at	datetime(3)
anonymize_ip	tinyint(1)
track_offcanvas_cart	tinyint(1)

sales_channel_api_context

5 columns

Column	Type	Additional
token	varchar(255)	Primary Key
payload	json
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
customer_id	binary(16)	Index Foreign Key → customer.id
updated_at	datetime

sales_channel_country

2 columns

Column	Type	Additional
sales_channel_id	binary(16)	Primary Key Foreign Key → sales_channel.id
country_id	binary(16)	Primary Key Foreign Key → country.id

sales_channel_currency

2 columns

Column	Type	Additional
sales_channel_id	binary(16)	Primary Key Foreign Key → sales_channel.id
currency_id	binary(16)	Primary Key Foreign Key → currency.id

sales_channel_domain

11 columns

Column	Type	Additional
id	binary(16)	Primary Key
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
language_id	binary(16)	Index Foreign Key → language.id
url	varchar(255)	Unique
currency_id	binary(16)	Index Foreign Key → currency.id
snippet_set_id	binary(16)	Index Foreign Key → snippet_set.id
hreflang_use_only_locale	tinyint unsigned
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
measurement_units	json

sales_channel_language

2 columns

Column	Type	Additional
sales_channel_id	binary(16)	Primary Key Foreign Key → sales_channel.id
language_id	binary(16)	Primary Key Foreign Key → language.id

sales_channel_payment_method

2 columns

Column	Type	Additional
sales_channel_id	binary(16)	Primary Key Foreign Key → sales_channel.id
payment_method_id	binary(16)	Primary Key Foreign Key → payment_method.id

sales_channel_shipping_method

2 columns

Column	Type	Additional
sales_channel_id	binary(16)	Primary Key Foreign Key → sales_channel.id
shipping_method_id	binary(16)	Primary Key Foreign Key → shipping_method.id

sales_channel_translation

12 columns

Column	Type	Additional
sales_channel_id	binary(16)	Primary Key Foreign Key → sales_channel.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
home_keywords	varchar(255)
home_meta_description	varchar(255)
home_meta_title	varchar(255)
home_name	varchar(255)
home_enabled	tinyint
home_slot_config	json
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

sales_channel_type

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
cover_url	varchar(500)
icon_name	varchar(255)
screenshot_urls	json
created_at	datetime(3)
updated_at	datetime(3)

sales_channel_type_translation

9 columns

Column	Type	Additional
sales_channel_type_id	binary(16)	Primary Key Foreign Key → sales_channel_type.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
manufacturer	varchar(255)
description	varchar(255)
description_long	longtext
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

salutation

4 columns

Column	Type	Additional
id	binary(16)	Primary Key
salutation_key	varchar(255)	Unique
created_at	datetime(3)
updated_at	datetime(3)

salutation_translation

7 columns

Column	Type	Additional
salutation_id	binary(16)	Primary Key Foreign Key → salutation.id
language_id	binary(16)	Primary Key Foreign Key → language.id
display_name	varchar(255)
letter_name	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

scheduled_task

10 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(255)
scheduled_task_class	varchar(512)	Unique
run_interval	int
status	varchar(255)
last_execution_time	datetime(3)
next_execution_time	datetime(3)
created_at	datetime(3)
updated_at	datetime(3)
default_run_interval	int

script

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
script	longtext
hook	varchar(255)	Index
name	varchar(1024)
active	tinyint(1)
app_id	binary(16)	Index Foreign Key → app.id
created_at	datetime(3)
updated_at	datetime(3)

seo_url

13 columns

Column	Type	Additional
id	binary(16)	Primary Key
language_id	binary(16)	Index Foreign Key → language.id
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
foreign_key	binary(16)	Index
route_name	varchar(50)
path_info	varchar(750)
seo_path_info	varchar(750)
is_canonical	tinyint(1)
is_modified	tinyint(1)
is_deleted	tinyint(1)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

seo_url_template

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
route_name	varchar(255)
entity_name	varchar(64)
template	varchar(750)
is_valid	tinyint(1)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

shipping_method

11 columns

Column	Type	Additional
id	binary(16)	Primary Key
active	tinyint unsigned
position	int
availability_rule_id	binary(16)	Index Foreign Key → rule.id
media_id	binary(16)	Index Foreign Key → media.id
delivery_time_id	binary(16)	Index Foreign Key → delivery_time.id
tax_type	varchar(50)
tax_id	binary(16)	Index Foreign Key → tax.id
created_at	datetime(3)
updated_at	datetime(3)
technical_name	varchar(255)	Unique

shipping_method_price

11 columns

Column	Type	Additional
id	binary(16)	Primary Key
shipping_method_id	binary(16)	Index Foreign Key → shipping_method.id
calculation	int unsigned
rule_id	binary(16)	Index Foreign Key → rule.id
calculation_rule_id	binary(16)	Index Foreign Key → rule.id
currency_price	json
quantity_start	double
quantity_end	double
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

shipping_method_tag

2 columns

Column	Type	Additional
shipping_method_id	binary(16)	Primary Key Foreign Key → shipping_method.id
tag_id	binary(16)	Primary Key Foreign Key → tag.id

shipping_method_translation

8 columns

Column	Type	Additional
shipping_method_id	binary(16)	Primary Key Foreign Key → shipping_method.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
description	mediumtext
tracking_url	mediumtext
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

snippet

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
translation_key	varchar(255)
value	longtext
author	varchar(255)
snippet_set_id	binary(16)	Index Foreign Key → snippet_set.id
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

snippet_set

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(255)
base_file	varchar(255)
iso	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

state_machine

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
technical_name	varchar(255)	Unique
initial_state_id	binary(16)	Index Foreign Key → state_machine_state.id
created_at	datetime(3)
updated_at	datetime(3)

state_machine_history

12 columns

Column	Type	Additional
id	binary(16)	Primary Key
state_machine_id	binary(16)	Index Foreign Key → state_machine.id
entity_name	varchar(100)
from_state_id	binary(16)	Index Foreign Key → state_machine_state.id
to_state_id	binary(16)	Index Foreign Key → state_machine_state.id
action_name	varchar(255)
user_id	binary(16)	Index Foreign Key → user.id
created_at	datetime(3)
updated_at	datetime(3)
referenced_id	binary(16)	Index
referenced_version_id	binary(16)
integration_id	binary(16)	Index Foreign Key → integration.id

state_machine_state

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
technical_name	varchar(255)	Index
state_machine_id	binary(16)	Index Foreign Key → state_machine.id
created_at	datetime(3)
updated_at	datetime(3)

state_machine_state_translation

6 columns

Column	Type	Additional
language_id	binary(16)	Primary Key Foreign Key → language.id
state_machine_state_id	binary(16)	Primary Key Foreign Key → state_machine_state.id
name	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

state_machine_transition

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
action_name	varchar(255)	Index
state_machine_id	binary(16)	Index Foreign Key → state_machine.id
from_state_id	binary(16)	Index Foreign Key → state_machine_state.id
to_state_id	binary(16)	Index Foreign Key → state_machine_state.id
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

state_machine_translation

6 columns

Column	Type	Additional
language_id	binary(16)	Primary Key Foreign Key → language.id
state_machine_id	binary(16)	Primary Key Foreign Key → state_machine.id
name	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

system_config

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
configuration_key	varchar(255)	Index
configuration_value	json
sales_channel_id	binary(16)	Index Foreign Key → sales_channel.id
created_at	datetime(3)
updated_at	datetime(3)

tag

4 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)

tax

7 columns

Column	Type	Additional
id	binary(16)	Primary Key
tax_rate	decimal(10,3)	Index
name	varchar(255)
position	int
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

tax_provider

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
active	tinyint unsigned
priority	int
identifier	varchar(255)	Unique
availability_rule_id	binary(16)	Index Foreign Key → rule.id
app_id	binary(16)	Index Foreign Key → app.id
process_url	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)

tax_provider_translation

6 columns

Column	Type	Additional
tax_provider_id	binary(16)	Primary Key Foreign Key → tax_provider.id
language_id	binary(16)	Primary Key Foreign Key → language.id
name	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

tax_rule

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
tax_id	binary(16)	Index Foreign Key → tax.id
tax_rule_type_id	binary(16)	Index Foreign Key → tax_rule_type.id
country_id	binary(16)	Index Foreign Key → country.id
tax_rate	double(10,3)
data	json
created_at	datetime(3)
updated_at	datetime(3)
active_from	datetime(3)

tax_rule_type

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
technical_name	varchar(255)	Unique
position	int
created_at	datetime(3)
updated_at	datetime(3)

tax_rule_type_translation

5 columns

Column	Type	Additional
tax_rule_type_id	binary(16)	Primary Key Foreign Key → tax_rule_type.id
language_id	binary(16)	Primary Key Foreign Key → language.id
type_name	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)

theme

12 columns

Column	Type	Additional
id	binary(16)	Primary Key
technical_name	varchar(255)	Unique
name	varchar(255)
author	varchar(255)
preview_media_id	binary(16)	Index Foreign Key → media.id
parent_theme_id	binary(16)
base_config	json
config_values	json
created_at	datetime(3)
updated_at	datetime(3)
active	tinyint(1)
theme_json	json

theme_child

2 columns

Column	Type	Additional
parent_id	binary(16)	Primary Key Foreign Key → theme.id
child_id	binary(16)	Primary Key Foreign Key → theme.id

theme_media

2 columns

Column	Type	Additional
theme_id	binary(16)	Primary Key Foreign Key → theme.id
media_id	binary(16)	Primary Key Foreign Key → media.id

theme_runtime_config

7 columns

Column	Type	Additional
theme_id	binary(16)	Primary Key
technical_name	varchar(255)	Unique
resolved_config	json
view_inheritance	json
script_files	json
icon_sets	json
updated_at	datetime(3)

theme_sales_channel

2 columns

Column	Type	Additional
theme_id	binary(16)	Index Foreign Key → theme.id
sales_channel_id	binary(16)	Primary Key Foreign Key → sales_channel.id

theme_translation

8 columns

Column	Type	Additional
theme_id	binary(16)	Primary Key Foreign Key → theme.id
language_id	binary(16)	Primary Key Foreign Key → language.id
description	mediumtext
labels	json
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
help_texts	json

unit

3 columns

Column	Type	Additional
id	binary(16)	Primary Key
created_at	datetime(3)
updated_at	datetime(3)

unit_translation

7 columns

Column	Type	Additional
unit_id	binary(16)	Primary Key Foreign Key → unit.id
language_id	binary(16)	Primary Key Foreign Key → language.id
short_code	varchar(255)
name	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

usage_data_entity_deletion

4 columns

Column	Type	Additional
id	binary(16)	Primary Key
entity_ids	json
entity_name	varchar(255)
deleted_at	datetime(3)

user

17 columns

Column	Type	Additional
id	binary(16)	Primary Key
username	varchar(255)	Unique
password	varchar(255)
first_name	varchar(255)
last_name	varchar(255)
title	varchar(255)
email	varchar(255)	Unique
active	tinyint(1)
admin	tinyint(1)
avatar_id	binary(16)	Index Foreign Key → media.id
locale_id	binary(16)	Index Foreign Key → locale.id
store_token	varchar(255)
last_updated_password_at	datetime(3)
time_zone	varchar(255)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

user_access_key

8 columns

Column	Type	Additional
id	binary(16)	Primary Key
user_id	binary(16)	Index Foreign Key → user.id
access_key	varchar(255)	Index
secret_access_key	varchar(255)
last_usage_at	datetime(3)
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)

user_config

6 columns

Column	Type	Additional
id	binary(16)	Primary Key
user_id	binary(16)	Index Foreign Key → user.id
key	varchar(255)
value	json
created_at	datetime(3)
updated_at	datetime(3)

user_recovery

5 columns

Column	Type	Additional
id	binary(16)	Primary Key
user_id	binary(16)	Unique Foreign Key → user.id
hash	varchar(255)
created_at	datetime(3)
updated_at	datetime(3)

version

4 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(255)
created_at	datetime(3)	Index
updated_at	datetime(3)

version_commit

9 columns

Column	Type	Additional
id	binary(16)	Primary Key
auto_increment	bigint	Unique
is_merge	tinyint(1)
message	varchar(5000)
user_id	binary(16)
integration_id	binary(16)
version_id	binary(16)
created_at	datetime(3)	Index
updated_at	datetime(3)

version_commit_data

11 columns

Column	Type	Additional
id	binary(16)	Primary Key
auto_increment	bigint	Unique
version_commit_id	binary(16)	Index Foreign Key → version_commit.id
entity_name	varchar(100)
entity_id	json
action	varchar(100)
payload	json
user_id	binary(16)
integration_id	binary(16)
created_at	datetime(3)
updated_at	datetime(3)

webhook

10 columns

Column	Type	Additional
id	binary(16)	Primary Key
name	varchar(255)	Index
event_name	varchar(500)
url	varchar(500)
app_id	binary(16)	Index Foreign Key → app.id
active	tinyint(1)
created_at	datetime(3)
updated_at	datetime(3)
error_count	int
only_live_version	tinyint unsigned

webhook_event_log

18 columns

Column	Type	Additional
id	binary(16)	Primary Key
app_name	varchar(255)
webhook_name	text
event_name	varchar(255)
delivery_status	varchar(255)
timestamp	int
processing_time	int
app_version	varchar(255)
request_content	json
response_content	json
response_status_code	int
response_reason_phrase	varchar(255)
url	varchar(500)
serialized_webhook_message	longblob
custom_fields	json
created_at	datetime(3)
updated_at	datetime(3)
only_live_version	tinyint unsigned