Shopware 5 Datenbank

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, 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