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

2 Answers 2

Reset to default
14

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, 2016 at 19:03
65

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, 2016 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, 2017 at 9:24
  • 2
    Do you have better image quality ? I see nothing
    – bourax
    Aug 3, 2017 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, 2017 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, 2018 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.