RT Database Schema

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

Is the schema for RT3 published?

There is a dot graph in the docs directory of the distribution.

Are the relationships forced within the MySQL database or
programaticaly through RT?

Programatically.

Michael
Michael S. Liebman m-liebman@northwestern.edu
http://msl521.freeshell.org/
“I have vision and the rest of the world wears bifocals.”
-Paul Newman in “Butch Cassidy & the Sundance Kid”

Thanks… What is a .dot file? How is it best viewed?

Thanks a lot…

Mike MFrom: Michael S. Liebman [mailto:m-liebman@northwestern.edu]
Sent: Friday, January 30, 2004 10:06 AM
To: Michael Methe
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT Database Schema

Is the schema for RT3 published?

There is a dot graph in the docs directory of the distribution.

Are the relationships forced within the MySQL database or
programaticaly through RT?

Programatically.

Michael
Michael S. Liebman m-liebman@northwestern.edu
http://msl521.freeshell.org/
“I have vision and the rest of the world wears bifocals.”
-Paul Newman in “Butch Cassidy & the Sundance Kid”

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:

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@MIT.EDU]
Sent: Friday, January 30, 2004 10:39 AM
To: Michael Methe; rt-users@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@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

I posted an image of my attempt at a data model diagram
for the RT database at

http://web.mit.edu/sturner/www/rt/

Some of the relationships are missing - I wasn’t aware of
the dot diagram when I made mine. The image is large too -
haven’t figured out how to get Visio to produce a smaller
image yet.

I also took the liberty of posting a gif of the official RT dot diagram at
the same URL.

Steve

I posted an image of my attempt at a data model diagram
for the RT database at

http://web.mit.edu/sturner/www/rt/

Some of the relationships are missing - I wasn’t aware of
the dot diagram when I made mine. The image is large too -
haven’t figured out how to get Visio to produce a smaller
image yet.

I also took the liberty of posting a gif of the official RT dot diagram at
the same URL.

My own versions of these are at http://bestpractical.com/~jesse/schema/
Our equivalent to the visio isn’t as pretty :wink:

Steve


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

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

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

Would you consider including the pdfs in the RT docs on the web or in the
release?
There seems to be considerable interest in having a schema diagram available.

Thanks,
Steve

At 11:30 AM 1/30/2004 -0500, Jesse Vincent wrote:

Would you consider including the pdfs in the RT docs on the web or in the
release?
There seems to be considerable interest in having a schema diagram
available.

They’re supposed to be linked into the new RTFM instance (log into
rt3.fsck.com as guest/guest ) Ah. and in fact the dia-generated one is.

Thanks,
Steve

At 11:30 AM 1/30/2004 -0500, Jesse Vincent wrote:

My own versions of these are at http://bestpractical.com/~jesse/schema/


rt-users mailing list
rt-users@lists.bestpractical.com
The rt-users Archives

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

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

Thanks… What is a .dot file? How is it best viewed?

It’s a Graphviz directed graph. See

Michael
Michael S. Liebman m-liebman@northwestern.edu
http://msl521.freeshell.org/
“I have vision and the rest of the world wears bifocals.”
-Paul Newman in “Butch Cassidy & the Sundance Kid”

Jesse Vincent wrote:

I posted an image of my attempt at a data model diagram
for the RT database at

http://web.mit.edu/sturner/www/rt/

Some of the relationships are missing - I wasn’t aware of
the dot diagram when I made mine. The image is large too -
haven’t figured out how to get Visio to produce a smaller
image yet.

I also took the liberty of posting a gif of the official RT dot diagram at
the same URL.

My own versions of these are at http://bestpractical.com/~jesse/schema/
Our equivalent to the visio isn’t as pretty :wink:
http://bestpractical.com/~jesse/schema/03_schema_singleside.pdf
Has one error:
Tickets.Owner → Users.id not Principals.id as on scheme.
By fact it doesn’t matter, but by RT’s code it’s User.id.

	Best regards. Ruslan.

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:

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

Jim