Magereverse-magento database table Structure

The Magento database table structure is quite complex, with more than 250 tables containing a very large number of table associations, which is really a headache for developers who have just come into contact with Magento. It is often seen that the various properties of a product are scattered in very many tables, and there is no way to get their data out.

In fact, there is a very good foreign magento database table structure maintenance community, from the 1.3.2.1 era began to produce and update the Magento database table structure, has been updated with the official synchronization to 1.6.1 version. The Magento database table structure maintained by the community is excellent, you can view the table structure of any table, as well as related tables, table foreign keys and SQL code! As shown, through this tool, you can fully grasp the Magento Database table Association, whether it is the classification, product, order, customer, any table association is not a problem! It's still a hassle, though.

http://www.magereverse.com/

Original: http://www.cnblogs.com/i-kyle/archive/2012/08/13/2636556.html

Magereverse-magento database table Structure