user3783161 user3783161 - 29 days ago 14
MySQL Question

Explain magento database structure

I am trying to learn magento framework. But it is hard to understand the database structure. So I am looking for a document that describe what each table exactly do and explain each column in that table. I have searched on google but all I found was magento database structure without any describes (table and column) Magento Database Diagram

ex:
the field

converted_at
in
sales_flat_quote
table. I have no idea what this field do.

What I looking for is like this topic excellencemagentoblog.com: Magento EAV Database Structure but it is only describe eav table

ps: so sorry because my bad english

Answer

Below link would solve all you queries related to Database Structure :

http://excellencemagentoblog.com/blog/2011/09/07/magento-eav-database-structure/

Below 2 links would show you the Database Diagram : http://inchoo.net/wp-content/uploads/2010/09/MAGENTO_v1.3.2.4-Database_Diagram.pdf

Its better if you go through whole Magento Knowledge Base Documents available first and then go for understanding the Database.

EAV tables are used to give us the flexibility of adding unlimited Attributes for Products, Categories, Customers etc at any point of project even without bothering to update the database.

You need to understand Stores, Eav Attribute Set, Product Attributes, Website as all of this values are stored in Tables to differ the values.