<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=931320416-30012004><FONT face=Arial color=#0000ff
size=2>Thanks, if you can send it seperately or to this list, I would really
appreciate it.</FONT></SPAN></DIV>
<DIV><SPAN class=931320416-30012004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=931320416-30012004><FONT face=Arial color=#0000ff
size=2>Thanks</FONT></SPAN></DIV>
<DIV><SPAN class=931320416-30012004><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=931320416-30012004><FONT face=Arial color=#0000ff
size=2>mwm</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Stephen Turner
[mailto:sturner@MIT.EDU]<BR><B>Sent:</B> Friday, January 30, 2004 10:39
AM<BR><B>To:</B> Michael Methe;
rt-users@lists.bestpractical.com<BR><B>Subject:</B> Re: [rt-users] RT Database
Schema<BR><BR></FONT></DIV><FONT size=3>Michael,<BR><BR>I have a data model
diagram of the RT database I can share with you.<BR>It seems largely correct,
but some of the relationships may not be <BR>accurate.<BR><BR>I have it in
Visio - I will send you an image of it separately. If someone<BR>can tell me
if it's OK to send binaries to the mailing list I will send it
here<BR>too.<BR><BR>Steve<BR><BR>At 09:14 AM 1/30/2004 -0500, Michael Methe
wrote:<BR>
<BLOCKQUOTE class=cite cite="" type="cite">I must admit that I dont know a
lot of MySQL databases and schemas. Here is what I want to
do.<BR><BR>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!<BR><BR>Thanks<BR><BR>mwm<BR>_______________________________________________<BR>rt-users
mailing list<BR>rt-users@lists.bestpractical.com<BR><A
href="http://lists.bestpractical.com/mailman/listinfo/rt-users"
eudora="autourl">http://lists.bestpractical.com/mailman/listinfo/rt-users</A><BR><BR>Have
you read the FAQ? The RT FAQ Manager lives at <A href="http://fsck.com/rtfm"
eudora="autourl">http://fsck.com/rtfm</A>
</FONT></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>