Entity Relationship Diagram for Joomla 1.5
Based on: Joomla 1.5.6.
Copyright (c) Jason A. Luttrell, 2008.
Also incorporates some elements from a diagram by Torkil Johnsen.REVISION HISTORY
04/30/2006, Torkil Johnsen - Created an ER diagram for Joomla 1.5
8/27/2008, Jason Luttrell - Created an Entity Relationship Diagram independently, but incorporated some concepts from Johnsen’s. Updated for Joomla 1.5.6.
Download the PDF file here. COPYRIGHT NOTICE
Since I was not a contributor in Joomla's development, and would not, therefore, understand all the decisions involved in the database's design, I suspect that there may be one or two mistakes in the schema that I developed. Thus, I compared mine with others, such as Torkil Johnsen’s. However, since it appears that there are no current schemas, I have made mine available here for public use and/or modifications, as long as you cite me as an author. Although I have decided to share this, it took awhile to create this version, so I would appreciate getting some credit for my work.
Please refer to the Creative Commons Attribution-Noncommercial-share Alike license:http://creativecommons.org/licenses/by-nc-sa/3.0/us/
You are free to share and make derivatives (i.e. corrections or updates), as long as you include the above Revision History, attribute the aforementioned contributors as authors, you do not use it for commercial purposes, and you freely share the document.HOW TO EDIT THE E.R. DIAGRAM
This ER Diagram was created using the free DBDesigner 4 (which is now replaced by MySQL Workbench 5.0), which can be downloaded from the fabFORCE.net Web site at... http://www.fabforce.net/dbdesigner4/
Under the Display sub-menu, I opted to turn on Crow's Foot notation, turn off Table Indices, and disable Relationship Names. I also had to adjust page setup so that the diagram would properly span six pages.
Download the MS Word documentation here.
Download the original DBDesigner 4 source file here.