Joomla! Forum - community, help and support

I'm not sure whether this is the right forum to put this. If so pls feel free to remove it.

Is there a place where i can find a diagram of the Joomla Architecture. How the components & modules fit in to the core system.

For Joomla 1.0.x there's a Joomla Enhanced Entity Relationship Diagram (ERD) in PDF available at: http://help.joomla.org/content/view/1570/125/

thanks.
wel i went through it. Its the entitity relation diagram . But what i realy want is a diagram to which will show the modeling part. How different componets are fixed to the core library. A box diagram kind of thing.

pe7er wrote: For Joomla 1.0.x there's a Joomla Enhanced Entity Relationship Diagram (ERD) in PDF available at: http://help.joomla.org/content/view/1570/125/

When trying to download that link it ask me username and password , my joomla forum username and password is accept ,
pl give me link where i can download ER DIAGRAM or u have laster 1.5  E R Diagram , pl email me on
[email protected]
Thanks in Advance

PIYUSH PATEL

A case of link rot I think.  I think this is the file you are looking for: http://joomlacode.org/gf/project/joomla ... mbined.pdf

It is probably well out-of-date though.  As far as I know there isn't anything more recent.

Regards,
Chris.

The ERD and data flow diagram for joomla 1.0.x is at http://amiworks.co.in/talk/joomla-10x-how-it-works/ it based on the joomla version 1.0.11 so it is the most recent one i know

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.
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.

Great work

I can recommend moving from FabForce DB Designer to MySQL Workbench, for this kind of work!

nice work chris

i need the 1.6 ERD

Torkil, there's no difference between an INT and INT(11) or INT(10). For an INT the (X) is the width of the print column when you show results in the command line.

Yes, I've also noticed that the database works fine in spite of the inconsistencies. When trying to document it however, it poses some problems.

Stricter tools, like MySQL's own MySQL Workbench, will just wave big red flags in your face if you have an INT(3) that references a column that's an INT(10). Since I used MySQL Workbench to set up the schema, I had to manually change a lot of the column definitions merely to be allowed to set up the correct table relations.

My schema also goes a long way to try to illustrate table relations, while Joomla's MyISAM tables naturally do not have any table relations at all. I feel that without the table relations drawn in, then the schema would be a lot less helpful than with the imaginary relations drawn in, so that's why I've added them.

All of this and more is specified in detail in the explanation I wrote for the schema, in the blog post above.

If I could I would have written some patches to fix all these inconsistencies, but I don't have as much free time to put into the project anymore. Maybe if Joomla opened a permanent paid position as a database evangelist, then I could get hired and help out, but until then I'll have to leave this to others. It's a real shame.

The inconsistency tend to come from which tool is used to dump the DB, however, good schema tools should know an INT is an INT. If you are interested in database evangelism, I recommend to talk to Mitch Pirtle. He can probably give you a pointer or two.

I ♥ this thread... so much...

@Master Chief:

The INT column inconsistency is really the most insignificant of the issues mentioned, and so easy to remedy that it's weird you haven't fixed it yet. My blog post is 6 months old, but this stuff even dates well back to the Mambo days.

It also seems highly unlikely that a database tool should randomly alter the length on INT columns. The tool will just dump whatever schema the DB designer has set up.

Have you heard the saying "a fool with a tool is still just a fool". Fittingly enough, it's credited to Grady Booch, co-developer of the Unified Modeling Language.

But why did you decide to start discussing INT columns? And in this thread? A better place would be to comment on the blog post itself. Or, if you prefer staying in your home court, you could do it in this thread: http://forum.joomla.org/viewtopic.php?p=2319990

does anyone have the class diagram or some class diagram?

nice,
who can help me to find the DFD for joomla 1.5 or 1.6
thanks

Thanks @pe7er it will help a newbie like me to understand Joomla well