Post by chrisg42 » Wed Dec 07, 2011 8:58 am

I started using OpenCart about a month ago and I couldn't find any decent DB diagrams showing table associations so I decided to map the DB. Here are the diagrams for anyone that wants to use them.

http://www.colab-aktiv.com/?page_id=25

These diagrams are for OpenCart 1.5.1.3. I’ve broken them up into 7 different diagrams so its easier to view them on screen. All associations are shown including associations to tables on different diagrams.

User avatar
Newbie

Posts

Joined
Sun Oct 30, 2011 2:06 pm


Post by straightlight » Fri Dec 09, 2011 12:36 am

There's a typo on your demonstration from 1 field:

Code: Select all

attribue_description
it should rather read:

Code: Select all

attribute_description

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com Administrator / Quality Assurance Analyst / Programmer


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON

Post by chrisg42 » Fri Dec 09, 2011 5:55 am

@straightlight - Thanks, typo fixed

User avatar
Newbie

Posts

Joined
Sun Oct 30, 2011 2:06 pm


Post by straightlight » Sat Dec 10, 2011 1:13 am

@Chrisg42,

thanks for considering the fix above and also the time consuming you put to demonstrate a schematic presentation of the overall OpenCart database relationship entity. However, I would also like to suggest something that may be more appropriate for a team or a community to work on in case of any schematic changes in the future.

Right now, the pointed URL displays images for each schema and when a change would be required from the page, it may take longer to either apply the modifications on those tables and then to re-uploaded the updated screenshots on the page. That being said, for many years, I've been using this amazing tool:

http://ondras.zarovi.cz/sql/demo/

Which can also not only be demonstrated but: saved as SQL / XML (practical for those who uses VQMod), re-opened, queried and modified at any time in case of any changes that may need to be involved in the future. ;)

The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.


Regards,
Straightlight
Opencart.com Administrator / Quality Assurance Analyst / Programmer


Legendary Member

Posts

Joined
Mon Nov 14, 2011 11:38 pm
Location - Canada, ON
Who is online

Users browsing this forum: No registered users and 5 guests