Your shopping cart is empty. Browse our Store

Magento

Open Source eCommerce Evolved

Magento Database

Last modified by ggoodwin on Tue, May 13, 2008 20:28
Source|Old Revisions  

Magento Database Diagram 1.0 to 1.0.19870

Sample Magento Database Diagram sample database diagram

Full-size Magento database diagrams can be downloaded here.

Diagram Scope

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.

Diagram Format

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

Diagram Printing

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

Magento Database Downloads

Database Diagram Files for Magento v1.0, v1.0.19700, & v1.0.19870 — [Updated 2008_05_01]
MAGENTO_v1.0.19700---Database Diagram.zip
File Name File Description
MAGENTO v1.0.19700 - Database Diagram.pdfPDF DB Diagram - Color
MAGENTO v1.0.19700 - Database Diagram_BW.pdfPDF DB Diagram - Black&White
MAGENTO v1.0.19700 - Database Diagram 3×3.pdfPDF DB Diagram - 9 Page Fmt
MAGENTO v1.0.19700 - Database Diagram 4×4.pdfPDF DB Diagram - 16 Page Fmt
MAGENTO v1.0.19700 - Database Objects.xlsDatabase Object Spreadsheet
MAGENTO v1.0.19700 - Database Schema [SpacedFormat].sqlMagento Schema

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




 

Popular Wiki Tags  |  View all

Professional Services from the Magento Team

Professional Installation from the Magento Team

Magento Job Board - Some sort of tag line goes here

Latest Posts| View all Jobs
© Copyright 2008 Varien. Magento is a trademark of Irubin Consulting Inc. DBA Varien