[Rt-devel] RT design question

[Jesse Vincent]

> 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.
> 

--