[rt-users] RT Database Schema

Jim Mozley jim.mozley at exponential-e.com
Mon Feb 2 04:55:06 EST 2004


Michael Methe wrote:

> I must admit that I dont know a lot of MySQL databases and schemas.  Here is what I want to do.
> 
> I have created an ODBC connect to RT3 using MyODBC.  I want to build some reports.  I am using IMPROMPTU to generate these reports.  I need to know the relationships within the database though.  Is the schema for RT3 published?  Are the relationships forced within the MySQL database or programaticaly through RT?  Any info would really be appreciated!
> 

You might find this helps you reverse engineer the schema:

http://www.fabforce.net/dbdesigner4/

I've not used it for RT, but it has helped me document my own MySQL DB.

Jim



More information about the rt-users mailing list