MySQL 解释magento数据库结构
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/27418902/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Explain magento database structure
提问by user3783161
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
我正在尝试学习 magento 框架。但是很难理解数据库结构。因此，我正在寻找一份文档，描述每个表的具体功能并解释该表中的每一列。我在谷歌上搜索过，但我发现的只是 magento 数据库结构，没有任何描述（表和列）Magento 数据库图
ex:
the field converted_atin sales_flat_quotetable. I have no idea what this field do.
实例：在现场converted_at的sales_flat_quote桌子。我不知道这个领域是做什么的。
What I looking for is like this topic excellencemagentoblog.com: Magento EAV Database Structurebut it is only describe eav table
我要找的是这个话题excellentmagentoblog.com: Magento EAV Database Structure但它只是描述eav表
ps: so sorry because my bad english
ps：很抱歉，因为我的英语不好
采纳答案by Mounish Ambaliya
Below link would solve all you queries related to Database Structure :
下面的链接将解决所有与数据库结构相关的查询：
http://excellencemagentoblog.com/blog/2011/09/07/magento-eav-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
以下 2 个链接将向您展示数据库图：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.
如果您先浏览整个可用的 Magento 知识库文档，然后再去了解数据库，那就更好了。
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.
使用 EAV 表，我们可以灵活地在项目的任何点为产品、类别、客户等添加无限的属性，甚至无需费心更新数据库。
You need to understand Stores, Eav Attribute Set, Product Attributes, Website as all of this values are stored in Tables to differ the values.
您需要了解商店、Eav 属性集、产品属性、网站，因为所有这些值都存储在表中以区分这些值。
