26 Apr
2005
26 Apr
'05
8:05 p.m.
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