17

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.

Improve this question
13

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.

DB changes from M1 to M2

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/

Magento 1.9.2.2 ERD

Improve this answer
1
  • 1
    Thanks 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! – Brian Oconnell Feb 9 '16 at 19:03
63

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 Community Edition 2.1.3 database diagram

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

Improve this answer
12
  • Excellent work +1 from me @Anna :) – Keyur Shah Dec 29 '16 at 14:34
  • Thanks for your great efforts. I started working on it and its very helpful. Also added link of this to my old post. – Jarnail S Feb 10 '17 at 9:24
  • 1
    Do you have better image quality ? I see nothing – bourax Aug 3 '17 at 9:26
  • 1
    The diagram was minified for the upload here. Click the link to the answer to the blogpost to find high-res image – Anna Völkl Aug 3 '17 at 10:27
  • 1
    Hi @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. – Anna Völkl Jul 26 '18 at 11:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.