26

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 – Sander Mangel Sep 16 '15 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. – Jai Sep 17 '15 at 11:39
  • I am still waiting for good answer. – Jai Sep 23 '15 at 14:52
  • Regarding the inchoo diagram, see magento.stackexchange.com/questions/73433/… – Fabian Schmengler Nov 2 '15 at 9:42
  • 2
    MageReverse.com was a great database information resource, but they died after 1.7.0.2 so that's the newest I can find. – Fiasco Labs Nov 2 '15 at 18:30
44

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

Magento CE 1.9.2.2

  • I am in need of magento seminar report , can u please comment the link here Madam – Sudhir Belagali Nov 17 '15 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. – Anna Völkl Nov 17 '15 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. – Jai Nov 23 '15 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 – Jai Nov 9 '16 at 3:43
  • 1
    Thanks a lot :) Yes, it was a lot of work. Good to see it's useful :) – Anna Völkl Sep 11 '17 at 14:08

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.