I am looking for ER diagram of magento 1.9.x so that i can understand magento database flow and table-relationships. if anyone can provide me COMPLETE ER diagram that will really help me. Like i saw a good er diagram of prestashop but could not find such diagram of magento.

Update: For ER Diagram of Magento 2.1.3 check https://magento.stackexchange.com/a/152061/29175 . Thanks to efforts of @Anna Völkl

  • 2
    So asked around on twitter a bit and @R.S come up with inchoo.net/wp-content/uploads/2010/09/… It's a bit old but should get you a long way. Will keep looking tho cause it would be kinda handy to have Commented Sep 16, 2015 at 20:25
  • I already gone through this but its very old diagram and not COMPLETE ER diagram. I am looking on latest so that i go to deeper for understanding its relationship flow.
    – Jarnail S
    Commented Sep 17, 2015 at 11:39
  • I am still waiting for good answer.
    – Jarnail S
    Commented Sep 23, 2015 at 14:52
  • Regarding the inchoo diagram, see magento.stackexchange.com/questions/73433/… Commented Nov 2, 2015 at 9:42
  • 2
    MageReverse.com was a great database information resource, but they died after so that's the newest I can find. Commented Nov 2, 2015 at 18:30

1 Answer 1


I was also curious to find an updated database diagram. Actually I could not find one so I created one myself.

Magento CE consists of 333 tables.

This is the database diagram of a fresh CE installation:

As I cannot upload more than 2MB here, here's the link to the full size diagram

Magento CE

  • I am in need of magento seminar report , can u please comment the link here Madam Commented Nov 17, 2015 at 2:43
  • 1
    Not sure what you mean with "magento seminar report" but this is not related to the database diagram. You should start a new question if you need specific help. Commented Nov 17, 2015 at 14:22
  • @AnnaVölkl .. your efforts and the diagram is really useful. Big thx for this and if you get details about M2 diagram then please post the link here too though that not need of now but would beneficial in future. Thx again for above diagram.
    – Jarnail S
    Commented Nov 23, 2015 at 11:33
  • 1
    @AnnaVölkl ..how can i create same for magento2. if you can provide that would really beneficial for community. Looking for your response. Thank you
    – Jarnail S
    Commented Nov 9, 2016 at 3:43
  • 2
    Thanks a lot :) Yes, it was a lot of work. Good to see it's useful :) Commented Sep 11, 2017 at 14:08

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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