ER diagram

Hey guys, I have to make an ER diagram for my Modx site, I have to come up with some examples of the different relations like 1:n , 1:1 , n:m …. Problem is I don’t understand how the tables work in Modx, and I’m new to databases in general. Can someone please give me an example of these relations between Modx tables? Would help me a lot.

So far this is what i got....

(web_users)  1 <-----> n (web_user_attributes)

(web_users) m <-----> n (web_groups)

Thanks a bunch!!!

Well, I need the same diagram. Any help please?

Thanks.

There are some tools out that can build this from a database...maybe MySQL workbench:
http://dev.mysql.com/workbench/

I’m definitely going to have to get a new computer. This is the second piece of software I really wanted that only runs on Intel

Quote from: dev_cw at Jul 07, 2009, 11:39 AM

There are some tools out that can build this from a database...maybe MySQL workbench:
http://dev.mysql.com/workbench/

Thanks!

SQLEditor is a lightweight alternative to MySQL’s Workbench that works with more database types, and IMO is easier to use and produces slightly better diagrams. Eg, the FK realtionships map to the actual columns. It’s not free but you can use the beta:

http://www.malcolmhardie.com/sqleditor/