DBDesigner4 from fabFORCE.net, is a nice FREE tool for data modelling that I use for quite some time.

DBDesigner 4 compares to products like Oracle’s Designer©, IBM’s Rational Rose©, Computer Associates’s ERwin© and theKompany’s DataArchitect© but is an Open Source Project available for Microsoft Windows© 2k/XP and Linux KDE/Gnome. It is release on the GPL.

I like the reverse engineering features where we can see our existing databases design in clear picture.

 

 

 

 

 

 

For this test case, I’m going to reverse engineer wordpress database. So we can take a look what are tables involve in our lovely wordpress for all the while.

Create connection to wordpress database.

 

 

 

 

 

 

 

 

 

 

Connect to wordpress connection that we create previously.

 

 

 

 

 

 

Here you have an option so select tables individually or by schema.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Here you are.You can see how exactly wordpress table look like.

 

 

 

 

 

 

 

 

 

 

 

 

 

If you don’t have any modeling tools, I suggest you go and download for DBDesigner.