[drupal-devel] Database analysis of CivicSpace/Drupal

Kieran Lal kieran at civicspacelabs.org
Tue Apr 26 18:05:58 UTC 2005

>>>> There are currently 107 database tables in the latest release of 
>>>> CivicSpace. I believe there are 55 in Drupal core.  One of the most
>>> As a partial step to documenting the database schema, I can create 
>>> an ERD and physical data diagram if I can get the list of table 
>>> joins which imply an application level relationship.  I would be 
>>> interested in doing this for Drupal first, and if it's easy enough, 
>>> I could do CivicSpace, too.

I was speaking to a db pro off line and was told that we should also be 
careful to make sure that JOINs on fields have the same data type.  
It's possible to compare a number to a character field or two types of 
numbers, i.e. long vs. short.


More information about the drupal-devel mailing list