[rt-users] ERD (with relationships) for MySQL databases for versions 3.8.8 and 4.0.5 of RT?

[Thomas Sibley]

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.