Magento Forum

   
Page 1 of 4
Magento Database
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

Magento Database Diagram

- All file updates will be posted here (first post of the thread)

----------

Database Diagram Files for Magento v1.0 [2008-05-01]

* MAGENTO v1.0.19700 - Database Diagram.pdf
* MAGENTO v1.0.19700 - Database Diagram 3x3.pdf
* MAGENTO v1.0.19700 - Database Diagram 4x4.pdf
* MAGENTO v1.0.19700 - Database Diagram_BW.pdf
* MAGENTO v1.0.19700 - Database Objects.xls
* MAGENTO v1.0.19700 - Database Schema [SpacedFormat].sql

----------

Database Diagram Files for Magento v1.1.1, 1.1.2, 1.1.3, & 1.1.4 [2008-09-04]

* MAGENTO v1.1.1 - Database Diagram.pdf
* MAGENTO v1.1.1 - Database Schema.sql

----------

Database Diagram Files for Magento v1.1.5 & v1.1.6 [2008-09-17]

* MAGENTO_v1.1.6---Database_Diagram.pdf

----------

Database Diagram Files for Magento v1.1.7 & 1.1.8 [2008-12-13]

* MAGENTO_v1.1.8---Database_Diagram.pdf
* MAGENTO_v1.1.8---Database_Diagram_BW.pdf

----------

Database Diagram Files for Magento v1.2.0 [2009-01-17]

* MAGENTO_v1.2.0.2---Database_Diagram.pdf
* MAGENTO_v1.1.8 to v1.2.0.2---Change Summary.txt

----------

Database Diagram Files for Magento v1.2.1 (incl. 1.2.1.1 , & 1.2.1.2) [2009-02-03]

* MAGENTO_v1.2.1---Database_Diagram.pdf
* MAGENTO_v1.2.0.2 to 1.2.1---Change Summary.txt

----------

Database Diagram Files for Magento v1.3.2.3 & 1.3.2.4 [2009-10-03]

* MAGENTO_v1.3.2.4---Database_Diagram.pdf
(includes corrections to initial 1.3.2.3 release)

----------

Magento Database Wiki...
----------

Cheers,
G-

-------------------------------------------------------------
(Need a database diagram done? )

File Attachments
MAGENTO_v1.0.19700---Database Diagram.zip  (File Size: 599KB - Downloads: 16243)
MAGENTO_v1.1.1---Database_Diagram.zip  (File Size: 175KB - Downloads: 3757)
MAGENTO_v1.1.6---Database_Diagram.pdf  (File Size: 173KB - Downloads: 5406)
MAGENTO_v1.1.8---Database_Diagram.zip  (File Size: 303KB - Downloads: 2338)
MAGENTO_v1.2.0.2---Database_Diagram.zip  (File Size: 193KB - Downloads: 1650)
MAGENTO_v1.2.1---Database_Diagram.zip  (File Size: 193KB - Downloads: 5564)
MAGENTO_v1.3.2.4---Database_Diagram.pdf  (File Size: 126KB - Downloads: 37601)
 
Magento Community Magento Community
Magento Community
Magento Community
 
kalqlate
Jr. Member
 
Total Posts:  26
Joined:  2008-06-17
 

E X C E L L E N T ! ! !

Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

kalgate, glad you found the diagram useful - the feedback is appreciated.

 
Magento Community Magento Community
Magento Community
Magento Community
 
nicolas46
Sr. Member
 
Total Posts:  210
Joined:  2008-04-09
Toulouse
 

I seen the wiki page long time ago but i not see this topic before.  You’ve done a amazing job. Thanks a lot

 
Magento Community Magento Community
Magento Community
Magento Community
 
yaro
Jr. Member
 
Total Posts:  3
Joined:  2007-12-18
 

Excellent work!

May I ask for a diagram of Magento 1.1 in future?
Thanks a lot

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

No problem… Just waiting for the general release.  I have the 1.1 beta mapped so it should be available very shortly after the production release (or shortly after I know about the prod release).

 
Magento Community Magento Community
Magento Community
Magento Community
 
MmaxX
Sr. Member
 
Avatar
Total Posts:  112
Joined:  2008-04-01
 

Well done !
Can you say when you think release the 1.1 diagram ?

Thanks in advance.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lbourrel
Jr. Member
 
Avatar
Total Posts:  26
Joined:  2008-06-09
Ayaline - Poitiers
 

I’m impatient to have the 1.1 diagram LOL

You have done a great job, thanks.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

The DB diagram for 1.1.1 is now available - see first post of the thread to download the new zip file.  The “Magento Database” wiki page has also been updated with the file link.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lbourrel
Jr. Member
 
Avatar
Total Posts:  26
Joined:  2008-06-09
Ayaline - Poitiers
 

Hi ggoodwin,

Thanks for your post !

I Think that your link is ko in the wiki : it’s the same that the v1.0.

 
Magento Community Magento Community
Magento Community
Magento Community
 
lbourrel
Jr. Member
 
Avatar
Total Posts:  26
Joined:  2008-06-09
Ayaline - Poitiers
 

Ggoodwin,

May i ask what tools did you use for this reverse engineering ?

 
Magento Community Magento Community
Magento Community
Magento Community
 
nicolas46
Sr. Member
 
Total Posts:  210
Joined:  2008-04-09
Toulouse
 

Thanks a lot for this work

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

Laurent -

Thanks for the heads-up on the link issue - should be working now…
The tool I am using to reverse engineer and diagram the DB is Sybase PowerDesigner 12.5.

 
Magento Community Magento Community
Magento Community
Magento Community
 
ggoodwin
Member
 
Avatar
Total Posts:  38
Joined:  2008-02-19
Colorado - USA
 

Corrected legend for 1.1.1 diagram.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Jeremy Breece
Jr. Member
 
Total Posts:  2
Joined:  2008-07-16
Nashville, TN
 

Are there changes in the db for version 1.1.2? That is, is the 1.1.1 chart still accurate for version 1.1.2? In the release notes, I didn’t notice anything that wold necessitate db changes, but I haven’t downloaded the new version yet, either.

 
Magento Community Magento Community
Magento Community
Magento Community
 
Scott
Guru
 
Avatar
Total Posts:  333
Joined:  2007-08-31
Northwest Ohio
 

It appears to have not changed since 1.1.1, according to my file comparison.

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top
Page 1 of 4