Post by HostGuardianX » Mon Jun 18, 2012 7:21 pm

Hi all,

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

Image


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?

Newbie

Posts

Joined
Mon Jun 18, 2012 7:20 pm

Post by jcsmithy » Mon Jun 18, 2012 8:03 pm

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.

Active Member

Posts

Joined
Fri Oct 01, 2010 9:54 pm

Post by Avvici » Mon Jun 18, 2012 9:26 pm

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

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC

Post by HostGuardianX » Mon Jun 18, 2012 10:18 pm

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

eyes.PNG (139.01 KiB) Viewed 5307 times


Newbie

Posts

Joined
Mon Jun 18, 2012 7:20 pm

Post by takahashi1973 » Mon Jun 18, 2012 10:39 pm

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

the TOAD will do this for you :)

Active Member

Posts

Joined
Thu Oct 13, 2011 11:41 pm

Post by HostGuardianX » Tue Jun 19, 2012 5:16 am

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:
ver.png

ver.png (191.77 KiB) Viewed 5300 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

tabelas.png (68.06 KiB) Viewed 5300 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.

Newbie

Posts

Joined
Mon Jun 18, 2012 7:20 pm

Post by Avvici » Tue Jun 19, 2012 5:31 am

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 ;)

User avatar
Expert Member

Posts

Joined
Tue Apr 05, 2011 12:09 pm
Location - Asheville, NC

Post by rajithg » Tue Jun 19, 2012 11:01 am

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

New member

Posts

Joined
Tue Mar 27, 2012 11:28 am
Who is online

Users browsing this forum: No registered users and 35 guests