CODEWITHSUNDEEP
mysqldatabaseprestashop
Lexx Luxx
Lexx Luxx

Reputation: 274

Prestashop database Schema

is it possible to create a graphical representation of specific object in database Schema and all it relationships with all linked metadata, views, and stored procedures assocated with this object? Example: I want to define a logical relationships between “Data Sheet” tab on Prestashop product page and the rest elements in a database schema.

Upvotes: 2

Views: 6956

Answers (3)

Mike Kranzler
Mike Kranzler

Reputation: 192

Yes, you can find PrestaShop's new Physical Data Model here: http://www.prestashop.com/blog/en/a-new-physical-data-model-available-for-prestashop/

Upvotes: 2

Paul Campbell
Paul Campbell

Reputation: 1145

There is a MySQL workbench model in the dev directory of the Prestashop distribution (although the last one I looked out was out of sync with the actual release database schema, although that could have been a development release). I would make that my first point of call. Unfortunately it won't show up every relationship between tables though.

One of the quickest ways to do analysis is to take a snapshot of the database, insert a particular record (user, order, customer, data sheet etc.), take another snapshot, then diff them.

Upvotes: 0

Paul Sullivan
Paul Sullivan

Reputation: 2875

Yes (partially) - use the mysql workbench. It has reverse engineering db tools

see mysql dev wb link

This will generate diagram of the tables + relationships. Stored procedures, views, trigger etc are not going to be supported (too complex). You will just have to browse and reverse them yourself.

Upvotes: 3

Related Questions