Shopware 5 Datenbank
Bitte beachten Sie, dass diese Übersicht nicht der aktuelle Shopwareversion entspricht. Ein Update ist in Bearbeitung.
| Tabelle | Spalten | Gebrauch |
|---|---|---|
| s_addon_premium | id, startprice, ordernumber, ordernumber_export, subshopID | Prämienartikel |
| s_articles | id, supplierID, name, description, description_long, shippingtime, datum, active, taxID, pseudosales, topseller, metaTitle, keywords, changetime, pricegroupID, pricegroupActive, filtergroupID, laststock, crossbundlelook, notification, template, mode, main_detail_id, available_from, available_to, configurator_set_id | Grundinformation zum Artikel, z.B. Name und Beschreibung |
| s_articles_also_bought_ro | id, article_id, related_article_id, sales | Empfehlungsmarketing Kunden kauften auch |
| s_articles_attributes | id. articleID, articledetailsID, attr1, attr2, attr3, attr4, attr5, attr6, attr7, attr8, attr9, attr10, attr11, attr12, attr13, attr14, attr15, attr16, attr17, attr18, attr19, attr20 | Artikel Freitextfelder |
| s_articles_avoid_customergroups | articleID, customergroup | Bestimmte Artikel für Kundengruppen sperren |
| s_articles_categories | id, articleID, categoryID | Artikel zu (Leaf-)Kategorie-Zuweisung |
| s_articles_categories_ro | id, articleID, categoryID, parentCategoryID | Artikel zu Kategorie- und Elternkategorie-Zuweisung |
| s_articles_categories_seo | id, shop_id, article_id, category_id | Expliziter Artikel zu SEO-Kategorie Zuordnung |
| s_articles_details | id, articleID, ordernumber, suppliernumber, kind, additionaltext, sales, active, instock, stockmin, laststock, weight, position, width, height, length, ean, unitID, purchasesteps, maxpurchase, minpurchase, purchaseunit, referenceunit, packunit, releasedate, shippingfree, shippingtime, purchaseprice | Artikel Details, z.B. Bestellnummer oder Lagerbestand |
| s_articles_download | id, articleID, description, filename, size | Artikel optionaler Download |
| s_articles_downloads_attributes | id, downloadID | Artikel optionaler Download Freitextfelder |
| s_articles_esd | id, articleID, articledetailsID, file, serials, notification, maxdownloads, datum | ESD Artikel Einstellung, z.B. Artikelzuweisung |
| s_articles_esd_attributes | id, esdID | ESD Artikel Seriennummer Freitextfelder |
| s_articles_esd_serials | id, serialnumber, esdID | ESD Artikel Seriennummer |
| s_articles_img | id, articleID, img, main, description, position, width, height, relations, extension, parent_id, article_detail_id, media_id | Artikelbilder |
| s_articles_img_attributes | id, imageID, attribute1, attribute2, attribute3 | Artikelbilder Freitextfelder |
| s_articles_information | id, articleID, description, link, target | Artikel Resourcen Links |
| s_articles_information_attributes | id, informationID | Artikel Resourcen Links Freitextfelder |
| s_articles_notification | id, ordernumber, date, mail, send, language, shopLink | Emailbenachrichtigung wenn Artikel ausverkauft |
| s_articles_prices | id, pricegroup, from, to, articleID, articledetailsID, price, pseudoprice, baseprice, percent | Artikelpreise |
| s_articles_prices_attributes | id, priceID | Artikelpreise Freitextfelder |
| s_articles_relationships | id, articleID, relatedarticle | Zubehör-Artikel |
| s_articles_similar | id, articleID, relatedarticle | Ähnliche Artikel |
| s_articles_similar_shown_ro | id, article_id, related_article_id, viewed, init_date | Artikel - Kunden haben sich ebenfalls angesehen |
| s_articles_supplier | id, name, img, link, description, meta_title, meta_description, meta_keywords, changed | Artikel Hersteller |
| s_articles_supplier_attributes | id, supplierID | Artikel Hersteller Freitextfelder |
| s_articles_top_seller_ro | id, article_id, sales, last_cleared | Artikel Meistverkauft/Topseller |
| s_articles_translations | id, articleID, languageID, name, keywords, description, description_long, description_clear, attr1, attr2, attr3, attr4, attr5 | Artikel Übersetzung Verweis auf s_core_translation |
| s_articles_vote | id, articleID, name, headline, comment, points, datum, active, email, answer, answer_date, shop_id | Artikelbewertung |
| s_article_configurator_dependencies | id, configurator_set_id, parent_id, child_id | k.A. |
| s_article_configurator_groups | id, name, description, position | Artikel Varianten Gruppe, z.B. Farbengruppe |
| s_article_configurator_groups_attributes | id, groupID | Artikel Varianten Gruppe Freitextfelder |
| s_article_configurator_options | id, group_id, name, position | Artikel Varianten Option, z.B. Gelb, Rot |
| s_article_configurator_options_attributes | id, optionID | Artikel Varianten Option Freitextfelder |
| s_article_configurator_option_relations | id, article_id, option_id | Artikel Varianten Zuweisung |
| s_article_configurator_price_variations | id, configurator_set_id, variation, options, is_gross | k.A. |
| s_article_configurator_sets | id, name, public, type | k.A. |
| s_article_configurator_set_group_relations | set_id, group_id | k.A. |
| s_article_configurator_set_option_relations | set_id, option_id | k.A. |
| s_article_configurator_templates | id, article_id, order_number, suppliernumber, additionaltext, impressions, sales, active, instock, stockmin, weight, position, width, height, length, ean, unit_id, purchasesteps, maxpurchase, minpurchase, purchaseunit, referenceunit, packunit, releasedate, shippingfree, shippingtime, purchaseprice | Artikel Variante Stammdaten |
| s_article_configurator_templates_attributes | id, template_id, attr1, attr2, attr3, attr4, attr5, attr6, attr7, attr8, attr9, attr10, attr11, attr12, attr13, attr14, attr15, attr16, attr17, attr18, attr19, attr20 | Artikel Variante Freitextfelder |
| s_article_configurator_template_prices | id, template_id, customer_group_key, from, to, price, pseudoprice, percent | Artikel Variante Preisgestaltung |
| s_article_configurator_template_prices_attributes | id, template_price_id | k.A. |
| s_article_img_mappings | id, image_id | k.A. |
| s_article_img_mapping_rules | id, mapping_id, option_id | k.A. |
| s_attribute_configuration | id, table_name, column_name, column_type, default_value, position, translatable, display_in_backend, custom, help_text, support_text, label, entity, array_store | Freittextfelder Konfiguration bzw Zuordnung. Inhalte werden jeweils in s_*_attributes verarbeitet. |
| s_billing_template | ID, name, value, typ, group, desc, position, show | Rechnungsvorlage (technisch) |
| s_blog | id, title, author_id, active, short_description, description, views, display_date, category_id, template, meta_keywords, meta_description, meta_title | Blog Eintrag |
| s_blog_assigned_articles | id, blog_id, article_id | Blog zugeordnete Artikel |
| s_blog_attributes | id, blog_id, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6 | Blog Freitextfelder |
| s_blog_comments | id, blog_id, name, headline, comment, creation_date, active, email, points | Blog Leser Kommentare |
| s_blog_media | id, blog_id, media_id, preview | Blog Bild und Medienzuordnung |
| s_blog_tags | id, blog_id, name | Blog Schlagwörter (tags) |
| s_campaigns_articles | id, parentID, articleordernumber, name, type, position | k.A. |
| s_campaigns_banner | id, parentID, image, link, linkTarget, description, | k.A. |
| s_campaigns_containers | id, promotionID, value, type, description, position, | k.A. |
| s_campaigns_groups | id, name, | Newsletter Empfängergruppen |
| s_campaigns_html | id, parentID, headline, html, image, link, alignment, | k.A. |
| s_campaigns_links | id, parentID, description, link, target, position, | k.A. |
| s_campaigns_logs | id, datum, mailingID, email, articleID, | Newsletter Log |
| s_campaigns_mailaddresses | id, customer, groupID, email, lastmailing, lastread, added, | Newsletter Empfänger bei Shop-Anmeldung |
| s_campaigns_maildata | id, email, groupID, salutation, title, firstname, lastname, street, zipcode, city, added, deleted, | Newsletter Registrierte Empfänger Details |
| s_campaigns_mailings | id, datum, groups, subject, sendermail, sendername, plaintext, templateID, languageID, status, locked, recipients, read, clicked, customergroup, publish, timed_delivery, | Gesendete Newsletter |
| s_campaigns_positions | id, promotionID, containerID, position, | k.A. |
| s_campaigns_sender | id, email, name, | Newsletter Absender |
| s_campaigns_templates | id, path, description, | Newsletter Vorlage |
| s_categories | id, parent, path, description, position, left, right, level, added, changed, metakeywords, metadescription, cmsheadline, cmstext, template, active, blog, external, hidefilter, hidetop, mediaID, product_box_layout, meta_title, stream_id, hide_sortings, sorting_ids, facet_ids, external_target, | Kategorien |
| s_categories_attributes | id, categoryID, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, | Kategorien Freitextfelder |
| s_categories_avoid_customergroups | categoryID, customergroupID, | Kategorie für bestimmte Kundengruppe sperren |
| s_cms_static | id, tpl1variable, tpl1path, tpl2variable, tpl2path, tpl3variable, tpl3path, description, html, grouping, position, link, target, parentID, page_title, meta_keywords, meta_description, changed, shop_ids, | Shopseiten und Formularseitenumleitungen |
| s_cms_static_attributes | id, cmsStaticID, | Shopseiten Freitextfelder. |
| s_cms_static_groups | id, name, key, active, mapping_id, | Shopseiten Gruppen, z.B. Links, Unten (Spalte 1) |
| s_cms_support | id, name, text, email, email_template, email_subject, text2, meta_title, meta_keywords, meta_description, ticket_typeID, isocode, shop_ids, | Formular Grundinformation, z.B. Überschrift, Absender-Email, Versendet-Meldung |
| s_cms_support_attributes | id, cmsSupportID, | Formular Freitextfelder |
| s_cms_support_fields | id, error_msg, name, note, typ, required, supportID, label, class, value, added, position, ticket_task, | Formular Eingabefelder/Variabeln , z.B. Anrede, Textfeld |
| s_core_acl_privileges | id, resourceID, name, | Backend Benutzer Privilegien, create, read, update, delete |
| s_core_acl_resources | id, name, pluginID, | Backend Benutzer Zugriffsquellen |
| s_core_acl_roles | id, roleID, resourceID, privilegeID, | Backend Benutzer Rollen zusammengesetzt aus Resourcen und Priviligien |
| s_core_auth | id, roleID, username, password, encoder, apiKey, localeID, sessionID, lastlogin, name, email, active, failedlogins, lockeduntil, extended_editor, disabled_cache, | Backend Benutzer Basisinformation |
| s_core_auth_attributes | id, authID, | Backend Benutzer Freitextfelder |
| s_core_auth_config | user_id, name, config, | Backend Benutzer Einstellungen, z.B. Zeige Wizard nicht |
| s_core_auth_roles | id, parentID, name, description, source, enabled, admin, | Backend Benutzer Rollen bzw. Gruppen, z.B. local_admins |
| s_core_config_elements | id, form_id, name, value, label, description, type, required, position, scope, options, | Grundeinstellungen, z.B. Eingabefeldbezeichnung, Eingabefeldbeschreibung |
| s_core_config_element_translations | id, element_id, locale_id, label, description, | Grundeinstellung Übersetzungen |
| s_core_config_forms | id, parent_id, name, label, description, position, plugin_id, | Grundeinstellung Formulare |
| s_core_config_form_translations | id, form_id, locale_id, label, description, | Grundeinstellungen Formulare Übersetzung |
| s_core_config_mails | id, stateId, name, frommail, fromname, subject, content, contentHTML, ishtml, attachment, mailtype, context, dirty, | Email-Vorlagen |
| s_core_config_mails_attachments | id, mailID, mediaID, shopID, | Email Dateianhänge |
| s_core_config_mails_attributes | id, mailID, | Email-Vorlagen Freitextfelder |
| s_core_config_values | id, element_id, shop_id, value, | Grundeinstellung Inhalte |
| s_core_countries | id, countryname, countryiso, areaID, countryen, position, notice, taxfree, taxfree_ustid, taxfree_ustid_checked, active, iso3, display_state_in_registration, force_state_in_registration, | Länder |
| s_core_countries_areas | id, name, active, | Länderzonen, z.B, Deutschland, Europa, Welt |
| s_core_countries_attributes | id, countryID, | Länder Freitextfelder |
| s_core_countries_states | id, countryID, name, shortcode, position, active, | Bundesländer |
| s_core_countries_states_attributes | id, stateID, | Bundesländer Freitextfelder |
| s_core_currencies | id, currency, name, standard, factor, templatechar, symbol_position, position, | Währungen |
| s_core_customergroups | id, groupkey, description, tax, taxinput, mode, discount, minimumorder, minimumordersurcharge, | Kundengruppen, z.B. Shopkunde (EK), Händler (H) |
| s_core_customergroups_attributes | id, customerGroupID, | Kundengruppen Freitextfelder |
| s_core_customergroups_discounts | id, groupID, basketdiscount, basketdiscountstart, | Kundengruppe Warenkorb-Rabatt |
| s_core_customerpricegroups | id, name, netto, active, | Kundengruppe Nettopreisanzeige |
| s_core_detail_states | id, description, position, mail, | Status einzelner Positionen in Bestellung, z.B. Offen, in Bearbeitung |
| s_core_documents | id, name, template, numbers, left, right, top, bottom, pagebreak, | PDF Belegerstellung, z.B. Rechnung, Lieferschein, Gutschrift |
| s_core_documents_box | id, documentID, name, style, value, | PDF Belegerstellung Elementstyling ,z.B. Header, Footer |
| s_core_engine_elements | id, groupID, domname, default, type, store, label, required, position, name, layout, variantable, help, translatable, | Artikel vordefinierte Freitextfelder, z.B. Freitext-1, Freitext-2, Kommentar |
| s_core_engine_groups | id, name, label, layout, variantable, position, | Artikel Stammdaten Rahmen,z.B. Stammdaten, Beschreibung, Eigenschaften |
| s_core_licenses | id, module, host, label, license, version, notation, type, source, added, creation, expiration, active, plugin_id, | Plugin Lizenzen |
| s_core_locales | id, locale, language, territory, | Lokalisierung, Sprache, Gebiet, ISO |
| s_core_log | id, type, key, text, date, user, ip_address, user_agent, value4, | Backend Log der Benutzer und ihrer Aktivität |
| s_core_menu | id, parent, name, onclick, class, position, active, pluginID, controller, shortcut, action, | Backend Menü/Navigationspunkte |
| s_core_optin | id, type, datum, hash, data, | Opt-In, z.B. für Newsletteranmeldung oder Shopregistrierung |
| s_core_paymentmeans | id, name, description, template, class, table, hide, additionaldescription, debit_percent, surcharge, surchargestring, position, active, esdactive, embediframe, hideprospect, action, pluginID, source, mobile_inactive, | Zahlungsarten, z.B. Vorkasse, Lastschrift |
| s_core_paymentmeans_attributes | id, paymentmeanID, | Zahlungsarten Freitextfelder |
| s_core_paymentmeans_countries | paymentID, countryID, | Zahlungsarten Länder-Auswahl |
| s_core_paymentmeans_subshops | paymentID, subshopID, | Zahlungsarten Subshop-Auswahl |
| s_core_payment_data | id, payment_mean_id, user_id, use_billing_data, bankname, bic, iban, account_number, bank_code, account_holder, created_at, | k.A. |
| s_core_payment_instance | id, payment_mean_id, order_id, user_id, firstname, lastname, address, zipcode, city, account_number, account_holder, bank_name, bank_code, bic, iban, amount, created_at, | Zahlungsart zu User und Bestellung |
| s_core_plugins | id, namespace, name, label, source, description, translations, description_long, active, added, installation_date, update_date, refresh_date, author, copyright, license, version, support, changes, link, store_version, store_date, capability_update, capability_install, capability_enable, update_source, update_version, capability_secure_uninstall, in_safe_mode, | Plugins Einstellungen |
| s_core_plugin_categories | id, locale, parent_id, name, | Pluginmanager Pluginvorschläge unter "Endecken" |
| s_core_pricegroups | id, description, | Preisgruppen |
| s_core_pricegroups_discounts | id, groupID, customergroupID, discount, discountstart | Preisgruppen Rabatte |
| s_core_rewrite_urls | id, org_path, path, main, subshopID | SEO URL |
| s_core_rulesets | id, paymentID, rule1, value1, rule2, value2, | Riskmanagement, z.B. Sperre Payment XY aus Kategorie 3 |
| s_core_sessions | id, data, modified, expiry | Frontend Besucher Sessions in UTC |
| s_core_sessions_backend | id, data, modified, expiry | Backend Benutzer Sessions in UTC |
| s_core_shops | id, main_id, name, title, position, host, base_path, base_url, hosts, secure, secure_host, secure_base_path, template_id, document_template_id, category_id, locale_id, currency_id, customer_group_id, fallback_id, customer_scope, default, active, always_secure, | Shops, z.B. Hauptshop und Subshop |
| s_core_shop_currencies | shop_id, currency_id | Shop zu Währung Zuweisung |
| s_core_shop_pages | shop_id, group_id | Shop zu Shopseitengruppen Zuweisung |
| s_core_snippets | id, namespace, shopID, localeID, name, value, created, updated, dirty, | Textbausteine |
| s_core_states | id, name, description, position, group, mail, | Status, z.B. Bestellstatus, Zahlstatus |
| s_core_subscribes | id, subscribe, type, listener, pluginID, position, | Plugin Subscribes/Listener |
| s_core_tax | id, tax, description, | Steuern |
| s_core_tax_rules | id, areaID, countryID, stateID, groupID, customer_groupID, tax, name, active, | Abweichende Steuerregeln |
| s_core_templates | id, template, name, description, author, license, esi, style_support, emotion, version, plugin_id, parent_id, | Hinterlegte Themes |
| s_core_templates_config_elements | id, template_id, type, name, position, default_value, selection, field_label, support_text, allow_blank, container_id, attributes, less_compatible, | Theme Element Einstellungen, z.B. LESS Namensdeklaration |
| s_core_templates_config_layout | id, parent_id, template_id, type, name, title, attributes, | Theme Layout |
| s_core_templates_config_set | id, template_id, name, description, element_values, | Theme Farbschemas, z.B. Shop in Grün |
| s_core_templates_config_values | id, element_id, shop_id, value, | Theme Variablen, z.b. LESS Farbendefinition |
| s_core_theme_settings | id, compiler_force, compiler_create_source_map, compiler_compress_css, compiler_compress_js, force_reload_snippets, | Theme Systemkonfiguration, z.B. Sourcemap erstellen |
| s_core_translations | id, objecttype, objectdata, objectkey, objectlanguage, dirty | Übersetzungen aus Artikel, Einkaufswelten, Dokumenten |
| s_core_units | id, unit, description | Preiseinheiten, zB. Stück, Gramm, Liter |
| s_core_widgets | id, name, label, plugin_id | Backend Widgets |
| s_core_widget_views | id, widget_id, auth_id, column, position | Backend Widget zu Benutzer Zuordnung |
| s_crontab | id, name, action, elementID, data, next, start, interval, active, disable_on_error, end, inform_template, inform_mail, pluginID | Cronjobs, z.B. Geburtstagsgruß, Email-Benachrichtigung |
| s_customer_search_index | id, email, active, accountmode, firstlogin, newsletter, shop_id, default_billing_address_id, title, salutation, firstname, lastname, birthday, customernumber, customer_group_id, customer_group_name, payment_id, company, department, street, zipcode, city, phone, additional_address_line1, additional_address_line2, country_id, country_name, state_id, age, count_orders, invoice_amount_sum, invoice_amount_avg, invoice_amount_min, invoice_amount_max, first_order_time, last_order_time, has_canceled_orders, product_avg, ordered_at_weekdays, ordered_in_shops, ordered_on_devices, ordered_with_deliveries, ordered_with_payments, ordered_products, ordered_products_of_categories, ordered_products_of_manufacturer, index_time, | k.A. |
| s_customer_streams | id, name, conditions, description, freeze_up, static, | k.A. |
| s_customer_streams_attributes | id, streamID, | k.A. |
| s_customer_streams_mapping | stream_id, customer_id, | k.A. |
| s_emarketing_banners | id, description, valid_from, valid_to, img, link, link_target, categoryID, extension, | k.A. |
| s_emarketing_banners_attributes | id, bannerID, | k.A. |
| s_emarketing_banners_statistics | id, bannerID, display_date, clicks, views, | k.A. |
| s_emarketing_lastarticles | id, articleID, sessionID, time, userID, shopID, | Kunde zuletzt angesehene Artikel |
| s_emarketing_partner | id, idcode, datum, company, contact, street, zipcode, city, phone, fax, country, email, web, profil, fix, percent, cookielifetime, active, userID, | Partnerprogramm Grundeinstellung |
| s_emarketing_partner_attributes | id, partnerID, | Partnerprogramm Freitextfelder |
| s_emarketing_referer | id, userID, referer, date, | k.A. |
| s_emarketing_tellafriend | id, datum, recipient, sender, confirmed, | Artikel Weiterempfehlung email |
| s_emarketing_vouchers | id, description, vouchercode, numberofunits, value, minimumcharge, shippingfree, bindtosupplier, valid_from, valid_to, ordercode, modus, percental, numorder, customergroup, restrictarticles, strict, subshopID, taxconfig, customer_stream_ids, | Gutscheine |
| s_emarketing_vouchers_attributes | id, voucherID, | Gutscheine Freitextfelder |
| s_emarketing_voucher_codes | id, voucherID, userID, code, cashed, | Gutscheincodes |
| s_emotion | id, active, name, cols, cell_spacing, cell_height, article_height, rows, valid_from, valid_to, userID, show_listing, is_landingpage, seo_title, seo_keywords, seo_description, create_date, modified, template_id, device, fullscreen, mode, position, parent_id, preview_id, preview_secret, customer_stream_ids, replacement, | Einkaufswelten |
| s_emotion_attributes | id, emotionID, | Einkaufswelten Freitextfelder |
| s_emotion_categories | id, emotion_id, category_id, | Einkaufswelt Kategoriezuweisung |
| s_emotion_element | id, emotionID, componentID, start_row, start_col, end_row, end_col, css_class, | Einkaufswelt Element |
| s_emotion_element_value | id, emotionID, elementID, componentID, fieldID, value, | Einkaufswelt Element Wert, z.B. ausgewählter Artikel mit Artikelnummer |
| s_emotion_element_viewports | id, elementID, emotionID, alias, start_row, start_col, end_row, end_col, visible, | Einkaufswelt Darstellungszuweiseung, z.B. Desktop |
| s_emotion_presets | id, name, premium, custom, thumbnail, preview, preset_data, required_plugins, emotion_translations, assets_imported, hidden, | k.A. |
| s_emotion_preset_translations | id, presetID, label, description, locale, | k.A. |
| s_emotion_shops | id, emotion_id, shop_id, | k.A. |
| s_emotion_templates | id, name, file, | k.A. |
| s_es_backlog | id, event, payload, time, | Elastic Search Log |
| s_export | id, name, last_export, active, hash, show, count_articles, expiry, interval, formatID, last_change, filename, encodingID, categoryID, currencyID, customergroupID, partnerID, languageID, active_filter, image_filter, stockmin_filter, instock_filter, price_filter, own_filter, header, body, footer, count_filter, multishopID, variant_export, cache_refreshed, dirty, | Produktexport |
| s_export_articles | feedID, articleID, | Produkteexport Artikel-Filter |
| s_export_attributes | id, exportID, | Produktexport Freitextfelder. |
| s_export_categories | feedID, categoryID, | Produktexport geblockte Kategorien |
| s_export_suppliers | feedID, supplierID, | Produktexport Hersteller-Filter |
| s_filter | id, name, position, comparable, sortmode, | Artikel Eigenschaften Sets |
| s_filter_articles | articleID, valueID, | Artikel Eigenschaften zugewiesene Artikel |
| s_filter_attributes | id, filterID, | Artikel Eigeschaften Sets Freitextfelder |
| s_filter_options | id, name, filterable, | Artikel Eigenschaften Gruppen |
| s_filter_options_attributes | id, optionID, | Artikel Eigenschaften Gruppen Freitextfelder |
| s_filter_relations | id, groupID, optionID, position, | Artikel Eigenschaften Sets zu Gruppen- Zusammenhang |
| s_filter_values | id, optionID, value, position, media_id, | Artikel Eigenschaften - Optionen |
| s_filter_values_attributes | id, valueID, | Artikel Eigenschaften Optionen Freitextfelder |
| s_import_export_expression | id, profile_id, variable, export_conversion, import_conversion, | k.A. |
| s_import_export_log | id, session_id, message, state, created_at, | Log Informationen für Export |
| s_import_export_profile | id, type, base_profile, name, description, tree, hidden, is_default, | Export Profile, z.B. Alle Bestellungen mit Minimalinfos |
| s_import_export_session | id, profile_id, type, ids, position, total_count, username, file_name, format, file_size, state, created_at, | k.A. |
| s_library_component | id, name, x_type, convert_function, description, template, cls, pluginID, | Einkaufwelt Elemente, z.B. Artikelbox, Hersteller-Slider |
| s_library_component_field | id, componentID, name, x_type, value_type, field_label, support_text, help_title, help_text, store, display_field, value_field, default_value, allow_blank, translatable, position, | Einkaufswelt Elemente Einstellungsfelder, z.B. Element Hersteller-Slider Rotationsgeschwindigkeit |
| s_media | id, albumID, name, description, path, type, extension, file_size, width, height, userID, created, | Medienverwaltung |
| s_media_album | id, name, parentID, position, | Medienmanager Albumbezeichnung |
| s_media_album_settings | id, albumID, create_thumbnails, thumbnail_size, icon, thumbnail_high_dpi, thumbnail_quality, thumbnail_high_dpi_quality, | Medienmanager Albumeinstellungen, z.B, Album-Icon oder Thumbnailgrößen |
| s_media_association | id, mediaID, targetType, targetID, | k.A. |
| s_media_attributes | id, mediaID, | Medienmanager Freitext |
| s_multi_edit_backup | id, filter_string, operation_string, items, date, size, path, hash, | Artikelübersicht Mehrfachänderung Backup |
| s_multi_edit_filter | id, name, filter_string, description, created, is_favorite, is_simple, | Artikelübersicht Filter |
| s_multi_edit_queue | id, resource, filter_string, operations, items, active, created, | k.A. |
| s_multi_edit_queue_articles | id, queue_id, detail_id, | k.A. |
| s_order | id, ordernumber, userID, invoice_amount, invoice_amount_net, invoice_shipping, invoice_shipping_net, ordertime, status, cleared, paymentID, transactionID, comment, customercomment, internalcomment, net, taxfree, partnerID, temporaryID, referer, cleareddate, trackingcode, language, dispatchID, currency, currencyFactor, subshopID, remote_addr, deviceType | Bestellungen |
| s_order_attributes | id, orderID, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, swag_payal_billing_agreement_id, swag_payal_express, | Bestellung Freitextfelder |
| s_order_basket | id, sessionID, userID, articlename, articleID, ordernumber, shippingfree, quantity, price, netprice, tax_rate, datum, modus, esdarticle, partnerID, lastviewport, useragent, config, currencyFactor | Warenkörbe |
| s_order_basket_attributes | id, basketID, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, | Warenkörbe Freitextfelder |
| s_order_basket_signatures | signature, basket, created_at, | k.A. |
| s_order_billingaddress | id, userID, orderID, company, department, salutation, customernumber, firstname, lastname, street, zipcode, city, phone, countryID, stateID, ustid, additional_address_line1, additional_address_line2, title, | Bestellung Rechnungsadresse |
| s_order_billingaddress_attributes | id, billingID, text1, text2, text3, text4, text5, text6, | Bestellung Rechnungsadresse Freitextfelder |
| s_order_comparisons | id, sessionID, userID, articlename, articleID, datum, | k.A. |
| s_order_details | id, orderID, ordernumber, articleID, articleordernumber, price, quantity, name, status, shipped, shippedgroup, releasedate, modus, esdarticle, taxID, tax_rate, config, ean, unit, pack_unit, | Bestellung Details, z.B. Positionen |
| s_order_details_attributes | id, detailID, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, | Bestellung Details Freitextfelder |
| s_order_documents | ID, date, type, userID, orderID, amount, docID, hash, | Bestellung generierte Dokumente, z.B. Rechnung. |
| s_order_documents_attributes | id, documentID, | Bestellung generierte Dokumente Freitextfelder |
| s_order_esd | id, serialID, esdID, userID, orderID, orderdetailsID, datum, | k.A. |
| s_order_history | id, orderID, userID, previous_order_status_id, order_status_id, previous_payment_status_id, payment_status_id, comment, change_date, | Bestellung Status Historie |
| s_order_notes | id, sUniqueID, userID, articlename, articleID, ordernumber, datum, | k.A. |
| s_order_number | id, number, name, desc, | Nummernkreise |
| s_order_shippingaddress | id, userID, orderID, company, department, salutation, firstname, lastname, street, zipcode, city, phone, countryID, stateID, additional_address_line1, additional_address_line2, title, | Bestellung Lieferadresse |
| s_order_shippingaddress_attributes | id, shippingID, text1, text2, text3, text4, text5, text6, | Bestellung Lieferadresse Freitextfelder |
| s_plugin_recommendations | id, categoryID, banner_active, new_active, bought_active, supplier_active, | k.A. |
| s_plugin_widgets_notes | id, userID, notes, | k.A. |
| s_premium_dispatch | id, name, type, description, comment, active, position, calculation, surcharge_calculation, tax_calculation, shippingfree, multishopID, customergroupID, bind_shippingfree, bind_time_from, bind_time_to, bind_instock, bind_laststock, bind_weekday_from, bind_weekday_to, bind_weight_from, bind_weight_to, bind_price_from, bind_price_to, bind_sql, status_link, calculation_sql, | Versandkosten Übersicht |
| s_premium_dispatch_attributes | id, dispatchID, | Versandkosten Freitextfelder |
| s_premium_dispatch_categories | dispatchID, categoryID, | Versandkosten Kategorie sperren. |
| s_premium_dispatch_countries | dispatchID, countryID, | Versandkosten Länderauswahl |
| s_premium_dispatch_holidays | dispatchID, holidayID, | Versandkosten Feiertage sperren |
| s_premium_dispatch_paymentmeans | dispatchID, paymentID, | Versandkosten Zahlart Auswah |
| s_premium_holidays | id, name, calculation, date, | Feiertage Auflistung |
| s_premium_shippingcosts | id, from, value, factor, dispatchID, | Versandkosten |
| s_product_streams | id, name, conditions, type, sorting, description, sorting_id, | Product Stream / Artikelfilter |
| s_product_streams_articles | id, stream_id, article_id, | Product Stream Artikel |
| s_product_streams_attributes | id, streamID, | Product Stream Freitextfelder. |
| s_product_streams_selection | id, stream_id, article_id, | Product Stream Auswahl |
| s_schema_version | version, start_date, complete_date, name, error_msg, | Shopware Update Deltas und Fehlermeldungen |
| s_search_custom_facet | id, active, unique_key, display_in_categories, deletable, position, name, facet, | Suche Filter |
| s_search_custom_sorting | id, label, active, display_in_categories, position, sortings, | Suche Sortierung |
| s_search_fields | id, name, relevance, field, tableID, do_not_split | Suche durchsuchte Datenbank-Tabellen |
| s_search_index | keywordID, fieldID, elementID | Suche Index für Suchwörter und deren Datenbank-Tabellen-Fundort |
| s_search_keywords | id, keyword, soundex, | Suche Suchwörter |
| s_search_tables | id, table, referenz_table, foreign_key, where, | Suche Datenbank-Tabellen Abhängigkeit |
| s_statistics_article_impression | id, articleId, shopId, date, impressions, deviceType, | Statistik Artikelaufrufe |
| s_statistics_currentusers | id, remoteaddr, page, time, userID, deviceType, | Statistik Besucher Online |
| s_statistics_pool | id, remoteaddr, datum, | k.A. |
| s_statistics_referer | id, datum, referer, | Statistik Besucher Zugriffquellen |
| s_statistics_search | id, datum, searchterm, results, shop_id, | Statistik Suchwörter |
| s_statistics_visitors | id, shopID, datum, pageimpressions, uniquevisits, deviceType, | Statistik Besucher |
| s_user | id, password, encoder, email, active, accountmode, confirmationkey, paymentID, firstlogin, lastlogin, sessionID, newsletter, validation, affiliate, customergroup, paymentpreset, language, subshopID, referer, pricegroupID, internalcomment, failedlogins, lockeduntil, default_billing_address_id, default_shipping_address_id, title, salutation, firstname, lastname, birthday, customernumber, login_token, | Kunden-Informationen |
| s_user_addresses | id, user_id, company, department, salutation, title, firstname, lastname, street, zipcode, city, country_id, state_id, ustid, phone, additional_address_line1, additional_address_line2 | Kunden-Adresse |
| s_user_addresses_attributes | id, address_id, text1, text2, text3, text4, text5, text6 | Kunden-Adresse Freitextfelder. |
| s_user_attributes | id, userID | Kunden Freitextfelder |
| s_user_billingaddress | id, userID, company, department, salutation, firstname, lastname, street, zipcode, city, phone, countryID, stateID, ustid, additional_address_line1, additional_address_line2, title | Kunden-Rechnungsadresse |
| s_user_billingaddress_attributes | id, billingID, text1, text2, text3, text4, text5, text6 | Kunden-Rechnungsadresse Freitextfelder |
| s_user_shippingaddress | id, userID, company, department, salutation, firstname, lastname, street, zipcode, city, countryID, stateID, additional_address_line1, additional_address_line2, title | Kunden-Lieferadresse |
| s_user_shippingaddress_attributes | id, shippingID, text1, text2, text3, text4, text5, text6 | Kunden-Lieferadresse Freitextfelder |