[rt-users] RT Database Schema

[Michael Methe]

Thanks, if you can send it seperately or to this list, I would really appreciate it.
 
Thanks
 
mwm

-----Original Message-----
From: Stephen Turner [mailto:sturner at MIT.EDU]
Sent: Friday, January 30, 2004 10:39 AM
To: Michael Methe; rt-users at lists.bestpractical.com
Subject: Re: [rt-users] RT Database Schema


Michael,

I have a data model diagram of the RT database I can share with you.
It seems largely correct, but some of the relationships may not be 
accurate.

I have it in Visio - I will send you an image of it separately. If someone
can tell me if it's OK to send binaries to the mailing list I will send it here
too.

Steve

At 09:14 AM 1/30/2004 -0500, 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!

Thanks

mwm
_______________________________________________
rt-users mailing list
rt-users at lists.bestpractical.com
http://lists.bestpractical.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20040130/b1c9fc46/attachment.htm>