[development] EER Diagram for MySQL

[Angela Byron]

Brett Stoppel wrote:
> Hi All.
> 
> I am in the process of creating an EER Diagram for Drupal with MySQL 
> Workbench. I have a good start on it, but thought I would ask if one 
> already exists? I find them really helpful for learning the database 
> side of applications. If one doesn't exists, is this the right place to 
> ask questions about the design of the DB? For instance, I am not sure if 
> the column "aid" in Access, Actions, Actions_id, Authmap are primary 
> keys or if they are foreign keys. I would love to get a little more done 
> on the diagram and then upload it for you all to review and make 
> suggestions.

If you open up the module' .install files, or use the Schema module, 
there is already copious documentation on every single field in D6's 
schema. Foreign keys are documented with a particular syntax (I think 
it's {node}.nid but I forget). It'd be neat if you could somehow script 
it somehow so this could be automatically generated from one Drupal 
version to another, and for contributed modules as well.

-Angie, who lost 2 months of her life documenting these fields. ;)