[drupal-devel] Database analysis of CivicSpace/Drupal
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