[drupal-devel] Database analysis of CivicSpace/Drupal

[Kieran Lal]

>>>> 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.

Cheers,
Kieran