[rt-users] RT Database Schema

[Stephen Turner]

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/0a972177/attachment.htm>