Relationship of Tables - Database

Hi all,

I am needing to know the relationship of the tables OpenCart is why I need the relational model example:




need to know all the links in the tables and their respective cardinalities!

looked at the official site for some documentation, but I even thought I had no one related to what I need.

Could someone help me?

There is no documentation telling you this. The only way to know if to look and figure it out.

IThe DB structure is very simple though, so you shouldn't have any problems doing this.

If you really want to see "relationship view" in phpmyadmin then you can follow this tutorial which will enable it: http://thedesignspace.net/MT2archives/0 ... 98sRrXiGdl

Actually I do not want to learn how to make the relationship but to see the relationship.

In phpmyadmin I have the OpenCart database, clicked on the designer and I see all the tables however it does not show the relationship.

I looked at the documentation site, but it does not have complete documentation. There is documentation that is paid, but I do not know if it comes complete with the relationship cardinalities of the OpenCart database.

I thought about making relationships but are 92 tables. I would take a long time to finish everything.

see the print that I took from my phpmyadmin:

http://www.quest.com/toad-for-mysql/

the TOAD will do this for you

takahashi1973 wrote:http://www.quest.com/toad-for-mysql/

the TOAD will do this for you

excellent tool liked it, but I can only view the tables, however it sailed on the menu did not see the option to see the relationship and the cardinalities, see the print below that I took:

when I found the option diagrams the program has loaded all the tables and appeared three posts, I took the print also check the messages below:

I understand the program has a limit of 50 tables at most, that's right or am I mistaken?

there is a tutorial of this tool in Portuguese / Brazil? It's because I am Brazilian and not his right to speak English, I'm using google translator.

I think that you have been guided to a possible solution enough. We don't offer support on other types of software unless it directly relates to your Open Cart installation and even then.. possibly not. Good luck

use mysql workbench ... it doesnt have any table limits also its free