By bg1 on
I am a database developer (i.e. my primary programming language is SQL). I find it mush easier to understand an application (or framework) by looking at its database schema than by reading prose or program code.
Where can I find the database schema for Drupal core or is there a tool that will display/print the schema from MySQL?
Thanks.
Comments
Yes
Yes.
What does "yes" mean?
I don't understand your answer. It jsut takes me to a google page that searches for key words "Drupal" and "Schema".
I am looking for a diagram of the database for the core of Drupal 7 and not a module for being able to integrate other database structures into Drupal.
Am I missing something? Will the schema module let me print a schema diagram of the Drupal core database?
Insulting
I too am looking for a diagram of the basic drupal database such as where it stores the nodes and file names for images. This comment is insulting and incorrect since the google search brings up the schema api module which just lists the table as an array, not a diagram showing the relationship between tables. People have been known to search google before posting.
A helpful link...
I found this was the top Google link when I searched "drupal core schema" so I figured it'd be helpful to put the actual answer here.
This article http://drupal.org/node/184586 was quite helpful.
Here's a nice image of the schema:
http://www.typo.co.il/~mooffie/tmp/schemagraph/output/schemagraph-2007-1...
Enjoy...
Is there one for Drupal 7?
Has anyone made a more recent schema?
Here is a schema diagram for
Here is a schema diagram for Drupal 7