[rt-users] RT database table relations

[Darren Spruell]

Greetings,

I was exploring some integration with the RT database from an external
web framework and realized that there don't seem to be any key
relations established between tables I'm looking at in the DB. Is this
purposeful or something that just never made it in?

E.g.

tickets.queue as foreign key to queues.id
tickets.owner as foreign key to users.id
(etc.)

Everything works fine without this of course; I'm just thinking that
certain queries are likely to be simpler in some use cases.

Would utilizing key relations be generally beneficial (referential
integrity/etc.) or harmful in the ~current RT DB design?

RT 3.8.8 with Postgresql 8.4.4.

-- 
Darren Spruell
phatbuckett at gmail.com