Tabellen in der Magento-Datenbank

Die Datenbank von Magento ist sehr umfangreich. Um mehr Übersicht über die darin vorhandenen Tabellen zu bekommen, habe ich sie in einem Tabellenbaum zusammengefasst:

 

  • admin
    • admin_assert
    • admin_role
    • admin_rule
    • admin_user
  • adminnotification
    • adminnotification_inbox
  • api
    • api_assert
    • api_role
    • api_rule
    • api_session
    • api_user
  • catalog
    • category
      • anc
        • categs
          • index
            • catalog_category_anc_categs_index_idx
            • catalog_category_anc_categs_index_tmp
        • products
          • index
            • catalog_category_anc_products_index_idx
            • catalog_category_anc_products_index_tmp
      • catalog_category_entity
      • catalog_category_product
      • entity
        • catalog_category_entity_datetime
        • catalog_category_entity_decimal
        • catalog_category_entity_int
        • catalog_category_entity_text
        • catalog_category_entity_varchar
      • flat
        • store
          • catalog_category_flat_store_1
          • catalog_category_flat_store_2
          • catalog_category_flat_store_3
      • product
        • catalog_category_product_index
        • index
          • catalog_category_product_index_idx
          • catalog_category_product_index_tmp
          • enbl
            • catalog_category_product_index_enbl_idx
            • catalog_category_product_index_enbl_tmp
    • compare
      • catalog_compare_item
    • eav
      • catalog_eav_attribute
    • product
      • bundle
        • catalog_product_bundle_option
        • catalog_product_bundle_selection
        • option
          • catalog_product_bundle_option_value
        • price
          • catalog_product_bundle_price_index
        • selection
          • catalog_product_bundle_selection_price
        • stock
          • catalog_product_bundle_stock_index
      • catalog_product_entity
      • catalog_product_link
      • catalog_product_option
      • catalog_product_relation
      • catalog_product_website
      • enabled
        • catalog_product_enabled_index
      • entity
        • catalog_product_entity_datetime
        • catalog_product_entity_decimal
        • catalog_product_entity_gallery
        • catalog_product_entity_int
        • catalog_product_entity_text
        • catalog_product_entity_varchar
        • media
          • catalog_product_entity_media_gallery
          • gallery
            • catalog_product_entity_media_gallery_value
        • tier
          • catalog_product_entity_tier_price
      • flat
        • catalog_product_flat_1
        • catalog_product_flat_2
        • catalog_product_flat_3
      • index
        • catalog_product_index_eav
        • catalog_product_index_price
        • catalog_product_index_website
        • eav
          • catalog_product_index_eav_decimal
          • catalog_product_index_eav_idx
          • catalog_product_index_eav_tmp
          • decimal
            • catalog_product_index_eav_decimal_idx
            • catalog_product_index_eav_decimal_tmp
        • price
          • bundle
            • catalog_product_index_price_bundle_idx
            • catalog_product_index_price_bundle_tmp
            • opt
              • catalog_product_index_price_bundle_opt_idx
              • catalog_product_index_price_bundle_opt_tmp
            • sel
              • catalog_product_index_price_bundle_sel_idx
              • catalog_product_index_price_bundle_sel_tmp
          • catalog_product_index_price_idx
          • catalog_product_index_price_tmp
          • cfg
            • opt
              • agr
                • catalog_product_index_price_cfg_opt_agr_idx
                • catalog_product_index_price_cfg_opt_agr_tmp
              • catalog_product_index_price_cfg_opt_idx
              • catalog_product_index_price_cfg_opt_tmp
          • downlod
            • catalog_product_index_price_downlod_idx
            • catalog_product_index_price_downlod_tmp
          • final
            • catalog_product_index_price_final_idx
            • catalog_product_index_price_final_tmp
          • opt
            • agr
              • catalog_product_index_price_opt_agr_idx
              • catalog_product_index_price_opt_agr_tmp
            • catalog_product_index_price_opt_idx
            • catalog_product_index_price_opt_tmp
        • tier
          • catalog_product_index_tier_price
      • link
        • attribute
          • catalog_product_link_attribute_decimal
          • catalog_product_link_attribute_int
          • catalog_product_link_attribute_varchar
        • catalog_product_link_attribute
        • catalog_product_link_type
      • option
        • catalog_product_option_price
        • catalog_product_option_title
        • type
          • catalog_product_option_type_price
          • catalog_product_option_type_title
          • catalog_product_option_type_value
      • super
        • attribute
          • catalog_product_super_attribute_label
          • catalog_product_super_attribute_pricing
        • catalog_product_super_attribute
        • catalog_product_super_link
  • cataloginventory
    • cataloginventory_stock
    • stock
      • cataloginventory_stock_item
      • cataloginventory_stock_status
      • status
        • cataloginventory_stock_status_idx
        • cataloginventory_stock_status_tmp
  • catalogrule
    • affected
      • catalogrule_affected_product
    • catalogrule
    • catalogrule_product
    • group
      • catalogrule_group_website
    • product
      • catalogrule_product_price
  • catalogsearch
    • catalogsearch_fulltext
    • catalogsearch_query
    • catalogsearch_result
  • checkout
    • agreement
      • checkout_agreement_store
    • checkout_agreement
  • cms
    • block
      • cms_block_store
    • cms_block
    • cms_page
    • page
      • cms_page_store
  • core
    • cache
      • core_cache_option
      • core_cache_tag
    • config
      • core_config_data
    • core_cache
    • core_flag
    • core_resource
    • core_session
    • core_store
    • core_translate
    • core_variable
    • core_website
    • email
      • core_email_template
    • layout
      • core_layout_link
      • core_layout_update
    • store
      • core_store_group
    • url
      • core_url_rewrite
    • variable
      • core_variable_value
  • coupon
    • aggregated
      • coupon_aggregated_order
      • coupon_aggregated_updated
    • coupon_aggregated
  • cron
    • cron_schedule
  • customer
    • address
      • customer_address_entity
      • entity
        • customer_address_entity_datetime
        • customer_address_entity_decimal
        • customer_address_entity_int
        • customer_address_entity_text
        • customer_address_entity_varchar
    • customer_entity
    • customer_group
    • eav
      • attribute
        • customer_eav_attribute_website
      • customer_eav_attribute
    • entity
      • customer_entity_datetime
      • customer_entity_decimal
      • customer_entity_int
      • customer_entity_text
      • customer_entity_varchar
    • form
      • customer_form_attribute
  • dataflow
    • batch
      • dataflow_batch_export
      • dataflow_batch_import
    • dataflow_batch
    • dataflow_profile
    • dataflow_session
    • import
      • dataflow_import_data
    • profile
      • dataflow_profile_history
  • design
    • design_change
  • directory
    • country
      • directory_country_format
      • directory_country_region
      • region
        • directory_country_region_name
    • currency
      • directory_currency_rate
    • directory_country
  • downloadable
    • downloadable_link
    • downloadable_sample
    • link
      • downloadable_link_price
      • downloadable_link_purchased
      • downloadable_link_title
      • purchased
        • downloadable_link_purchased_item
    • sample
      • downloadable_sample_title
  • eav
    • attribute
      • eav_attribute_group
      • eav_attribute_label
      • eav_attribute_option
      • eav_attribute_set
      • option
        • eav_attribute_option_value
    • eav_attribute
    • eav_entity
    • entity
      • eav_entity_attribute
      • eav_entity_datetime
      • eav_entity_decimal
      • eav_entity_int
      • eav_entity_store
      • eav_entity_text
      • eav_entity_type
      • eav_entity_varchar
    • form
      • eav_form_element
      • eav_form_fieldset
      • eav_form_type
      • fieldset
        • eav_form_fieldset_label
      • type
        • eav_form_type_entity
  • find
    • feed
      • import
        • find_feed_import_codes
  • gift
    • gift_message
  • googlebase
    • googlebase_attributes
    • googlebase_items
    • googlebase_types
  • googlecheckout
    • googlecheckout_notification
  • googleoptimizer
    • googleoptimizer_code
  • importexport
    • importexport_importdata
  • index
    • index_event
    • index_process
    • process
      • index_process_event
  • log
    • log_customer
    • log_quote
    • log_summary
    • log_url
    • log_visitor
    • summary
      • log_summary_type
    • url
      • log_url_info
    • visitor
      • log_visitor_info
      • log_visitor_online
  • newsletter
    • newsletter_problem
    • newsletter_queue
    • newsletter_subscriber
    • newsletter_template
    • queue
      • newsletter_queue_link
      • store
        • newsletter_queue_store_link
  • paypal
    • payment
      • paypal_payment_transaction
    • paypal_cert
    • settlement
      • paypal_settlement_report
      • report
        • paypal_settlement_report_row
  • persistent
    • persistent_session
  • poll
    • poll
    • poll_answer
    • poll_store
    • poll_vote
  • product
    • alert
      • product_alert_price
      • product_alert_stock
  • rating
    • option
      • rating_option_vote
      • vote
        • rating_option_vote_aggregated
    • rating
    • rating_entity
    • rating_option
    • rating_store
    • rating_title
  • report
    • compared
      • product
        • report_compared_product_index
    • event
      • report_event_types
    • report_event
    • viewed
      • product
        • report_viewed_product_index
  • review
    • entity
      • review_entity_summary
    • review
    • review_detail
    • review_entity
    • review_status
    • review_store
  • sales
    • bestsellers
      • aggregated
        • sales_bestsellers_aggregated_daily
        • sales_bestsellers_aggregated_monthly
        • sales_bestsellers_aggregated_yearly
    • billing
      • agreement
        • sales_billing_agreement_order
      • sales_billing_agreement
    • flat
      • creditmemo
        • sales_flat_creditmemo_comment
        • sales_flat_creditmemo_grid
        • sales_flat_creditmemo_item
      • invoice
        • sales_flat_invoice_comment
        • sales_flat_invoice_grid
        • sales_flat_invoice_item
      • order
        • sales_flat_order_address
        • sales_flat_order_grid
        • sales_flat_order_item
        • sales_flat_order_payment
        • status
          • sales_flat_order_status_history
      • quote
        • address
          • sales_flat_quote_address_item
        • item
          • sales_flat_quote_item_option
        • sales_flat_quote_address
        • sales_flat_quote_item
        • sales_flat_quote_payment
        • shipping
          • sales_flat_quote_shipping_rate
      • sales_flat_creditmemo
      • sales_flat_invoice
      • sales_flat_order
      • sales_flat_quote
      • sales_flat_shipment
      • shipment
        • sales_flat_shipment_comment
        • sales_flat_shipment_grid
        • sales_flat_shipment_item
        • sales_flat_shipment_track
    • invoiced
      • aggregated
        • sales_invoiced_aggregated_order
      • sales_invoiced_aggregated
    • order
      • aggregated
        • sales_order_aggregated_created
        • sales_order_aggregated_updated
      • sales_order_status
      • sales_order_tax
      • status
        • sales_order_status_label
        • sales_order_status_state
      • tax
        • sales_order_tax_item
    • payment
      • sales_payment_transaction
    • recurring
      • profile
        • sales_recurring_profile_order
      • sales_recurring_profile
    • refunded
      • aggregated
        • sales_refunded_aggregated_order
      • sales_refunded_aggregated
    • shipping
      • aggregated
        • sales_shipping_aggregated_order
      • sales_shipping_aggregated
  • salesrule
    • coupon
      • salesrule_coupon_usage
    • product
      • salesrule_product_attribute
    • salesrule
    • salesrule_coupon
    • salesrule_customer
    • salesrule_label
  • sendfriend
    • sendfriend_log
  • shipping
    • shipping_tablerate
  • sitemap
    • sitemap
  • tag
    • tag
    • tag_properties
    • tag_relation
    • tag_summary
  • tax
    • calculation
      • rate
        • tax_calculation_rate_title
      • tax_calculation_rate
      • tax_calculation_rule
    • order
      • aggregated
        • tax_order_aggregated_created
        • tax_order_aggregated_updated
    • tax_calculation
    • tax_class
  • weee
    • weee_discount
    • weee_tax
  • widget
    • instance
      • page
        • widget_instance_page_layout
      • widget_instance_page
    • widget
    • widget_instance
  • wishlist
    • item
      • wishlist_item_option
    • wishlist
    • wishlist_item
  • xmlconnect
    • config
      • xmlconnect_config_data
    • notification
      • xmlconnect_notification_template
    • xmlconnect_application
    • xmlconnect_history
    • xmlconnect_queue
Dieser Beitrag wurde unter Reports veröffentlicht. Setze ein Lesezeichen auf den Permalink.

5 Antworten auf Tabellen in der Magento-Datenbank

  1. marco sagt:

    mich würde mal interessieren, ob man eine Individualisierungsoption für mehere artikel in der datenbank ändern kann. es geht dabei um eine option die für alle artikel als pflichtfeld gelten soll.ist im moment für 60000 artikel auf nein gestellt.

    danke und gruß

  2. Marx sagt:

    Wie kann ich producte von eine kategorie löschen ?

    • pawel sagt:

      Es gibt die Backend-Erweiterung „Enhanced Admin Product Grid“ mit der es möglich ist, Produkte nach Kategorie zu filtern, nach dem man die entsprechende Spalte hinzugefügt hat. Mit Boardmitteln ist es im Backend aber nicht möglich, alle Produkte einer bestimmten Kategorie zu löschen. Zuweisungen Produkt <> Kategorie sind sonst in der Tabelle catalog_category_product gespeichert und können mit einer SQL-Abfrage dort gelöscht werden.

  3. Silberschlag sagt:

    Wie kann ich aus einer Tabelle z.B. den ersten Satz von salesrule_coupon auf eine csh-seite in Magento anzeigen lassen ?

    Vielen Dank

Schreib einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind markiert *