Drupal 6 Data Constructs and ERD

A few months ago I was looking at trying to develop an ERD (entity relationship diagram) for Drupal 6 to better enable people to understand the structure of the Drupal 6 database. However, as other things have got in the way (and the the migration was already completed sucessfully) it became a project on the back burner.

However, after a bit of searching I have found a few better examples of the Drupal 6 database system which may help out others when looking for data constructs within Drupal. I must stress this is only applicable to the core system within Drupal 6 and I have not looked at Drupal 5/Drupal 7 database, but I would assume it is slightly but not wholly different.

Basic Diagram with Table Names and Relationships:

Detailed Diagram:

Add comment

More information about text formats

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.