Magento Database Diagram – Overview and Structure

databasemagento-1.3magento-1.9

I found this great diagram for Magento Database Tables, however, I would like to know if this is still up to date. I am running Magento 1.9. It was published in 2009 and several Magento updates have been rolled out since then. I am hoping that the database structure is still relatively the same. I'd like to get confirmation before I send it to the printer to get a large copy of it.

Diagram: MAGENTO_v1.3.2.4-Database_Diagram.pdf

Also, does anyone know where to find the table definitions? It would be a nice reference to go along with the diagram.

Best Answer

It's not up to date. There was a huge step in magento-1.6 and many minor changes in the other 1.x updates.

Especially the sales and index tables are completely different now, I would not use this sheet as a reference anymore.

Unfortunately table definitions are not in one place but scattered around hundreds of install and upgrade scripts. You will find them in app/code/core/Mage/*/sql/*/*.php

You will notice that there is usually a install-1.6.0.0.php script that sets up everything for the current module and Magento 1.6. Start there and ignore all scripts with lower versions. Changes are incrementally added with scripts like upgrade-1.6.0.0-1.6.1.0 and so on.

Update: Thanks to Anna Völkl, there is a new complete database diagram for Magento 1.9.2.2:

Source: http://anna.voelkl.at/magento-ce-1-9-2-2-database-diagram/

Related Solutions

Database – How to Create a Database Table from CSV

Never done this. Let's play!

After the createTable() call, or in a subsequent script:

/* @var $installer Mage_Core_Model_Resource_Setup */
$installer = $this;
$installer->startSetup();

//Extract data from CSV file
$csv = new Varien_File_Csv;
$data = $csv->getData('path/to/file.csv');

$resultNum = $installer->getConnection()->insertArray(
    $installer->getTable({TABLE NAME}),
    array({COL 1},{COL 2}),    //column names
    $data
);

//EDIT: if this is done using a data setup script, can even log the results:
Mage::log(
    __FILE__." added $resultNum records to $installer->getTable({TABLE NAME})",
    Zend_Log::INFO,
    "setup.log",
    true
);

$installer->endSetup();

Magento Database – Negative Values in sales_flat_order.discount_amount

The discount amounts on the complete order are stored with negative amounts, but are stored positively against each item that they effect.

Negative sales_flat_order
Positive sales_flat_order_item

The negative values is stored against the table sales_flat_quote_address and then copied across to the table sales_flat_order

Best Answer

Related Solutions

Database – How to Create a Database Table from CSV

Magento Database – Negative Values in sales_flat_order.discount_amount

Related Topic