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!
Thanks in advance!
-Jeff
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.