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 phatbuck...@gmail.com
