The Joomla! Forum ™





Post new topic Reply to topic  [ 15 posts ] 
Author Message
PostPosted: Mon Sep 19, 2005 11:59 am 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Thu Sep 08, 2005 9:03 am
Posts: 56
;D

I'm doing something I hope will be of value to the Joomla community, whether you're working on the core, plugins, or you are a site developer.  My contribution is a Joomla Entity Relationship Diagram (ERD).

I've reversed the Joomla 1.0 database into an ERD tool.  Unfortunately it can't infer relationships, so I'm going through putting those back together, and documenting the ERD. The diagrams use IE notation.

I like to include data from any "lookup" tables, as well as sample data, whenever it really seems to help explain what the table is designed to do.  I'm also including notes about things I am unsure of.

I am breaking this up into subject area pieces.  I may be able to provide a complete diagram once I'm finished, but I also find it beneficial to have smaller subject areas.

First off, please understand I'm relatively new to Joomla.  If I'm getting anything wrong, don't hesitate to let me know.
When the diagram is complete I'll look at rendering it to a pdf to make it easier for people to print. 

I hope these diagrams will be useful to the Joomla community now and in the future.

*Latest*
We're in the process of integrating this into the developers manual.  I've created a single pdf with all the views, which prints out nicely on 8.5x11 paper.  Until the file is available from the manual, you can get it here: 

Combined ERD


Last edited by gizmola on Wed Nov 16, 2005 2:39 pm, edited 1 time in total.

Top
 Profile  
 
PostPosted: Mon Sep 19, 2005 12:07 pm 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Mon Sep 05, 2005 6:18 am
Posts: 750
Location: India
Man wow these are better than the diagrams generated by the dev team given in the documentation .....hope the core team notices ...... should be darn helpful

_________________
A. N. Jacob-New
The Tech & Design Blog http://www.Clazh.com


Top
 Profile  
 
PostPosted: Mon Sep 19, 2005 12:14 pm 
Joomla! Guru
Joomla! Guru

Joined: Sat Sep 10, 2005 10:31 pm
Posts: 842
gizmola wrote:


Interesting project.

My comment on the userview: I would concentrate more on the ACL-Stuff, since that is gonna replace the jos_usertypes and jos_groups-tables finally.

_________________
We may not be able to control the wind, but we can always adjust our sails


Top
 Profile  
 
PostPosted: Tue Sep 20, 2005 10:49 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Thu Sep 08, 2005 9:03 am
Posts: 56
I've just updated the Users view, and believe it to be correct. I'd appreciate it if people familiar with the user system could look it over and check it for accuracy.

http://www.gizmola.com/blog/uploads/ima ... _users.jpg


Top
 Profile  
 
PostPosted: Wed Sep 21, 2005 7:02 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Thu Sep 08, 2005 9:03 am
Posts: 56
Ok, the Joomla Base ERD is complete.  If I find any issues, or learn anything new that requires me to change any of these, I'll update them and leave a message here.  Hope they're of help.


Top
 Profile  
 
PostPosted: Tue Oct 04, 2005 4:10 am 
User avatar
Joomla! Guru
Joomla! Guru

Joined: Tue Aug 23, 2005 9:45 am
Posts: 687
Location: La Grande, Oregon
Thanks Gizmola.

Great contribution.  You should tell someone from the developer docs and see if they can make this a sticky or incorporate it somewhere so it doesn't get buried.

Charles

_________________
From the beginning...


Top
 Profile  
 
PostPosted: Tue Oct 04, 2005 5:15 am 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Thu Sep 08, 2005 9:03 am
Posts: 56
Thanks for the vote of confidence. I have joined the developer documentation team, and we're working on getting the diagrams into the developer documentation area.


Top
 Profile  
 
PostPosted: Wed Oct 05, 2005 3:09 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Aug 20, 2005 5:42 am
Posts: 10
Im in for translations to spanish and any documentation that needs to be done. Just let me know.


Top
 Profile  
 
PostPosted: Mon Oct 17, 2005 10:19 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Oct 17, 2005 10:08 am
Posts: 1
Hi everybody,
I saw the ERD diagram of the users relationships and I have a question about the relation between the
jos_usertypes table with the jos_users table.
In fact, observing the database, the field jos_users.usertypes seems to be related to the jos_core_acl_aro_groups table
and not to the jos_usertypes table.
If this is true,  which is the role of the jos_usertypes table ?

Thanks
Matteo


Top
 Profile  
 
PostPosted: Mon Oct 17, 2005 11:55 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Thu Sep 08, 2005 9:03 am
Posts: 56
Thanks for bringing this question up.

I've dug into the code, and restructured the diagrams a bit now that I've seen what's been going on.  From searching the codebase, _usertypes is not used.  The values in the usertype.name column seem to vaguely correspond to values both in the core_acl_aro_groups.name column and in the user.usertype column, although there isn't really any match.  When I searched the code for .usertype, I only found it being compared to some hardwired constants. 

I did however, discover that jos_groups is only used as a way of constraining the content table, and also found that core_acl_aro_groups is related to users.  This has helped improve that section of the model considerably.

I'm regenerating that view, and will have a replacement uploaded shortly.  I've also noted that the usertypes table doesn't seem to be used.


Top
 Profile  
 
PostPosted: Tue Oct 18, 2005 12:13 am 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Thu Sep 08, 2005 9:03 am
Posts: 56
User View and Content View have been updated, reflecting corrections regarding _groups and _usertypes tables.  Now correctly links _users to core_acl_aro_groups table.


Top
 Profile  
 
PostPosted: Thu Oct 20, 2005 2:02 am 
User avatar
Joomla! Virtuoso
Joomla! Virtuoso

Joined: Thu Aug 18, 2005 10:27 am
Posts: 4180
Location: Sunny City Cebu, Philippines!
wow! big thanks mate!

_________________
"I was one of those who wondered why people would pay so much $$$$ to do something that was so much fun!" -R. Harkrider, Fortran Code Engr.

http://www.joomlaconsultancy.net


Top
 Profile  
 
PostPosted: Wed Nov 16, 2005 1:55 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Mon Oct 31, 2005 3:04 pm
Posts: 6
Location: Pinneberg
tks gizmola for this helpful piece of information...  8)

_________________
det som göms i snö kommer upp i tö


Top
 Profile  
 
PostPosted: Wed Nov 16, 2005 2:41 pm 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Thu Sep 08, 2005 9:03 am
Posts: 56
Views now are integrated into a single pdf.


Top
 Profile  
 
PostPosted: Fri Oct 27, 2006 1:24 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Fri Oct 13, 2006 12:17 pm
Posts: 3
Hello anybody, I find this scheme very usefull but  I'm just searching something a bit different... I mean that I need the e/r scheme for the joomla db, could anyone help me?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 15 posts ] 



Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group