Hi,
Please bear with me.
I came across this nice tool to generate visual data models (using Graphvis) and other info:
http://schemaspy.sourceforge.net/
I ran it against drupal core data model and found the relationships.html file was not generated. I found the reason in this forum thread (lack of defined relations), but it also exposed a significant issue for drupal as it get relied upon for larger and more critical applications:
http://sourceforge.net/forum/forum.php?thread_id=1353114&forum_id=462850
The issue is about the relative merits of having data integrity in drupal managed by php code rather than by the rdbms. Does anyone have any thoughts to share on this? Has this been discussed in the past?
Thank you,
pacoit