I'm looking for a diagram or schema of all Magento 2 database tables, such as Orders, Products, etc. and their relationships with each other.
Add a comment
|
2 Answers
EDIT: Just like Magento 1 Anna Völkl created a new version for Magento 2. Check her answer.
What you are looking for is an ERD (Entity Relationship Diagram). I have searched for a Magento 2 ERD but could not find and. I think someone from the community will publish one at some point.
Here is a blog post which describes the database changes between 1.x and 2.x briefly.
So if you read that you should be able to use a 1.x ERD. Which you can find here: http://anna.voelkl.at/magento-ce-1-9-2-2-database-diagram/
-
1Thanks Akif. I'm new to Magento with 2.0 so I'd rather not start with older versions, but this is the best thing I've seen so far. Teşekkürler! Commented Feb 9, 2016 at 19:03
More than a year ago I created the database diagram for the Magento Community Edition 1.9.2.2, so it was time to create a new version :-)
Here's the database diagram of the latest Magento Community Edition 2.1.3:
Magento CE 2.1.3 consists of 315 tables (that's 18 tables less compared to Magento CE 1.9.2.2).
You can find more details about what has changed in this blogpost: Magento CE 2.1.3 database diagram
answered Dec 27, 2016 at 16:02
-
-
Thanks for your great efforts. I started working on it and its very helpful. Also added link of this to my old post. Commented Feb 10, 2017 at 9:24
-
2
-
1The diagram was minified for the upload here. Click the link to the answer to the blogpost to find high-res image Commented Aug 3, 2017 at 10:27
-
1Hi @Hammerbot, that was my fault, i had a misconfiguration on my blog. Check out the links, they should be working again. You will also find the high quality diagram there. Commented Jul 26, 2018 at 11:20