On 03/20/2012 12:28 PM, Jeff Lucas wrote: > Hello folks. > Does anybody have an ERD (with relationships) for the databases for > version 3.8.8 and 4.0.5 of RT? I tried to create one with MySQL > Workbench but all I can get is primary keys, are there any foreign keys > or are the relationships defined anywhere? If it includes Asset > Tracker, that would be a bonus!
FK relationships aren't enforced at the database level. Refer to http://requesttracker.wikia.com/wiki/DBSchema for a start. There is a relationship diagram that ships with RT, which is rendered on the wiki.
