[Rt-devel] RT design question

Jesse Vincent jesse at bestpractical.com
Mon Nov 22 12:14:00 EST 2004

> I mean for each ticket there are 4 groups, Owner, Requestor,
> Cc, AdminCc. Why not store them in the Tickets table?

Why store them in the tickets table, when you have SQL to join them. 
This isn't a case where breaking the data normalization rules will win
you anything.

> The only reason I can think of is that the recursive process
> of figuring out all members of a group is maybe easier if
> the top-level group is also in the Groups table.


More information about the Rt-devel mailing list