29

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

Improve this question
7
  • 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
    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/…
    – Fabian Schmengler
    Commented Nov 2, 2015 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
    Commented Nov 2, 2015 at 18:30

1 Answer 1

Reset to default
59

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

Improve this answer
8
  • I am in need of magento seminar report , can u please comment the link here Madam
    – Sudhir Belagali
    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.
    – Anna Völkl
    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 :)
    – Anna Völkl
    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.