Database Schema Shopware 5.6.2

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

See what changed since Shopware 5.6.1 →

Shopware 5.6.2

Shopware Version

Shopware 5

Shopware 6

s_addon_premiums

5 columns

Free premium/gift products offered when the cart exceeds a certain value.

Column	Type	Nullable	Additional
id	int(6)	NO	Primary Key
startprice	double	NO
ordernumber	varchar(255)	NO
ordernumber_export	varchar(255)	NO
subshopID	int(11)	NO

View full details →

s_article_configurator_dependencies

4 columns

Dependency rules between variant options (e.g. color 'Red' only available with size 'XL').

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
configurator_set_id	int(10) unsigned	NO	Index
parent_id	int(11) unsigned	YES
child_id	int(11) unsigned	YES

View full details →

s_article_configurator_groups

4 columns

Variant groups (e.g. 'Color', 'Size') used to define product configurators.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
name	varchar(255)	NO
description	text	YES
position	int(11)	NO

View full details →

s_article_configurator_groups_attributes

2 columns

Custom attribute extensions for variant configurator groups.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
groupID	int(11) unsigned	NO	Index Foreign Key → s_article_configurator_groups.id

View full details →

s_article_configurator_option_relations

3 columns

Links variant options to configurator sets (which options are available for a product).

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
article_id	int(11) unsigned	NO	Index
option_id	int(11) unsigned	NO

View full details →

s_article_configurator_options

5 columns

Individual variant options within a group (e.g. 'Red', 'Blue', 'XL').

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
group_id	int(11) unsigned	YES	Index
name	varchar(255)	NO
position	int(11)	NO
media_id	int(11)	YES

View full details →

s_article_configurator_options_attributes

2 columns

Custom attribute extensions for variant configurator options.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
optionID	int(11) unsigned	NO	Index Foreign Key → s_article_configurator_options.id

View full details →

s_article_configurator_price_variations

5 columns

Price surcharges/discounts per variant option combination (e.g. +5€ for size XL).

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
configurator_set_id	int(10) unsigned	NO	Index
variation	decimal(10,3)	NO
options	text	YES
is_gross	int(1)	YES

View full details →

s_article_configurator_set_group_relations

2 columns

Links configurator sets to their variant groups.

Column	Type	Nullable	Additional
set_id	int(11) unsigned	NO	Primary Key
group_id	int(11) unsigned	NO	Primary Key

View full details →

s_article_configurator_set_option_relations

2 columns

Links configurator sets to their available options.

Column	Type	Nullable	Additional
set_id	int(11) unsigned	NO	Primary Key
option_id	int(11) unsigned	NO	Primary Key

View full details →

s_article_configurator_sets

4 columns

Named configurator sets that define which variant groups/options a product uses.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
name	varchar(255)	NO	Index
public	tinyint(1)	NO
type	int(11)	NO

View full details →

s_article_configurator_template_prices

8 columns

Price templates for variant generation — base prices applied when creating variants.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
template_id	int(10) unsigned	YES	Index
customer_group_key	varchar(15)	YES	Index
from	int(10) unsigned	NO
to	varchar(30)	NO
price	double	NO
pseudoprice	double	YES
percent	decimal(10,2)	YES

View full details →

s_article_configurator_template_prices_attributes

2 columns

Custom attribute extensions for configurator template prices.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
template_price_id	int(11) unsigned	YES	Unique Foreign Key → s_article_configurator_template_prices.id

View full details →

s_article_configurator_templates

28 columns

Templates defining default values for auto-generated variants.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
article_id	int(11) unsigned	NO	Index
order_number	varchar(255)	NO
suppliernumber	varchar(255)	YES
additionaltext	varchar(255)	YES
impressions	int(11)	NO
sales	int(11)	NO
active	int(11) unsigned	NO
instock	int(11)	YES
stockmin	int(11) unsigned	YES
laststock	tinyint(4)	NO
weight	decimal(10,3) unsigned	YES
position	int(11) unsigned	NO
width	decimal(10,3) unsigned	YES
height	decimal(10,3) unsigned	YES
length	decimal(10,3) unsigned	YES
ean	varchar(255)	YES
unit_id	int(11) unsigned	YES
purchasesteps	int(11) unsigned	YES
maxpurchase	int(11) unsigned	YES
minpurchase	int(11) unsigned	YES
purchaseunit	decimal(11,4) unsigned	YES
referenceunit	decimal(10,3) unsigned	YES
packunit	varchar(255)	YES
releasedate	date	YES
shippingfree	int(1) unsigned	NO
shippingtime	varchar(11)	YES
purchaseprice	double	NO

View full details →

s_article_configurator_templates_attributes

22 columns

Custom attribute extensions for configurator templates.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
template_id	int(11) unsigned	YES	Index Foreign Key → s_article_configurator_templates.id
attr1	text	YES
attr2	text	YES
attr3	text	YES
attr4	text	YES
attr5	text	YES
attr6	text	YES
attr7	text	YES
attr8	text	YES
attr9	text	YES
attr10	text	YES
attr11	text	YES
attr12	text	YES
attr13	text	YES
attr14	text	YES
attr15	text	YES
attr16	text	YES
attr17	text	YES
attr18	text	YES
attr19	text	YES
attr20	text	YES

View full details →

s_article_img_mapping_rules

3 columns

Rules that map specific variant option combinations to product images.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
mapping_id	int(11)	NO	Index
option_id	int(11)	NO	Index

View full details →

s_article_img_mappings

2 columns

Image-to-variant mappings — assigns specific images to variant combinations.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
image_id	int(11)	NO	Index

View full details →

s_articles

26 columns

Core product (article) master data — name, description, tax, supplier, and general settings.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
supplierID	int(11) unsigned	YES	Index
name	varchar(100)	NO	Index
description	mediumtext	YES
description_long	mediumtext	YES
shippingtime	varchar(11)	YES	Index
datum	date	YES	Index
active	int(1) unsigned	NO	Index
taxID	int(11) unsigned	YES
pseudosales	int(11)	NO
topseller	int(1) unsigned	NO
metaTitle	varchar(255)	YES
keywords	varchar(255)	YES
changetime	datetime	NO	Index
pricegroupID	int(11) unsigned	YES
pricegroupActive	int(1) unsigned	NO
filtergroupID	int(11) unsigned	YES
laststock	int(1)	NO
crossbundlelook	int(1) unsigned	NO
notification	int(1) unsigned	NO
template	varchar(255)	NO
mode	int(11)	NO
main_detail_id	int(11) unsigned	YES	Unique
available_from	datetime	YES
available_to	datetime	YES
configurator_set_id	int(11) unsigned	YES	Index

View full details →

s_articles_also_bought_ro

4 columns

Pre-computed 'customers also bought' product relations (read-optimized cache table).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
article_id	int(11) unsigned	NO	Index
related_article_id	int(11)	NO	Index
sales	int(11) unsigned	NO

View full details →

s_articles_attributes

22 columns

Custom attribute extensions for products (free-text fields, custom data).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
articledetailsID	int(11) unsigned	YES	Unique Foreign Key → s_articles_details.id
attr1	text	YES
attr2	text	YES
attr3	text	YES
attr4	text	YES
attr5	text	YES
attr6	text	YES
attr7	text	YES
attr8	text	YES
attr9	text	YES
attr10	text	YES
attr11	text	YES
attr12	text	YES
attr13	text	YES
attr14	text	YES
attr15	text	YES
attr16	text	YES
attr17	text	YES
attr18	text	YES
attr19	text	YES
attr20	text	YES

View full details →

s_articles_avoid_customergroups

2 columns

Products excluded from visibility for specific customer groups.

Column	Type	Nullable	Additional
articleID	int(11)	NO	Primary Key
customergroupID	int(11)	NO	Primary Key

View full details →

s_articles_categories

3 columns

Direct product-to-category assignments.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
articleID	int(11) unsigned	NO	Index
categoryID	int(11) unsigned	NO	Index

View full details →

s_articles_categories_ro

4 columns

Denormalized product-to-category mapping including parent categories (read-optimized).

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
articleID	int(11) unsigned	NO	Index
categoryID	int(11) unsigned	NO	Index
parentCategoryID	int(11) unsigned	NO

View full details →

s_articles_categories_seo

4 columns

SEO canonical category assignment per product and shop (for breadcrumbs and canonical URLs).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
shop_id	int(11)	NO	Index
article_id	int(11)	NO
category_id	int(11)	NO

View full details →

s_articles_details

28 columns

Product variants (details) — each row is a variant with its own order number, stock, prices, and EAN.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
articleID	int(11) unsigned	NO	Index
ordernumber	varchar(255)	NO	Unique
suppliernumber	varchar(255)	YES
kind	int(1)	NO	Index
additionaltext	varchar(255)	YES
sales	int(11)	NO	Index
active	int(11) unsigned	NO
instock	int(11)	NO
stockmin	int(11) unsigned	YES
laststock	int(1)	NO
weight	decimal(10,3) unsigned	YES
position	int(11) unsigned	NO
width	decimal(10,3) unsigned	YES
height	decimal(10,3) unsigned	YES
length	decimal(10,3) unsigned	YES
ean	varchar(255)	YES
unitID	int(11) unsigned	YES
purchasesteps	int(11) unsigned	YES
maxpurchase	int(11) unsigned	YES
minpurchase	int(11) unsigned	NO
purchaseunit	decimal(11,4) unsigned	YES
referenceunit	decimal(10,3) unsigned	YES
packunit	varchar(255)	YES
releasedate	date	YES	Index
shippingfree	int(1) unsigned	NO
shippingtime	varchar(11)	YES
purchaseprice	double	NO

View full details →

s_articles_downloads

5 columns

Downloadable files attached to products (for digital goods).

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
articleID	int(11) unsigned	NO	Index
description	varchar(255)	NO
filename	varchar(255)	NO
size	double	NO

View full details →

s_articles_downloads_attributes

2 columns

Custom attribute extensions for product downloads.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
downloadID	int(11) unsigned	YES	Unique Foreign Key → s_articles_downloads.id

View full details →

s_articles_esd

8 columns

Electronic Software Distribution — digital product delivery configuration (serial numbers, download).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
articleID	int(11)	NO	Index
articledetailsID	int(11)	NO	Index
file	varchar(255)	NO
serials	int(1)	NO
notification	int(1)	NO
maxdownloads	int(11)	NO
datum	datetime	NO

View full details →

s_articles_esd_attributes

2 columns

Custom attribute extensions for ESD products.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
esdID	int(11)	YES	Unique Foreign Key → s_articles_esd.id

View full details →

s_articles_esd_serials

3 columns

Serial numbers/license keys available for ESD product distribution.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
serialnumber	varchar(255)	NO
esdID	int(11)	NO	Index

View full details →

s_articles_img

13 columns

Product images with position ordering, main image flag, and variant mappings.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
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

View full details →

s_articles_img_attributes

5 columns

Custom attribute extensions for product images.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
imageID	int(11)	YES	Unique Foreign Key → s_articles_img.id
attribute1	text	YES
attribute2	text	YES
attribute3	text	YES

View full details →

s_articles_information

5 columns

Product information links (external URLs displayed in the product detail 'Further links' section).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
articleID	int(11)	NO	Index
description	varchar(255)	NO
link	varchar(255)	NO
target	varchar(30)	NO

View full details →

s_articles_information_attributes

2 columns

Custom attribute extensions for product information links.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
informationID	int(11)	YES	Unique Foreign Key → s_articles_information.id

View full details →

s_articles_notification

7 columns

Customer notification requests — 'notify me when back in stock' email registrations.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
ordernumber	varchar(255)	NO
date	datetime	NO
mail	varchar(255)	NO
send	int(1) unsigned	NO
language	varchar(255)	NO
shopLink	varchar(255)	NO

View full details →

s_articles_notification_attributes

2 columns

Custom attribute extensions for stock notification entries.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
notificationID	int(11) unsigned	NO	Index Foreign Key → s_articles_notification.id

View full details →

s_articles_prices

10 columns

Product prices — graduated/quantity pricing per customer group and variant.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
pricegroup	varchar(15)	YES	Index
from	int(10) unsigned	NO
to	varchar(30)	NO
articleID	int(11)	NO	Index
articledetailsID	int(11)	NO	Index
price	double	NO
pseudoprice	double	YES
baseprice	double	YES
percent	decimal(10,2)	YES

View full details →

s_articles_prices_attributes

2 columns

Custom attribute extensions for product prices.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
priceID	int(11) unsigned	YES	Unique Foreign Key → s_articles_prices.id

View full details →

s_articles_relationships

3 columns

Manual 'related products' assignments between articles.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
articleID	int(30)	NO	Index
relatedarticle	varchar(30)	NO

View full details →

s_articles_similar

3 columns

Manual 'similar products' assignments between articles.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
articleID	int(30)	NO	Index
relatedarticle	varchar(255)	NO

View full details →

s_articles_similar_shown_ro

5 columns

Pre-computed 'customers also viewed' product relations (read-optimized cache table).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
article_id	int(11) unsigned	NO	Index
related_article_id	int(11)	NO
viewed	int(11) unsigned	NO	Index
init_date	datetime	NO

View full details →

s_articles_supplier

9 columns

Product manufacturers/brands (called 'suppliers' in SW5) with logo and description.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(100)	NO
img	varchar(255)	NO
link	varchar(100)	NO
description	longtext	YES
meta_title	varchar(255)	YES
meta_description	varchar(255)	YES
meta_keywords	varchar(255)	YES
changed	datetime	NO

View full details →

s_articles_supplier_attributes

2 columns

Custom attribute extensions for suppliers/manufacturers.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
supplierID	int(11)	YES	Unique Foreign Key → s_articles_supplier.id

View full details →

s_articles_top_seller_ro

4 columns

Pre-computed bestseller ranking data (read-optimized cache table).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
article_id	int(11) unsigned	NO	Unique
sales	int(11) unsigned	NO	Index
last_cleared	datetime	YES

View full details →

s_articles_translations

14 columns

Product translations for multilingual shops (name, description, keywords per language).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
articleID	int(11)	NO	Index
languageID	int(11)	NO
name	varchar(255)	NO
keywords	mediumtext	NO
description	mediumtext	NO
description_long	mediumtext	NO
description_clear	mediumtext	NO
shippingtime	mediumtext	NO
attr1	varchar(255)	NO
attr2	varchar(255)	NO
attr3	varchar(255)	NO
attr4	varchar(255)	NO
attr5	varchar(255)	NO

View full details →

s_articles_vote

12 columns

Customer product reviews/ratings with title, comment, star rating, and approval status.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
articleID	int(11)	NO	Index
name	varchar(255)	NO
headline	varchar(255)	NO
comment	mediumtext	NO
points	double	NO	Index
datum	datetime	NO
active	int(11)	NO
email	varchar(255)	NO
answer	text	NO
answer_date	datetime	YES
shop_id	int(11)	YES

View full details →

s_attribute_configuration

14 columns

Configuration of custom free-text attribute fields (column name, type, label, help text).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
table_name	varchar(255)	NO	Index
column_name	varchar(255)	NO
column_type	varchar(255)	NO
default_value	varchar(500)	YES
position	int(11)	NO
translatable	int(1)	NO
display_in_backend	int(1)	NO
custom	int(1)	NO
help_text	text	YES
support_text	varchar(500)	YES
label	varchar(255)	YES
entity	varchar(500)	YES
array_store	mediumtext	YES

View full details →

s_benchmark_config

16 columns

Configuration for the Shopware Benchmark anonymous performance comparison tool.

Column	Type	Nullable	Additional
id	binary(16)	NO	Primary Key
shop_id	int(11)	NO	Unique
active	tinyint(1)	NO
last_sent	datetime	NO
last_received	datetime	NO
last_order_id	int(11)	NO
last_customer_id	int(11)	NO
last_product_id	int(11)	NO
last_analytics_id	int(11)	NO
last_updated_orders_date	datetime	YES
batch_size	int(11)	NO
industry	int(11)	YES
type	varchar(20)	YES
response_token	varchar(200)	YES
cached_template	longtext	YES
locked	datetime	YES

View full details →

s_billing_template

8 columns

Billing address templates used for document generation.

Column	Type	Nullable	Additional
ID	int(11)	NO	Primary Key
name	varchar(255)	NO
value	mediumtext	NO
typ	mediumint(11)	NO
group	varchar(255)	NO
desc	varchar(255)	NO
position	int(11)	NO
show	int(1)	NO

View full details →

s_blog

14 columns

Blog articles with title, content, author, and publication date.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
title	varchar(255)	NO
author_id	int(11)	YES
active	int(1)	NO
short_description	text	NO
description	mediumtext	NO
views	int(11) unsigned	YES
display_date	datetime	NO	Index
category_id	int(11) unsigned	YES
template	varchar(255)	NO
meta_keywords	varchar(255)	YES
meta_description	varchar(150)	YES
meta_title	varchar(255)	YES
shop_ids	varchar(255)	YES

View full details →

s_blog_assigned_articles

3 columns

Links blog posts to related products displayed alongside the blog entry.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
blog_id	int(11) unsigned	NO	Index
article_id	int(11) unsigned	NO

View full details →

s_blog_attributes

8 columns

Custom attribute extensions for blog posts.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
blog_id	int(11) unsigned	YES	Index Foreign Key → s_blog.id
attribute1	text	YES
attribute2	text	YES
attribute3	text	YES
attribute4	text	YES
attribute5	text	YES
attribute6	text	YES

View full details →

s_blog_comments

10 columns

Customer comments on blog posts.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
blog_id	int(11) unsigned	YES
name	varchar(255)	NO
headline	varchar(255)	NO
comment	mediumtext	NO
creation_date	datetime	NO
active	int(1)	NO
email	varchar(255)	NO
points	double	NO
shop_id	int(11)	YES

View full details →

s_blog_media

4 columns

Media/image assignments for blog posts.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
blog_id	int(11) unsigned	NO	Index
media_id	int(11) unsigned	NO
preview	int(1)	NO

View full details →

s_blog_tags

3 columns

Tags assigned to blog posts for categorization and filtering.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
blog_id	int(11) unsigned	YES	Index
name	varchar(255)	NO

View full details →

s_campaigns_articles

6 columns

Products featured in email newsletter campaigns.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
parentID	int(11)	NO
articleordernumber	varchar(255)	NO
name	varchar(255)	NO
type	varchar(30)	NO
position	int(11)	NO

View full details →

s_campaigns_banner

6 columns

Banner images used in email newsletter campaigns.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
parentID	int(11)	NO
image	varchar(255)	NO
link	varchar(255)	NO
linkTarget	varchar(255)	NO
description	varchar(255)	NO

View full details →

s_campaigns_containers

6 columns

Layout containers structuring email newsletter campaign content.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
promotionID	int(11)	YES
value	varchar(255)	NO
type	varchar(255)	NO
description	varchar(255)	NO
position	int(11)	NO

View full details →

s_campaigns_groups

2 columns

Newsletter recipient groups for targeted email campaigns.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO

View full details →

s_campaigns_html

7 columns

Custom HTML content blocks within email newsletter campaigns.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
parentID	int(11)	YES
headline	varchar(255)	NO
html	mediumtext	NO
image	varchar(255)	NO
link	varchar(255)	NO
alignment	varchar(255)	NO

View full details →

s_campaigns_links

6 columns

Link elements within email newsletter campaigns.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
parentID	int(11)	NO
description	varchar(255)	NO
link	varchar(255)	NO
target	varchar(255)	NO
position	int(11)	NO

View full details →

s_campaigns_logs

5 columns

Send logs for email newsletter campaigns (delivery tracking).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
datum	datetime	NO
mailingID	int(11)	NO
email	varchar(255)	NO
articleID	int(11)	NO

View full details →

s_campaigns_mailaddresses

8 columns

Newsletter subscriber email addresses and opt-in status.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
customer	int(1)	NO
groupID	int(11)	NO	Index
email	varchar(90)	NO	Index
lastmailing	int(11)	NO	Index
lastread	int(11)	NO	Index
added	datetime	YES
double_optin_confirmed	datetime	YES

View full details →

s_campaigns_maildata

13 columns

Additional subscriber data for newsletter personalization.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
email	varchar(255)	NO	Index
groupID	int(11) unsigned	NO
salutation	varchar(255)	YES
title	varchar(255)	YES
firstname	varchar(255)	YES
lastname	varchar(255)	YES
street	varchar(255)	YES
zipcode	varchar(255)	YES
city	varchar(255)	YES
added	datetime	NO
double_optin_confirmed	datetime	YES
deleted	datetime	YES

View full details →

s_campaigns_mailings

17 columns

Newsletter mailing definitions — subject, sender, schedule, and assigned content.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
datum	date	YES
groups	mediumtext	NO
subject	varchar(100)	NO
sendermail	varchar(255)	NO
sendername	varchar(255)	NO
plaintext	int(1)	NO
templateID	int(11)	NO
languageID	int(11)	NO
status	int(11)	NO
locked	datetime	YES
recipients	int(11)	NO
read	int(11)	NO
clicked	int(11)	NO
customergroup	varchar(15)	YES
publish	int(1) unsigned	NO
timed_delivery	datetime	YES

View full details →

s_campaigns_positions

4 columns

Content element positions/ordering within newsletter campaign layouts.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
promotionID	int(11)	NO
containerID	int(11)	NO
position	int(11)	NO

View full details →

s_campaigns_sender

3 columns

Sender identities (name + email) for newsletter campaigns.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
email	varchar(255)	NO
name	varchar(255)	NO

View full details →

s_campaigns_templates

3 columns

Email templates for newsletter campaign layouts.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
path	varchar(255)	NO
description	varchar(255)	NO

View full details →

s_categories

29 columns

Hierarchical product category tree — the primary shop navigation and catalog structure.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
parent	int(11) unsigned	YES	Index
path	varchar(255)	YES
description	varchar(255)	NO	Index
position	int(11) unsigned	YES	Index
left	int(11) unsigned	NO	Index
right	int(11) unsigned	NO
level	int(11) unsigned	NO	Index
added	datetime	NO
changed	datetime	NO
metakeywords	mediumtext	YES
metadescription	mediumtext	YES
cmsheadline	varchar(255)	YES
cmstext	mediumtext	YES
template	varchar(255)	YES
active	int(1)	NO
blog	int(11)	NO
external	varchar(255)	YES
hidefilter	int(1)	NO
hidetop	int(1)	NO
mediaID	int(11) unsigned	YES
product_box_layout	varchar(50)	YES
meta_title	varchar(255)	YES
stream_id	int(11) unsigned	YES	Index Foreign Key → s_product_streams.id
hide_sortings	int(1)	NO
sorting_ids	text	YES
facet_ids	text	YES
external_target	varchar(32)	YES
shops	varchar(255)	YES

View full details →

s_categories_attributes

8 columns

Custom attribute extensions for categories.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
categoryID	int(11) unsigned	YES	Unique Foreign Key → s_categories.id
attribute1	text	YES
attribute2	text	YES
attribute3	text	YES
attribute4	text	YES
attribute5	text	YES
attribute6	text	YES

View full details →

s_categories_avoid_customergroups

2 columns

Categories hidden from specific customer groups.

Column	Type	Nullable	Additional
categoryID	int(11)	NO	Primary Key
customergroupID	int(11)	NO	Primary Key

View full details →

s_categories_manual_sorting

4 columns

Manual product sort order overrides within categories.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
category_id	int(11)	NO	Index
product_id	int(11)	NO
position	int(11)	NO

View full details →

s_cms_static

20 columns

Static CMS/shop pages (e.g. imprint, privacy policy, terms & conditions, custom info pages).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
active	tinyint(1)	NO
tpl1variable	varchar(255)	NO
tpl1path	varchar(255)	NO
tpl2variable	varchar(255)	NO
tpl2path	varchar(255)	NO
tpl3variable	varchar(255)	NO
tpl3path	varchar(255)	NO
description	varchar(255)	NO
html	mediumtext	NO
grouping	varchar(255)	NO
position	int(11)	NO	Index
link	varchar(255)	NO
target	varchar(255)	NO
parentID	int(11)	NO
page_title	varchar(255)	NO
meta_keywords	varchar(255)	NO
meta_description	varchar(255)	NO
changed	datetime	NO
shop_ids	varchar(255)	YES

View full details →

s_cms_static_attributes

2 columns

Custom attribute extensions for static CMS pages.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
cmsStaticID	int(11)	YES	Unique Foreign Key → s_cms_static.id

View full details →

s_cms_static_groups

5 columns

Groups organizing static pages (e.g. 'Bottom navigation', 'Left sidebar', 'Service pages').

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
name	varchar(255)	NO
key	varchar(255)	NO
active	int(1)	NO
mapping_id	int(11) unsigned	YES	Index

View full details →

s_cms_support

14 columns

Contact/support forms — form definitions with fields and email recipients.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
active	tinyint(1)	NO
name	varchar(255)	NO
text	mediumtext	NO
email	varchar(255)	NO
email_template	mediumtext	NO
email_subject	varchar(255)	NO
text2	mediumtext	NO
meta_title	varchar(255)	YES
meta_keywords	varchar(255)	YES
meta_description	text	YES
ticket_typeID	int(10)	NO
isocode	varchar(3)	NO
shop_ids	varchar(255)	YES

View full details →

s_cms_support_attributes

2 columns

Custom attribute extensions for support forms.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
cmsSupportID	int(11)	YES	Unique Foreign Key → s_cms_support.id

View full details →

s_cms_support_fields

13 columns

Individual form field definitions (name, type, required) within support forms.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
error_msg	varchar(255)	NO
name	varchar(255)	NO	Index
note	varchar(255)	YES
typ	varchar(255)	NO
required	int(1)	NO
supportID	int(11)	NO
label	varchar(255)	NO
class	varchar(255)	NO
value	varchar(255)	NO
added	datetime	NO
position	int(11)	NO
ticket_task	varchar(200)	NO

View full details →

s_content_types

5 columns

Custom content type definitions (SW5.6+ feature for structured content beyond products/blog).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
internalName	varchar(100)	NO
name	varchar(100)	NO
source	varchar(100)	YES
config	text	NO

View full details →

s_core_acl_privilege_requirements

2 columns

Required privileges that must be present for specific ACL operations.

Column	Type	Nullable	Additional
privilege_id	int(11) unsigned	NO	Primary Key
required_privilege_id	int(11) unsigned	NO	Primary Key

View full details →

s_core_acl_privileges

3 columns

Individual ACL privileges (e.g. create, read, update, delete) per resource.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
resourceID	int(11)	NO	Index
name	varchar(255)	NO

View full details →

s_core_acl_resources

3 columns

ACL resource definitions (backend modules/areas that can be permission-controlled).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO
pluginID	int(11)	YES

View full details →

s_core_acl_roles

4 columns

Named ACL roles grouping multiple privileges for backend user access control.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
roleID	int(11)	NO	Index
resourceID	int(11)	YES	Index
privilegeID	int(11)	YES	Index

View full details →

s_core_auth

16 columns

Backend administration user accounts (login, password hash, role, locale, session).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
roleID	int(11)	NO
username	varchar(255)	NO	Unique
password	varchar(255)	NO
encoder	varchar(255)	NO
apiKey	varchar(40)	YES
localeID	int(11)	NO
sessionID	varchar(128)	YES
lastlogin	datetime	NO
name	varchar(255)	NO
email	varchar(120)	NO
active	int(1)	NO
failedlogins	int(11)	NO
lockeduntil	datetime	YES
extended_editor	tinyint(1) unsigned	NO
disabled_cache	tinyint(1) unsigned	NO

View full details →

s_core_auth_attributes

2 columns

Custom attribute extensions for backend admin users.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
authID	int(11)	YES	Unique Foreign Key → s_core_auth.id

View full details →

s_core_auth_config

3 columns

Per-admin-user configuration preferences and settings.

Column	Type	Nullable	Additional
user_id	int(11)	NO	Primary Key
name	varchar(255)	NO	Primary Key
config	longtext	NO

View full details →

s_core_auth_roles

7 columns

Backend user roles linking admin users to ACL role-based permissions.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
parentID	int(11)	YES
name	varchar(255)	NO	Unique
description	text	NO
source	varchar(255)	NO
enabled	int(1)	NO
admin	int(1)	NO

View full details →

s_core_config_element_translations

5 columns

Translations for configuration element labels and descriptions.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
element_id	int(11) unsigned	NO	Index
locale_id	int(11) unsigned	NO
label	varchar(255)	YES
description	text	YES

View full details →

s_core_config_elements

11 columns

Individual configuration fields (settings) within config forms — type, default value, constraints.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
form_id	int(11) unsigned	NO	Index
name	varchar(255)	NO
value	text	YES
label	varchar(255)	YES
description	text	YES
type	varchar(255)	NO
required	int(1) unsigned	NO
position	int(11)	NO
scope	int(11) unsigned	NO
options	blob	YES

View full details →

s_core_config_form_translations

5 columns

Translations for configuration form names and descriptions.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
form_id	int(11) unsigned	NO
locale_id	int(11) unsigned	NO
label	varchar(255)	YES
description	text	YES

View full details →

s_core_config_forms

7 columns

Configuration forms grouping related settings in the backend (plugin/core config screens).

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
parent_id	int(11) unsigned	YES	Index
name	varchar(255)	NO	Unique
label	varchar(255)	YES
description	text	YES
position	int(11)	NO
plugin_id	int(11) unsigned	YES	Index

View full details →

s_core_config_mails

13 columns

Email template definitions — subject, HTML body, plain-text body, and associated event.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
stateId	int(11)	YES	Unique Foreign Key → s_core_states.id
name	varchar(255)	NO	Unique
frommail	varchar(255)	NO
fromname	varchar(255)	NO
subject	varchar(255)	NO
content	mediumtext	NO
contentHTML	mediumtext	NO
ishtml	int(1)	NO
attachment	varchar(255)	NO
mailtype	int(11)	NO
context	longtext	YES
dirty	int(1)	YES

View full details →

s_core_config_mails_attachments

4 columns

File attachments configured on email templates.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
mailID	int(11)	NO	Index
mediaID	int(11)	NO	Index
shopID	int(11)	YES	Index

View full details →

s_core_config_mails_attributes

2 columns

Custom attribute extensions for email templates.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
mailID	int(11)	YES	Unique Foreign Key → s_core_config_mails.id

View full details →

s_core_config_values

4 columns

Actual stored configuration values per shop (overrides for config elements).

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
element_id	int(11) unsigned	NO	Index
shop_id	int(11) unsigned	YES	Index
value	longtext	NO

View full details →

s_core_countries

15 columns

Country definitions with ISO codes, tax-free settings, and address format configuration.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
countryname	varchar(255)	YES
countryiso	varchar(255)	YES
areaID	int(11)	YES	Index
countryen	varchar(255)	YES
position	int(11)	YES
notice	text	YES
taxfree	int(11)	YES
taxfree_ustid	int(11)	YES
taxfree_ustid_checked	int(11)	YES
active	int(11)	YES
iso3	varchar(45)	YES
display_state_in_registration	int(1)	NO
force_state_in_registration	int(1)	NO
allow_shipping	int(1)	NO

View full details →

s_core_countries_areas

3 columns

Geographic areas grouping countries (e.g. 'Europe', 'World') for shipping rules.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	YES	Unique
active	int(11)	YES

View full details →

s_core_countries_attributes

2 columns

Custom attribute extensions for countries.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
countryID	int(11)	YES	Unique Foreign Key → s_core_countries.id

View full details →

s_core_countries_states

6 columns

States/provinces within countries (e.g. US states, German Bundesländer).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
countryID	int(11)	YES	Index
name	varchar(255)	YES
shortcode	varchar(255)	NO
position	int(11)	YES
active	int(11)	YES

View full details →

s_core_countries_states_attributes

2 columns

Custom attribute extensions for country states.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
stateID	int(11)	YES	Unique Foreign Key → s_core_countries_states.id

View full details →

s_core_currencies

8 columns

Available currencies with exchange rates and formatting configuration.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
currency	varchar(255)	NO
name	varchar(255)	NO
standard	int(1)	NO
factor	double	NO
templatechar	varchar(255)	NO
symbol_position	int(11) unsigned	NO
position	int(11)	NO

View full details →

s_core_customergroups

9 columns

Customer groups (e.g. 'Shopkunden', 'Händler') controlling prices, tax display, and access.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
groupkey	varchar(15)	YES	Index
description	varchar(30)	NO
tax	int(1)	NO
taxinput	int(1)	NO
mode	int(11)	NO
discount	double	NO
minimumorder	double	NO
minimumordersurcharge	double	NO

View full details →

s_core_customergroups_attributes

2 columns

Custom attribute extensions for customer groups.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
customerGroupID	int(11)	YES	Unique Foreign Key → s_core_customergroups.id

View full details →

s_core_customergroups_discounts

4 columns

Global percentage discounts per customer group based on cart value thresholds.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
groupID	int(11)	NO	Index
basketdiscount	double	NO
basketdiscountstart	double	NO

View full details →

s_core_customerpricegroups

4 columns

Price groups for graduated/quantity-based pricing schemes across customer segments.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
name	varchar(255)	NO
netto	int(1) unsigned	NO
active	int(1) unsigned	NO

View full details →

s_core_detail_states

4 columns

Order detail/line item states (e.g. open, delivered, returned, cancelled).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
description	varchar(255)	NO
position	int(11)	NO
mail	int(1)	NO

View full details →

s_core_documents

10 columns

Document type definitions (invoice, delivery note, credit note) with configuration.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO
template	varchar(255)	NO
numbers	varchar(25)	NO
left	int(11)	NO
right	int(11)	NO
top	int(11)	NO
bottom	int(11)	NO
pagebreak	int(11)	NO
key	varchar(255)	YES	Unique

View full details →

s_core_documents_box

5 columns

Content blocks/sections within document templates (header, footer, content areas).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
documentID	int(11)	NO
name	varchar(35)	NO
style	longtext	NO
value	longtext	NO

View full details →

s_core_engine_elements

14 columns

Backend form field definitions for entity detail views (legacy ExtJS backend forms).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
groupID	int(11) unsigned	NO
domname	varchar(60)	NO
default	varchar(255)	YES
type	varchar(255)	NO
store	varchar(255)	YES
label	varchar(255)	YES
required	int(1)	NO
position	int(11)	NO
name	varchar(255)	NO	Unique
layout	varchar(255)	YES
variantable	int(1) unsigned	NO
help	varchar(255)	YES
translatable	int(1) unsigned	NO

View full details →

s_core_engine_groups

6 columns

Groups of backend form fields for organizing entity detail views.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO
label	varchar(255)	YES
layout	varchar(255)	YES
variantable	int(1) unsigned	NO
position	int(11)	NO

View full details →

s_core_licenses

14 columns

Shopware license and plugin license key storage.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
module	varchar(255)	NO
host	varchar(255)	NO
label	varchar(255)	NO
license	text	NO
version	varchar(255)	NO
notation	varchar(255)	YES
type	int(11) unsigned	NO
source	int(11) unsigned	NO
added	date	NO
creation	date	YES
expiration	date	YES
active	int(1)	NO
plugin_id	int(11)	YES

View full details →

s_core_locales

4 columns

Locale definitions (e.g. de_DE, en_GB) for language and regional formatting.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
locale	varchar(255)	NO	Unique
language	varchar(255)	NO
territory	varchar(255)	NO

View full details →

s_core_log

9 columns

System log entries for errors, warnings, and debug information.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
type	varchar(255)	NO
key	varchar(255)	NO
text	mediumtext	NO
date	datetime	NO
user	varchar(255)	NO
ip_address	varchar(255)	NO
user_agent	varchar(255)	NO
value4	varchar(255)	NO

View full details →

s_core_menu

12 columns

Backend administration menu tree structure — navigation items, controllers, and icons.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
parent	int(11) unsigned	YES
name	varchar(255)	NO	Index
onclick	varchar(255)	YES
class	varchar(255)	YES
position	int(11)	NO
active	int(1)	NO
pluginID	int(11) unsigned	YES
controller	varchar(255)	YES
shortcut	varchar(255)	YES
action	varchar(255)	YES
content_type	varchar(255)	YES

View full details →

s_core_optin

5 columns

Double opt-in verification tokens (newsletter signup, registration confirmation).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
type	varchar(255)	YES
datum	datetime	NO	Index
hash	varchar(255)	NO	Unique
data	mediumtext	NO

View full details →

s_core_payment_data

11 columns

Saved customer payment credentials (e.g. bank account data for direct debit).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
payment_mean_id	int(11)	NO	Index
user_id	int(11)	NO	Index
use_billing_data	int(1)	YES
bankname	varchar(255)	YES
bic	varchar(50)	YES
iban	varchar(50)	YES
account_number	varchar(50)	YES
bank_code	varchar(50)	YES
account_holder	varchar(50)	YES
created_at	date	NO

View full details →

s_core_payment_instance

17 columns

Payment transaction instances per order — tracks payment processing state.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
payment_mean_id	int(11)	YES	Index
order_id	int(11)	YES	Index
user_id	int(11)	YES	Index
firstname	varchar(255)	YES
lastname	varchar(255)	YES
address	varchar(255)	YES
zipcode	varchar(15)	YES
city	varchar(50)	YES
account_number	varchar(50)	YES
account_holder	varchar(255)	YES
bank_name	varchar(255)	YES
bank_code	varchar(255)	YES
bic	varchar(50)	YES
iban	varchar(50)	YES
amount	decimal(20,4)	YES
created_at	date	NO

View full details →

s_core_paymentmeans

20 columns

Available payment methods with handler class, surcharge/discount, and configuration.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO	Unique
description	varchar(255)	NO
template	varchar(255)	NO
class	varchar(255)	NO
table	varchar(70)	NO
hide	int(1)	NO
additionaldescription	mediumtext	NO
debit_percent	double	NO
surcharge	double	NO
surchargestring	varchar(255)	NO
position	int(11)	NO
active	int(1)	NO
esdactive	int(1)	NO
embediframe	varchar(255)	NO
hideprospect	int(1)	NO
action	varchar(255)	YES
pluginID	int(11) unsigned	YES
source	int(11)	YES
mobile_inactive	int(1)	NO

View full details →

s_core_paymentmeans_attributes

2 columns

Custom attribute extensions for payment methods.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
paymentmeanID	int(11)	YES	Unique Foreign Key → s_core_paymentmeans.id

View full details →

s_core_paymentmeans_countries

2 columns

Country restrictions for payment methods (which countries allow which payment).

Column	Type	Nullable	Additional
paymentID	int(11) unsigned	NO	Primary Key
countryID	int(11) unsigned	NO	Primary Key

View full details →

s_core_paymentmeans_subshops

2 columns

Sub-shop/Sales-Channel restrictions for payment methods.

Column	Type	Nullable	Additional
paymentID	int(11) unsigned	NO	Primary Key
subshopID	int(11) unsigned	NO	Primary Key

View full details →

s_core_plugin_categories

4 columns

Categories for organizing plugins in the plugin manager.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
locale	varchar(50)	NO	Primary Key
parent_id	int(11)	YES
name	text	NO

View full details →

s_core_plugins

29 columns

Registry of installed plugins with version, status, installation date, and namespace.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
namespace	varchar(255)	NO
name	varchar(255)	NO	Unique
label	varchar(255)	NO
source	varchar(255)	NO
description	mediumtext	YES
translations	text	YES
description_long	mediumtext	YES
active	int(1) unsigned	NO
added	datetime	NO
installation_date	datetime	YES
update_date	datetime	YES
refresh_date	datetime	YES
author	varchar(255)	YES
copyright	varchar(255)	YES
license	varchar(255)	YES
version	varchar(255)	NO
support	varchar(255)	YES
changes	mediumtext	YES
link	varchar(255)	YES
store_version	varchar(255)	YES
store_date	datetime	YES
capability_update	int(1)	NO
capability_install	int(1)	NO
capability_enable	int(1)	NO
update_source	varchar(255)	YES
update_version	varchar(255)	YES
capability_secure_uninstall	int(1)	NO
in_safe_mode	tinyint(1)	YES

View full details →

s_core_pricegroups

2 columns

Named price groups used as containers for graduated discount rules.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
description	varchar(30)	NO

View full details →

s_core_pricegroups_discounts

5 columns

Graduated discounts within price groups — percentage discount per quantity threshold.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
groupID	int(11)	NO	Index
customergroupID	int(11)	NO
discount	double	NO
discountstart	double	NO

View full details →

s_core_rewrite_urls

5 columns

SEO URL rewrites mapping friendly URLs to internal Shopware controller/action routes.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
org_path	varchar(255)	NO	Index
path	varchar(255)	NO	Index
main	int(1) unsigned	NO
subshopID	int(11) unsigned	NO

View full details →

s_core_rulesets

6 columns

Risk management rules for payment methods (fraud prevention conditions per payment).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
paymentID	int(11)	NO
rule1	varchar(255)	NO
value1	varchar(255)	NO
rule2	varchar(255)	NO
value2	varchar(255)	NO

View full details →

s_core_sessions

4 columns

Storefront customer session storage (serialized session data).

Column	Type	Nullable	Additional
id	varchar(128)	NO	Primary Key
data	mediumblob	NO
modified	int(10) unsigned	NO
expiry	int(10) unsigned	NO	Index

View full details →

s_core_sessions_backend

4 columns

Backend admin session storage.

Column	Type	Nullable	Additional
id	varchar(128)	NO	Primary Key
data	mediumblob	NO
modified	int(10) unsigned	NO
expiry	int(10) unsigned	NO	Index

View full details →

s_core_shop_currencies

2 columns

Junction table linking sub-shops to their available currencies.

Column	Type	Nullable	Additional
shop_id	int(11) unsigned	NO	Primary Key
currency_id	int(11) unsigned	NO	Primary Key

View full details →

s_core_shop_pages

2 columns

Links static CMS page groups to specific shops.

Column	Type	Nullable	Additional
shop_id	int(11) unsigned	NO	Primary Key
group_id	int(11) unsigned	NO	Primary Key

View full details →

s_core_shops

20 columns

Shop/sub-shop definitions — each represents a storefront with its own domain, language, and theme.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
main_id	int(11) unsigned	YES	Index
name	varchar(255)	NO
title	varchar(255)	YES
position	int(11)	NO
host	varchar(255)	YES	Index
base_path	varchar(255)	YES
base_url	varchar(255)	YES
hosts	text	NO
secure	int(1) unsigned	NO
template_id	int(11) unsigned	YES
document_template_id	int(11) unsigned	YES
category_id	int(11) unsigned	YES
locale_id	int(11) unsigned	YES
currency_id	int(11) unsigned	YES
customer_group_id	int(11) unsigned	YES
fallback_id	int(11) unsigned	YES
customer_scope	int(1)	NO
default	int(1) unsigned	NO
active	int(1)	NO

View full details →

s_core_shops_attributes

2 columns

Custom attribute extensions for shops.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
shopID	int(11) unsigned	NO	Unique Foreign Key → s_core_shops.id

View full details →

s_core_snippets

9 columns

Text snippets (translations) — key-value pairs per shop and locale for storefront/email texts.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
namespace	varchar(255)	NO	Index
shopID	int(11) unsigned	NO
localeID	int(11) unsigned	NO
name	varchar(255)	NO
value	mediumtext	NO
created	datetime	NO
updated	datetime	NO
dirty	int(1)	YES

View full details →

s_core_states

6 columns

Order and payment status definitions (e.g. open, in_progress, completed, cancelled).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(55)	YES
description	varchar(255)	NO
position	int(11)	NO
group	varchar(25)	NO
mail	int(1)	NO

View full details →

s_core_subscribes

6 columns

Plugin event subscriber registrations — hooks plugins into Shopware's event system.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
subscribe	varchar(255)	NO	Index
type	int(11) unsigned	NO	Index
listener	varchar(255)	NO
pluginID	int(11) unsigned	YES	Index
position	int(11)	NO

View full details →

s_core_tax

3 columns

Tax rate definitions (e.g. 19%, 7%) assigned to products.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
tax	decimal(10,2)	NO	Index
description	varchar(30)	NO

View full details →

s_core_tax_rules

9 columns

Country-specific tax rate overrides for different regions.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
areaID	int(11) unsigned	YES	Index
countryID	int(11) unsigned	YES	Index
stateID	int(11) unsigned	YES	Index
groupID	int(11) unsigned	NO	Index
customer_groupID	int(11) unsigned	NO	Index
tax	decimal(10,2)	NO
name	varchar(255)	NO
active	int(1) unsigned	NO

View full details →

s_core_templates

12 columns

Installed storefront themes/templates with inheritance configuration.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
template	varchar(255)	NO	Unique
name	varchar(255)	NO
description	varchar(255)	YES
author	varchar(255)	YES
license	varchar(255)	YES
esi	tinyint(1) unsigned	NO
style_support	tinyint(1) unsigned	NO
emotion	tinyint(1) unsigned	NO
version	int(11) unsigned	NO
plugin_id	int(11) unsigned	YES
parent_id	int(11)	YES

View full details →

s_core_templates_config_elements

13 columns

Theme configuration fields (color pickers, font selectors, toggles) defined by themes.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
template_id	int(11)	NO	Index
type	varchar(255)	NO
name	varchar(255)	NO
position	int(11)	NO
default_value	text	YES
selection	text	YES
field_label	varchar(255)	YES
support_text	varchar(255)	YES
allow_blank	int(1)	NO
container_id	int(11)	NO
attributes	text	YES
less_compatible	int(1)	NO

View full details →

s_core_templates_config_layout

7 columns

Layout/grouping structure for theme configuration fields in the backend.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
parent_id	int(11)	YES
template_id	int(11)	NO
type	varchar(255)	NO
name	varchar(255)	NO
title	varchar(255)	YES
attributes	text	YES

View full details →

s_core_templates_config_set

5 columns

Named theme configuration presets/sets (e.g. 'Default', 'Color scheme 1').

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
template_id	int(11)	NO	Index
name	varchar(255)	NO
description	text	NO
element_values	text	NO

View full details →

s_core_templates_config_values

4 columns

Actual stored values for theme configuration fields per shop.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
element_id	int(11)	NO	Index
shop_id	int(11)	NO
value	text	NO

View full details →

s_core_theme_settings

6 columns

Compiled/cached theme settings and LESS/CSS variable values.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
compiler_force	int(1)	NO
compiler_create_source_map	int(1)	NO
compiler_compress_css	int(1)	NO
compiler_compress_js	int(1)	NO
force_reload_snippets	int(1)	NO

View full details →

s_core_translations

6 columns

Generic translation storage for various entities (object type + object key + language → data).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
objecttype	varchar(255)	NO	Index
objectdata	longtext	NO
objectkey	int(11) unsigned	NO
objectlanguage	varchar(255)	NO
dirty	int(1)	YES

View full details →

s_core_units

3 columns

Measurement units for product purchase and reference quantities (e.g. liter, kg, piece).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
unit	varchar(255)	NO
description	varchar(255)	NO

View full details →

s_core_widget_views

6 columns

Tracks which backend dashboard widgets an admin user has viewed/acknowledged.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
widget_id	int(11) unsigned	NO	Index
auth_id	int(11) unsigned	NO
column	int(11) unsigned	NO
position	int(11) unsigned	NO
data	text	YES

View full details →

s_core_widgets

4 columns

Available backend dashboard widgets (e.g. order overview, visitor stats, news).

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
name	varchar(255)	NO	Unique
label	varchar(255)	YES
plugin_id	int(11)	YES

View full details →

s_crontab

14 columns

Scheduled cron jobs with execution interval, next run time, and handler class.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO
action	varchar(255)	NO	Unique
elementID	int(11)	YES
data	mediumtext	NO
next	datetime	YES
start	datetime	YES
interval	int(11)	NO
active	int(1)	NO
disable_on_error	tinyint(1)	NO
end	datetime	YES
inform_template	varchar(255)	NO
inform_mail	varchar(255)	NO
pluginID	int(11) unsigned	YES

View full details →

s_customer_search_index

47 columns

Pre-computed customer search index for fast backend customer lookup.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
email	varchar(70)	YES
active	int(1)	YES
accountmode	int(11)	YES
firstlogin	date	YES
newsletter	int(1)	YES
shop_id	int(11)	YES
default_billing_address_id	int(11)	YES
title	varchar(100)	YES
salutation	varchar(30)	YES
firstname	varchar(255)	YES
lastname	varchar(255)	YES
birthday	date	YES
customernumber	varchar(30)	YES
customer_group_id	int(11)	YES
customer_group_name	varchar(255)	YES
payment_id	int(11)	YES
company	varchar(255)	YES
department	varchar(255)	YES
street	varchar(255)	YES
zipcode	varchar(255)	YES
city	varchar(255)	YES
phone	varchar(255)	YES
additional_address_line1	varchar(255)	YES
additional_address_line2	varchar(255)	YES
country_id	int(11)	YES
country_name	varchar(255)	YES
state_id	int(11)	YES
age	int(11)	YES
count_orders	int(11)	YES
invoice_amount_sum	double	YES
invoice_amount_avg	double	YES
invoice_amount_min	double	YES
invoice_amount_max	double	YES
first_order_time	date	YES
last_order_time	date	YES
has_canceled_orders	int(1)	YES
product_avg	double	YES
ordered_at_weekdays	text	YES
ordered_in_shops	text	YES
ordered_on_devices	text	YES
ordered_with_deliveries	text	YES
ordered_with_payments	text	YES
ordered_products	longtext	YES
ordered_products_of_categories	longtext	YES
ordered_products_of_manufacturer	longtext	YES
index_time	datetime	NO

View full details →

s_customer_streams

6 columns

Customer streams (segments) defined by filter conditions — dynamic customer groups.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
name	varchar(255)	NO
conditions	longtext	YES
description	text	YES
freeze_up	datetime	YES
static	int(1)	YES

View full details →

s_customer_streams_attributes

2 columns

Custom attribute extensions for customer streams.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
streamID	int(11) unsigned	NO	Index Foreign Key → s_customer_streams.id

View full details →

s_customer_streams_mapping

2 columns

Materialized mapping of customers matching a stream's filter conditions.

Column	Type	Nullable	Additional
stream_id	int(11)	NO	Primary Key
customer_id	int(11)	NO	Primary Key

View full details →

s_emarketing_banners

9 columns

Storefront advertising banners with image, link, and display scheduling.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
description	varchar(60)	NO
valid_from	datetime	YES
valid_to	datetime	YES
img	varchar(255)	NO
link	varchar(255)	NO
link_target	varchar(255)	NO
categoryID	int(11)	NO
extension	varchar(25)	NO

View full details →

s_emarketing_banners_attributes

2 columns

Custom attribute extensions for advertising banners.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
bannerID	int(11)	YES	Unique Foreign Key → s_emarketing_banners.id

View full details →

s_emarketing_banners_statistics

5 columns

Click/view statistics for advertising banners.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
bannerID	int(11)	NO	Index
display_date	date	NO
clicks	int(11)	NO
views	int(11)	NO

View full details →

s_emarketing_lastarticles

6 columns

Recently viewed products per customer/session (for 'last viewed' widgets).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
articleID	int(11) unsigned	NO	Index
sessionID	varchar(128)	YES	Index
time	datetime	NO	Index
userID	int(11) unsigned	NO	Index
shopID	int(11) unsigned	NO

View full details →

s_emarketing_partner

19 columns

Affiliate/partner program participants with tracking codes and commission rates.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
idcode	varchar(255)	NO	Index
datum	date	NO
company	varchar(255)	NO
contact	varchar(255)	NO
street	varchar(255)	NO
zipcode	varchar(15)	NO
city	varchar(255)	NO
phone	varchar(50)	NO
fax	varchar(50)	NO
country	varchar(255)	NO
email	varchar(100)	NO
web	varchar(255)	NO
profil	mediumtext	NO
fix	double	NO
percent	double	NO
cookielifetime	int(11)	NO
active	int(1)	NO
userID	int(11) unsigned	YES

View full details →

s_emarketing_partner_attributes

2 columns

Custom attribute extensions for affiliate partners.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
partnerID	int(11)	NO	Unique Foreign Key → s_emarketing_partner.id

View full details →

s_emarketing_referer

4 columns

Referrer URL tracking for marketing analytics.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
userID	int(11)	NO
referer	mediumtext	NO
date	date	NO

View full details →

s_emarketing_tellafriend

5 columns

Tracking data for the 'tell a friend' product recommendation feature.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
datum	date	NO
recipient	varchar(50)	NO
sender	int(11)	NO
confirmed	int(1)	NO

View full details →

s_emarketing_voucher_codes

5 columns

Individual voucher codes (unique per use) within a voucher campaign.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
voucherID	int(11)	NO	Index
userID	int(11)	YES
code	varchar(255)	NO	Unique
cashed	int(1)	NO

View full details →

s_emarketing_vouchers

20 columns

Voucher/coupon campaign definitions with discount type, value, and validity rules.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
description	varchar(255)	NO
vouchercode	varchar(100)	NO
numberofunits	int(11)	NO
value	double	NO
minimumcharge	double	NO
shippingfree	int(1)	NO
bindtosupplier	int(11)	YES
valid_from	date	YES
valid_to	date	YES
ordercode	varchar(255)	NO
modus	int(1)	NO	Index
percental	int(1)	NO
numorder	int(11)	NO
customergroup	int(11)	YES
restrictarticles	mediumtext	NO
strict	int(1)	NO
subshopID	int(1)	YES
taxconfig	varchar(15)	NO
customer_stream_ids	longtext	YES

View full details →

s_emarketing_vouchers_attributes

2 columns

Custom attribute extensions for vouchers.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
voucherID	int(11)	YES	Unique Foreign Key → s_emarketing_vouchers.id

View full details →

s_emotion

29 columns

Shopping World/Emotion layouts — the visual drag-and-drop page designer for category landing pages.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
active	int(1)	NO
name	varchar(255)	NO
cols	int(11)	YES
cell_spacing	int(11)	NO
cell_height	int(11)	NO
article_height	int(11)	NO
rows	int(11)	NO
valid_from	datetime	YES
valid_to	datetime	YES
userID	int(11)	YES
show_listing	int(1)	NO
is_landingpage	int(1)	NO
seo_title	varchar(255)	NO
seo_keywords	varchar(255)	NO
seo_description	text	NO
create_date	datetime	YES
modified	datetime	YES
template_id	int(11)	YES
device	varchar(255)	YES
fullscreen	int(11)	NO
mode	varchar(255)	NO
position	int(11)	YES
parent_id	int(11)	YES
preview_id	int(11)	YES	Unique
preview_secret	varchar(32)	YES
customer_stream_ids	longtext	YES
replacement	text	YES
listing_visibility	varchar(50)	NO

View full details →

s_emotion_attributes

2 columns

Custom attribute extensions for Shopping World/Emotion pages.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
emotionID	int(11)	YES	Unique Foreign Key → s_emotion.id

View full details →

s_emotion_categories

3 columns

Links Shopping World layouts to categories where they are displayed.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
emotion_id	int(11)	NO
category_id	int(11)	NO

View full details →

s_emotion_element

8 columns

Individual elements/widgets within a Shopping World layout (banner, product slider, HTML, etc.).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
emotionID	int(11)	NO	Index
componentID	int(11)	NO
start_row	int(11)	NO
start_col	int(11)	NO
end_row	int(11)	NO
end_col	int(11)	NO
css_class	varchar(255)	YES

View full details →

s_emotion_element_value

6 columns

Configuration values for Shopping World elements (element-specific settings).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
emotionID	int(11)	NO
elementID	int(11)	NO	Index
componentID	int(11)	NO
fieldID	int(11)	NO	Index
value	text	YES

View full details →

s_emotion_element_viewports

9 columns

Responsive viewport positioning of Shopping World elements (desktop, tablet, mobile).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
elementID	int(11)	NO
emotionID	int(11)	NO
alias	varchar(255)	NO
start_row	int(11)	NO
start_col	int(11)	NO
end_row	int(11)	NO
end_col	int(11)	NO
visible	int(1)	NO

View full details →

s_emotion_preset_translations

5 columns

Translations for Shopping World preset names and descriptions.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
presetID	int(11) unsigned	NO	Index Foreign Key → s_emotion_presets.id
label	varchar(255)	NO
description	text	NO
locale	varchar(15)	NO

View full details →

s_emotion_presets

11 columns

Pre-built Shopping World layout templates that can be imported as starting points.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
name	varchar(255)	YES	Unique
premium	tinyint(1)	NO
custom	tinyint(1)	NO
thumbnail	longtext	YES
preview	longtext	YES
preset_data	longtext	NO
required_plugins	longtext	YES
emotion_translations	text	YES
assets_imported	tinyint(1)	NO
hidden	tinyint(1)	NO

View full details →

s_emotion_shops

3 columns

Links Shopping World layouts to specific shops/sub-shops.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
emotion_id	int(11)	NO
shop_id	int(11)	NO

View full details →

s_emotion_templates

3 columns

Custom grid templates for Shopping World layouts (row/column configurations).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO
file	varchar(255)	NO

View full details →

s_es_backend_backlog

4 columns

Elasticsearch backend indexing backlog — queued entity changes pending re-indexing.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
entity	varchar(500)	NO
entity_id	int(11)	NO
time	datetime	NO

View full details →

s_es_backlog

4 columns

Elasticsearch storefront indexing backlog — queued product/entity changes pending re-indexing.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
event	varchar(255)	NO
payload	text	NO
time	datetime	YES

View full details →

s_export

32 columns

Product export feed definitions (e.g. Google Shopping, price comparison) with template and schedule.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO
last_export	datetime	NO
active	int(1)	NO
hash	varchar(255)	NO
show	int(1)	NO
count_articles	int(11)	NO
expiry	datetime	NO
interval	int(11)	NO
formatID	int(11)	NO
last_change	datetime	NO
filename	varchar(255)	NO
encodingID	int(11)	NO
categoryID	int(11)	YES
currencyID	int(11)	YES
customergroupID	int(11)	YES
partnerID	varchar(255)	YES
languageID	int(11)	YES
active_filter	int(1)	NO
image_filter	int(1)	NO
stockmin_filter	int(1)	NO
instock_filter	int(11)	NO
price_filter	double	NO
own_filter	mediumtext	NO
header	longtext	NO
body	longtext	NO
footer	longtext	NO
count_filter	int(11)	NO
multishopID	int(11)	YES
variant_export	int(11) unsigned	NO
cache_refreshed	datetime	YES
dirty	int(1)	YES

View full details →

s_export_articles

2 columns

Product filter/restriction for export feeds — specific products included/excluded.

Column	Type	Nullable	Additional
feedID	int(11)	NO	Primary Key
articleID	int(11)	NO	Primary Key

View full details →

s_export_attributes

2 columns

Custom attribute extensions for product export feeds.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
exportID	int(11)	YES	Unique Foreign Key → s_export.id

View full details →

s_export_categories

2 columns

Category filter for export feeds — only export products from selected categories.

Column	Type	Nullable	Additional
feedID	int(11)	NO	Primary Key
categoryID	int(11)	NO	Primary Key

View full details →

s_export_suppliers

2 columns

Supplier/manufacturer filter for export feeds.

Column	Type	Nullable	Additional
feedID	int(11)	NO	Primary Key
supplierID	int(11)	NO	Primary Key

View full details →

s_filter

5 columns

Product filter group definitions for faceted navigation (storefront filtering).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO
position	int(11)	NO	Index
comparable	int(1)	NO
sortmode	int(1)	NO

View full details →

s_filter_articles

2 columns

Product-specific filter exclusions or inclusions.

Column	Type	Nullable	Additional
articleID	int(10) unsigned	NO	Primary Key
valueID	int(10) unsigned	NO	Primary Key

View full details →

s_filter_attributes

2 columns

Custom attribute extensions for filter groups.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
filterID	int(11)	YES	Unique Foreign Key → s_filter.id

View full details →

s_filter_options

3 columns

Filter options/facets within a filter group (e.g. 'Color', 'Price range').

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO	Index
filterable	int(1)	NO

View full details →

s_filter_options_attributes

2 columns

Custom attribute extensions for filter options.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
optionID	int(11)	NO	Index Foreign Key → s_filter_options.id

View full details →

s_filter_relations

4 columns

Links filter options to filter groups (which facets appear in which filter set).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
groupID	int(11)	NO	Index
optionID	int(11)	NO	Index
position	int(11)	NO

View full details →

s_filter_values

5 columns

Individual filter values within an option (e.g. 'Red', 'Blue' within 'Color').

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
optionID	int(11)	NO	Index
value	varchar(255)	NO
position	int(11)	NO
media_id	int(11)	YES	Index

View full details →

s_filter_values_attributes

2 columns

Custom attribute extensions for filter values.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
valueID	int(11)	NO	Index Foreign Key → s_filter_values.id

View full details →

s_library_component

8 columns

Shopping World element type definitions (the available widget types like banner, slider, etc.).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO
x_type	varchar(255)	NO
convert_function	varchar(255)	YES
description	text	NO
template	varchar(255)	NO
cls	varchar(255)	NO
pluginID	int(11)	YES

View full details →

s_library_component_field

16 columns

Configuration field definitions for Shopping World element types.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
componentID	int(11)	NO
name	varchar(255)	NO
x_type	varchar(255)	NO
value_type	varchar(255)	NO
field_label	varchar(255)	NO
support_text	varchar(255)	NO
help_title	varchar(255)	NO
help_text	text	NO
store	varchar(255)	NO
display_field	varchar(255)	NO
value_field	varchar(255)	NO
default_value	text	NO
allow_blank	int(1)	NO
translatable	int(1)	NO
position	int(11)	YES

View full details →

s_mail_log

9 columns

Sent email log entries with subject, sender, timestamp, and delivery status.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
type_id	int(11)	YES	Index Foreign Key → s_core_config_mails.id
order_id	int(11)	YES	Index Foreign Key → s_order.id
shop_id	int(10) unsigned	YES	Index Foreign Key → s_core_shops.id
subject	longtext	YES
sender	varchar(255)	NO
sent_at	datetime	NO
content_html	longtext	YES
content_text	longtext	YES

View full details →

s_mail_log_contact

2 columns

Sender contact information associated with mail log entries.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
mail_address	varchar(255)	NO

View full details →

s_mail_log_document

2 columns

Documents attached to logged outgoing emails.

Column	Type	Nullable	Additional
log_id	int(11)	NO	Primary Key Foreign Key → s_mail_log.id
document_id	int(11)	NO	Primary Key Foreign Key → s_order_documents.id

View full details →

s_mail_log_recipient

2 columns

Recipient addresses for logged outgoing emails.

Column	Type	Nullable	Additional
log_id	int(11)	NO	Primary Key Foreign Key → s_mail_log.id
contact_id	int(11)	NO	Primary Key Foreign Key → s_mail_log_contact.id

View full details →

s_media

12 columns

Central media library — stores metadata for uploaded files (images, documents, videos).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
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

View full details →

s_media_album

5 columns

Media library album/folder structure for organizing uploaded files.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO
parentID	int(11)	YES
position	int(11)	NO
garbage_collectable	tinyint(1)	YES

View full details →

s_media_album_settings

8 columns

Album-specific settings (thumbnail sizes, allowed file types, icon).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
albumID	int(11)	NO	Unique
create_thumbnails	int(11)	NO
thumbnail_size	text	NO
icon	varchar(50)	NO
thumbnail_high_dpi	int(1)	YES
thumbnail_quality	int(11)	YES
thumbnail_high_dpi_quality	int(11)	YES

View full details →

s_media_association

4 columns

Tracks which entities reference a media item (for orphan detection and usage info).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
mediaID	int(11)	NO	Index
targetType	varchar(50)	NO
targetID	int(11)	NO	Index

View full details →

s_media_attributes

2 columns

Custom attribute extensions for media items.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
mediaID	int(11)	YES	Unique Foreign Key → s_media.id

View full details →

s_multi_edit_backup

8 columns

Backup snapshots created before batch product editing operations.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
filter_string	text	NO
operation_string	text	NO
items	int(255) unsigned	NO	Index
date	datetime	YES	Index
size	int(255) unsigned	NO	Index
path	varchar(255)	NO
hash	varchar(255)	NO

View full details →

s_multi_edit_filter

7 columns

Saved filter presets for the batch product editing (multi-edit) feature.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
name	varchar(255)	NO
filter_string	text	NO
description	text	NO
created	datetime	YES
is_favorite	tinyint(1)	NO
is_simple	tinyint(1)	NO

View full details →

s_multi_edit_queue

7 columns

Queued batch editing operations waiting to be processed.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
resource	varchar(255)	NO
filter_string	text	NO	Index
operations	text	NO
items	int(255) unsigned	NO
active	tinyint(1)	NO
created	datetime	YES	Index

View full details →

s_multi_edit_queue_articles

3 columns

Individual products queued in a batch editing operation.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
queue_id	int(11) unsigned	NO	Index Foreign Key → s_multi_edit_queue.id
detail_id	int(11) unsigned	NO	Index Foreign Key → s_articles_details.id

View full details →

s_order

32 columns

Core order records — order number, totals, status, payment/shipping method, and customer reference.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
ordernumber	varchar(255)	YES	Index
userID	int(11)	YES	Index
invoice_amount	double	NO	Index
invoice_amount_net	double	NO
invoice_shipping	double	NO
invoice_shipping_net	double	NO
invoice_shipping_tax_rate	double	YES
ordertime	datetime	YES	Index
status	int(11)	NO	Index
cleared	int(11)	NO	Index
paymentID	int(11)	NO	Index
transactionID	varchar(255)	NO	Index
comment	mediumtext	NO
customercomment	mediumtext	NO
internalcomment	mediumtext	NO
net	int(1)	NO
taxfree	int(11)	NO
partnerID	varchar(255)	YES	Index
temporaryID	varchar(255)	NO	Index
referer	mediumtext	NO
cleareddate	datetime	YES
trackingcode	text	NO
language	varchar(10)	NO
dispatchID	int(11)	NO
currency	varchar(5)	NO
currencyFactor	double	NO
subshopID	int(11)	NO
remote_addr	varchar(255)	YES
deviceType	varchar(50)	YES
is_proportional_calculation	tinyint(4)	NO
changed	datetime	YES

View full details →

s_order_attributes

8 columns

Custom attribute extensions for orders.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
orderID	int(11)	YES	Unique Foreign Key → s_order.id
attribute1	text	YES
attribute2	text	YES
attribute3	text	YES
attribute4	text	YES
attribute5	text	YES
attribute6	text	YES

View full details →

s_order_basket

19 columns

Order line items (basket contents at time of order) — products, quantities, and prices.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
sessionID	varchar(128)	YES	Index
userID	int(11)	NO
articlename	varchar(255)	NO
articleID	int(11)	NO	Index
ordernumber	varchar(255)	NO	Index
shippingfree	int(1)	NO
quantity	int(11)	NO
price	double	NO
netprice	double	NO
tax_rate	double	NO
datum	datetime	NO	Index
modus	int(11)	NO
esdarticle	int(1)	NO
partnerID	varchar(45)	NO
lastviewport	varchar(255)	NO
useragent	varchar(255)	NO
config	mediumtext	NO
currencyFactor	double	NO

View full details →

s_order_basket_attributes

8 columns

Custom attribute extensions for order line items.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
basketID	int(11)	YES	Unique Foreign Key → s_order_basket.id
attribute1	text	YES
attribute2	text	YES
attribute3	text	YES
attribute4	text	YES
attribute5	text	YES
attribute6	text	YES

View full details →

s_order_basket_signatures

3 columns

Basket signature hashes used to detect cart changes during checkout.

Column	Type	Nullable	Additional
signature	varchar(200)	NO	Primary Key
basket	longtext	NO
created_at	date	NO	Index

View full details →

s_order_billingaddress

19 columns

Billing address snapshot at time of order (immutable copy).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
userID	int(11)	YES	Index
orderID	int(11)	NO	Unique
company	varchar(255)	NO
department	varchar(35)	NO
salutation	varchar(30)	NO
customernumber	varchar(30)	YES
firstname	varchar(50)	NO
lastname	varchar(60)	NO
street	varchar(255)	YES
zipcode	varchar(50)	NO
city	varchar(70)	NO
phone	varchar(40)	NO
countryID	int(11)	NO
stateID	int(11)	YES
ustid	varchar(50)	YES
additional_address_line1	varchar(255)	YES
additional_address_line2	varchar(255)	YES
title	varchar(100)	YES

View full details →

s_order_billingaddress_attributes

8 columns

Custom attribute extensions for order billing addresses.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
billingID	int(11)	YES	Unique Foreign Key → s_order_billingaddress.id
text1	text	YES
text2	text	YES
text3	text	YES
text4	text	YES
text5	text	YES
text6	text	YES

View full details →

s_order_comparisons

6 columns

Product comparison list items saved by customers.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
sessionID	varchar(128)	YES	Index
userID	int(11)	NO
articlename	varchar(255)	NO
articleID	int(11)	NO	Index
datum	datetime	NO	Index

View full details →

s_order_details

21 columns

Detailed order line item records with individual status tracking and serial numbers.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
orderID	int(11)	NO	Index Foreign Key → s_order.id
ordernumber	varchar(255)	YES	Index
articleID	int(11)	NO	Index
articleordernumber	varchar(255)	NO	Index
price	double	NO
quantity	int(11)	NO
name	varchar(255)	NO
status	int(1)	NO
shipped	int(11)	NO
shippedgroup	int(11)	NO
releasedate	date	YES
modus	int(11)	NO
esdarticle	int(1)	NO
taxID	int(11)	YES
tax_rate	double	NO
config	mediumtext	NO
ean	varchar(255)	YES
unit	varchar(255)	YES
pack_unit	varchar(255)	YES
articleDetailID	int(11) unsigned	YES

View full details →

s_order_details_attributes

8 columns

Custom attribute extensions for order detail line items.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
detailID	int(11)	YES	Unique Foreign Key → s_order_details.id
attribute1	text	YES
attribute2	text	YES
attribute3	text	YES
attribute4	text	YES
attribute5	text	YES
attribute6	text	YES

View full details →

s_order_documents

8 columns

Generated order documents (invoices, delivery notes, credit notes) with file reference.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
date	date	NO
type	int(11)	NO
userID	int(11)	NO	Index
orderID	int(11) unsigned	NO	Index
amount	double	NO
docID	varchar(30)	NO
hash	varchar(255)	NO

View full details →

s_order_documents_attributes

2 columns

Custom attribute extensions for order documents.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
documentID	int(11)	YES	Unique Foreign Key → s_order_documents.id

View full details →

s_order_esd

7 columns

ESD/digital download delivery tracking per order (download links, serial assignment).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
serialID	int(255)	NO
esdID	int(11)	NO
userID	int(11)	NO
orderID	int(11)	NO
orderdetailsID	int(11)	NO
datum	datetime	NO

View full details →

s_order_history

9 columns

Order status change history — audit log of payment and order state transitions.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
orderID	int(11)	NO	Index
userID	int(11)	YES	Index
previous_order_status_id	int(11)	YES	Index
order_status_id	int(11)	YES	Index
previous_payment_status_id	int(11)	YES	Index
payment_status_id	int(11)	YES	Index
comment	text	NO
change_date	datetime	YES

View full details →

s_order_notes

7 columns

Customer 'notepad/wishlist' items (saved products for later purchase).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
sUniqueID	varchar(70)	NO	Index
userID	int(11)	NO
articlename	varchar(255)	NO
articleID	int(11)	NO
ordernumber	varchar(255)	NO
datum	datetime	NO

View full details →

s_order_number

4 columns

Sequential number counters for orders, invoices, and other numbered entities.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
number	int(20)	NO
name	varchar(255)	NO	Unique
desc	varchar(255)	NO

View full details →

s_order_shippingaddress

17 columns

Shipping address snapshot at time of order (immutable copy).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
userID	int(11)	YES	Index
orderID	int(11)	NO	Unique
company	varchar(255)	NO
department	varchar(35)	NO
salutation	varchar(30)	NO
firstname	varchar(50)	NO
lastname	varchar(60)	NO
street	varchar(255)	YES
zipcode	varchar(50)	NO
city	varchar(70)	NO
phone	varchar(40)	YES
countryID	int(11)	NO
stateID	int(11)	YES
additional_address_line1	varchar(255)	YES
additional_address_line2	varchar(255)	YES
title	varchar(100)	YES

View full details →

s_order_shippingaddress_attributes

8 columns

Custom attribute extensions for order shipping addresses.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
shippingID	int(11)	YES	Unique Foreign Key → s_order_shippingaddress.id
text1	text	YES
text2	text	YES
text3	text	YES
text4	text	YES
text5	text	YES
text6	text	YES

View full details →

s_plugin_recommendations

6 columns

Plugin recommendations from Shopware's plugin marketplace.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
categoryID	int(11)	NO	Unique
banner_active	int(1)	NO
new_active	int(1)	NO
bought_active	int(1)	NO
supplier_active	int(1)	NO

View full details →

s_plugin_schema_version

6 columns

Tracks database schema migration versions per plugin.

Column	Type	Nullable	Additional
plugin_name	varchar(255)	NO	Primary Key
version	int(11)	NO	Primary Key
start_date	datetime	NO
complete_date	datetime	YES
name	varchar(255)	NO
error_msg	varchar(255)	YES

View full details →

s_plugin_widgets_notes

3 columns

Plugin-specific dashboard widget notes and user-created entries.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
userID	int(11)	NO
notes	text	NO

View full details →

s_premium_dispatch

27 columns

Shipping method definitions with calculation type, surcharges, and delivery rules.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
name	varchar(255)	NO
type	int(11) unsigned	NO
description	mediumtext	NO
comment	varchar(255)	NO
active	int(1) unsigned	NO
position	int(11)	NO
calculation	int(1) unsigned	NO
surcharge_calculation	int(1) unsigned	NO
tax_calculation	int(11) unsigned	NO
shippingfree	decimal(10,2) unsigned	YES
multishopID	int(11) unsigned	YES
customergroupID	int(11) unsigned	YES
bind_shippingfree	int(1) unsigned	NO
bind_time_from	int(11) unsigned	YES
bind_time_to	int(11) unsigned	YES
bind_instock	int(1) unsigned	YES
bind_laststock	int(1) unsigned	NO
bind_weekday_from	int(1) unsigned	YES
bind_weekday_to	int(1) unsigned	YES
bind_weight_from	decimal(10,3)	YES
bind_weight_to	decimal(10,3)	YES
bind_price_from	decimal(10,2)	YES
bind_price_to	decimal(10,2)	YES
bind_sql	mediumtext	YES
status_link	mediumtext	YES
calculation_sql	mediumtext	YES

View full details →

s_premium_dispatch_attributes

2 columns

Custom attribute extensions for shipping methods.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
dispatchID	int(11)	YES	Unique Foreign Key → s_premium_dispatch.id

View full details →

s_premium_dispatch_categories

2 columns

Category restrictions for shipping methods (limit to specific product categories).

Column	Type	Nullable	Additional
dispatchID	int(11) unsigned	NO	Primary Key
categoryID	int(11) unsigned	NO	Primary Key

View full details →

s_premium_dispatch_countries

2 columns

Country restrictions for shipping methods (which countries each method serves).

Column	Type	Nullable	Additional
dispatchID	int(11)	NO	Primary Key
countryID	int(11)	NO	Primary Key

View full details →

s_premium_dispatch_holidays

2 columns

Holiday exclusions for shipping methods (non-delivery dates).

Column	Type	Nullable	Additional
dispatchID	int(11) unsigned	NO	Primary Key
holidayID	int(11) unsigned	NO	Primary Key

View full details →

s_premium_dispatch_paymentmeans

2 columns

Payment method restrictions for shipping methods (e.g. cash on delivery only via specific carrier).

Column	Type	Nullable	Additional
dispatchID	int(11)	NO	Primary Key
paymentID	int(11)	NO	Primary Key

View full details →

s_premium_holidays

4 columns

Holiday/non-delivery date definitions used by shipping method scheduling.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
name	varchar(255)	NO
calculation	varchar(255)	NO
date	date	NO	Index

View full details →

s_premium_shippingcosts

5 columns

Graduated shipping cost tables — price tiers based on weight, price, or quantity.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
from	decimal(10,3) unsigned	NO	Index
value	decimal(10,2)	NO
factor	decimal(10,2)	NO
dispatchID	int(11) unsigned	NO

View full details →

s_product_streams

7 columns

Dynamic product groups (streams) defined by filter conditions for automatic product selection.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
name	varchar(255)	NO
conditions	text	YES
type	int(11)	YES
sorting	text	YES
description	text	YES
sorting_id	int(11)	YES

View full details →

s_product_streams_articles

3 columns

Manually assigned products within a product stream (static additions to dynamic groups).

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
stream_id	int(11) unsigned	NO	Index Foreign Key → s_product_streams.id
article_id	int(11) unsigned	NO	Index Foreign Key → s_articles.id

View full details →

s_product_streams_attributes

2 columns

Custom attribute extensions for product streams.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
streamID	int(11) unsigned	NO	Index Foreign Key → s_product_streams.id

View full details →

s_product_streams_selection

3 columns

Product selection/filter criteria definitions within product streams.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
stream_id	int(11) unsigned	NO	Index Foreign Key → s_product_streams.id
article_id	int(11) unsigned	NO	Index Foreign Key → s_articles.id

View full details →

s_schema_version

5 columns

Tracks executed core database schema migration versions.

Column	Type	Nullable	Additional
version	int(11)	NO	Primary Key
start_date	datetime	NO
complete_date	datetime	YES
name	varchar(255)	NO
error_msg	varchar(255)	YES

View full details →

s_search_custom_facet

8 columns

Custom search facets/filters for the storefront product search.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
active	int(1) unsigned	NO
unique_key	varchar(100)	YES	Unique
display_in_categories	int(1) unsigned	NO	Index
deletable	int(1) unsigned	NO
position	int(11)	NO
name	varchar(255)	NO
facet	longtext	NO

View full details →

s_search_custom_sorting

6 columns

Custom sort order definitions for product listings and search results.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
label	varchar(255)	NO
active	int(1) unsigned	NO
display_in_categories	int(1) unsigned	NO	Index
position	int(11)	NO
sortings	longtext	NO

View full details →

s_search_fields

6 columns

Configuration of which product fields are searchable and their relevance weighting.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
name	varchar(255)	NO
relevance	int(11)	NO
field	varchar(255)	NO	Index
tableID	int(11)	NO	Index
do_not_split	tinyint(1)	NO

View full details →

s_search_index

3 columns

Pre-computed search index for fast full-text product search matching.

Column	Type	Nullable	Additional
keywordID	int(11)	NO	Primary Key
fieldID	int(11)	NO	Primary Key
elementID	int(11)	NO	Primary Key

View full details →

s_search_keywords

3 columns

Keyword dictionary for the search index with stemming and relevance data.

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
keyword	varchar(255)	NO	Unique
soundex	varchar(255)	YES	Index

View full details →

s_search_tables

5 columns

Configuration of which database tables are included in the search index.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
table	varchar(255)	NO
referenz_table	varchar(255)	YES
foreign_key	varchar(255)	YES
where	varchar(255)	YES

View full details →

s_statistics_article_impression

6 columns

Product page view statistics (impressions per product per day).

Column	Type	Nullable	Additional
id	int(11) unsigned	NO	Primary Key
articleId	int(11) unsigned	NO	Index
shopId	int(11) unsigned	NO
date	date	NO
impressions	int(11)	NO
deviceType	varchar(50)	NO

View full details →

s_statistics_currentusers

6 columns

Currently active users/sessions on the storefront (real-time visitor tracking).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
remoteaddr	varchar(255)	NO
page	varchar(70)	NO
time	datetime	YES
userID	int(11)	NO
deviceType	varchar(50)	NO

View full details →

s_statistics_pool

3 columns

Statistical data pool for visitor analytics aggregation.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
remoteaddr	varchar(255)	NO
datum	date	NO

View full details →

s_statistics_referer

3 columns

Referrer URL statistics for traffic source analysis.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
datum	date	NO
referer	mediumtext	NO

View full details →

s_statistics_search

5 columns

Search term statistics — tracks what customers search for and how often.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
datum	datetime	NO
searchterm	varchar(255)	NO	Index
results	int(11)	NO
shop_id	int(11)	YES

View full details →

s_statistics_visitors

6 columns

Daily visitor count statistics (unique visitors and page impressions per shop).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
shopID	int(11)	NO
datum	date	NO	Index
pageimpressions	int(11)	NO
uniquevisits	int(11)	NO
deviceType	varchar(50)	NO

View full details →

s_user

38 columns

Storefront customer accounts — email, password hash, customer group, active status, and registration date.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
password	varchar(1024)	NO
encoder	varchar(255)	NO
email	varchar(70)	NO	Index
active	int(1)	NO
accountmode	int(11)	NO
confirmationkey	varchar(100)	NO
paymentID	int(11)	NO
doubleOptinRegister	tinyint(1)	YES
doubleOptinEmailSentDate	datetime	YES
doubleOptinConfirmDate	datetime	YES
firstlogin	date	NO	Index
lastlogin	datetime	NO	Index
sessionID	varchar(128)	YES	Index
newsletter	int(1)	NO
validation	varchar(255)	NO	Index
affiliate	int(10)	NO
customergroup	varchar(15)	NO	Index
paymentpreset	int(11)	NO
language	varchar(10)	NO
subshopID	int(11)	NO
referer	varchar(255)	NO
pricegroupID	int(11) unsigned	YES	Index
internalcomment	mediumtext	NO
failedlogins	int(11)	NO
lockeduntil	datetime	YES
default_billing_address_id	int(11)	YES	Index
default_shipping_address_id	int(11)	YES	Index
title	varchar(100)	YES
salutation	varchar(30)	YES
firstname	varchar(255)	YES
lastname	varchar(255)	YES
birthday	date	YES
customernumber	varchar(30)	YES
login_token	varchar(250)	YES
changed	datetime	YES
password_change_date	datetime	NO
register_opt_in_id	int(11)	YES

View full details →

s_user_addresses

17 columns

Unified customer address book (SW 5.2+) — all billing and shipping addresses.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
user_id	int(11)	NO	Index Foreign Key → s_user.id
company	varchar(255)	YES
department	varchar(35)	YES
salutation	varchar(30)	NO
title	varchar(100)	YES
firstname	varchar(50)	NO
lastname	varchar(60)	NO
street	varchar(255)	YES
zipcode	varchar(50)	NO
city	varchar(70)	NO
country_id	int(11)	NO	Index Foreign Key → s_core_countries.id
state_id	int(11)	YES	Index Foreign Key → s_core_countries_states.id
ustid	varchar(50)	YES
phone	varchar(40)	YES
additional_address_line1	varchar(255)	YES
additional_address_line2	varchar(255)	YES

View full details →

s_user_addresses_attributes

8 columns

Custom attribute extensions for customer addresses.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
address_id	int(11)	NO	Unique Foreign Key → s_user_addresses.id
text1	text	YES
text2	text	YES
text3	text	YES
text4	text	YES
text5	text	YES
text6	text	YES

View full details →

s_user_attributes

2 columns

Custom attribute extensions for customer accounts.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
userID	int(11)	YES	Unique Foreign Key → s_user.id

View full details →

s_user_billingaddress

17 columns

Legacy default billing address for customers (pre-unified address book).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
userID	int(11)	NO	Unique
company	varchar(255)	NO
department	varchar(35)	NO
salutation	varchar(30)	NO
firstname	varchar(50)	NO
lastname	varchar(60)	NO
street	varchar(255)	YES
zipcode	varchar(50)	NO
city	varchar(70)	NO
phone	varchar(40)	NO
countryID	int(11)	NO
stateID	int(11)	YES
ustid	varchar(50)	YES
additional_address_line1	varchar(255)	YES
additional_address_line2	varchar(255)	YES
title	varchar(100)	YES

View full details →

s_user_billingaddress_attributes

8 columns

Custom attribute extensions for legacy customer billing addresses.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
billingID	int(11)	YES	Unique Foreign Key → s_user_billingaddress.id
text1	text	YES
text2	text	YES
text3	text	YES
text4	text	YES
text5	text	YES
text6	text	YES

View full details →

s_user_shippingaddress

15 columns

Legacy default shipping address for customers (pre-unified address book).

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
userID	int(11)	NO	Unique
company	varchar(255)	NO
department	varchar(35)	NO
salutation	varchar(30)	NO
firstname	varchar(50)	NO
lastname	varchar(60)	NO
street	varchar(255)	YES
zipcode	varchar(50)	NO
city	varchar(70)	NO
countryID	int(11)	YES
stateID	int(11)	YES
additional_address_line1	varchar(255)	YES
additional_address_line2	varchar(255)	YES
title	varchar(100)	YES

View full details →

s_user_shippingaddress_attributes

8 columns

Custom attribute extensions for legacy customer shipping addresses.

Column	Type	Nullable	Additional
id	int(11)	NO	Primary Key
shippingID	int(11)	YES	Unique Foreign Key → s_user_shippingaddress.id
text1	text	YES
text2	text	YES
text3	text	YES
text4	text	YES
text5	text	YES
text6	text	YES

View full details →