Page 1 of 1
Relationship of Tables - Database
Posted: Mon Jun 18, 2012 7:21 pm
by HostGuardianX
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?
Re: Relationship of Tables - Database
Posted: Mon Jun 18, 2012 8:03 pm
by jcsmithy
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.
Re: Relationship of Tables - Database
Posted: Mon Jun 18, 2012 9:26 pm
by Avvici
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
Re: Relationship of Tables - Database
Posted: Mon Jun 18, 2012 10:18 pm
by HostGuardianX
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:
eyes.PNG (139.01 KiB) Viewed 6667 times
Re: Relationship of Tables - Database
Posted: Mon Jun 18, 2012 10:39 pm
by takahashi1973
Re: Relationship of Tables - Database
Posted: Tue Jun 19, 2012 5:16 am
by HostGuardianX
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:
ver.png (191.77 KiB) Viewed 6660 times
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:
tabelas.png (68.06 KiB) Viewed 6660 times
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.
Re: Relationship of Tables - Database
Posted: Tue Jun 19, 2012 5:31 am
by Avvici
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

Re: Relationship of Tables - Database
Posted: Tue Jun 19, 2012 11:01 am
by rajithg
use mysql workbench ... it doesnt have any table limits also its free