Magento

sample database diagram

Full-size Magento database diagrams can be downloaded here.

Database diagrams and documents found on this page are intended to mirror the database schema as defined by Varien.

Table relationships depicted in a diagram represent only those relationships explicitly defined by Varien in the schema. Additional table relationships clearly exist and should be identified and considered when modifying the schema or directly manipulating data. The database is very consistent (kudos to Varian) making the task of identifying additional relationships relatively straight forward.

The database diagram is a searchable PDF document. Table and column objects can be located within a diagram using Acrobat’s search capabilities.

The database diagrams make extensive use of color. Consequently, a color printer is highly recommended.

Due to the overall size of the diagram, you will likely wish to print the document across multiple pages. The number of pages will depend on the level of detail required, the quality of your printer, and most importantly the quality of your eyes.

A guideline for setting the print scale:

To see text at the TABLE level requires 2×2 pages or greater (approx scale 45%)

To see text at the COLUMN level requires 4×4 pages or greater (approx scale 85%)

Printing across multiple pages(based on Acrobat 8.1 Pro - options may vary by version):

1. Open Acrobat print dialog
2. Select a printer
3. Locate the Page Scaling option and select “Tile all pages”
4. Locate the Tile Scale value and set your desired value (see above)
5. Locate the Overlap value and enter a value of 10 (optional)

You may wish to print the first page and verify you can see what you need to see before printing the entire document.

NOTE: Column level text will be larger in future versions

Post suggestions and correction requests here (Magento Database Forum)...