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