In Magento2, Have it has the database diagram yet ? I just found diagram for magento 1.x, Magento Database Diagram
Magento – Magento2 – Database diagram
databasemagento2
Related Solutions
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/
I was also curious to find an updated database diagram. Actually I could not find one so I created one myself.
Magento CE 1.9.2.2 consists of 333 tables.
This is the database diagram of a fresh CE 1.9.2.2 installation:
As I cannot upload more than 2MB here, here's the link to the full size diagram
Best Answer
You can create your own diagramm, for example with the Mysql Workbench. For creating a diagramm go to Database -> Reverse Engineer -> follow the wizard.
Here an example where i only add a view tables to the EER Diagramm: