[rt-users] RT Database Schema

[Ruslan U. Zakirov]

Jesse Vincent wrote:
> 
> 
> On Fri, Jan 30, 2004 at 11:13:43AM -0500, Stephen Turner 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 ;)
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.

> 
> 
>>Steve
>>
>>_______________________________________________
>>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
>>
> 
>