By geshan on

Hello all,
I'm trying do draw the Entity Relationship (ER) diagram of primarily the 40 tables that get created when drupal is installed. The core tables have many primary key short names like nid which I assume means Node ID then what does uid, vid, tid etc stand for. I need help in drawing the ER-D of drupal 5.1 please help me. I googled for it but didn't get good results please help fast.

Geshan

⋅ Categories: Drupal 5.x

Comments

alldirt’s picture

alldirt commented

png 5.1-rc: http://drupal.org/node/38977
It could be that Ryan has more where this came from.

References in general: http://drupal.org/node/22754

fronbow’s picture

fronbow commented

Have you tried using phpMyAdmin?

If you enable the pmadb settings then you can set up all the relations for the tables, then view them as a pdf. (optionally including the data dictionary)

You'll need to have a look thru' the install files for phpMyAdmin, but it's all pretty straight forward....(create the pma tables, then put the settings in the config file, refresh phpMyAdmin if you're using it. job done!)

Have a look at this pdf as I've just done it as a test, if you need any help with setting this up let me know

cheers

geshan’s picture

geshan commented

Thanks to both of you, fronbow can you tell me more about pmadb. I think It'll be more helpful.
Geshan Manandhar

fronbow’s picture

fronbow commented

Hi Geshan,

did you have a look at the pdf?

First off you'll need to install phpmyadmin wherever you've got drupal installed. Then when you set up the tables for pma, phpMyAdmin gains more functionality.

So, you can define the relations from each table view, and then output the data dictionary and erd from phpMyAdmin.
It's great if you want to see how tables interact with each other, the only downside is that you have to manually go thru' each table to set up the relations. (But so long as the primary and other keys are set in the tables, it is pretty straight forward with a little knowledge of drupal...well, you don't really need to know about drupal)

You'll know you've said it up when in each table view you have a link called 'Relation View'.

Is there any way of contacting you cos I might be able to explain it better if we're in some kind of dialog?