Suppose I have records modeling users. Each user can be a member of
any number of groups (like how a unix user can be a member of any
number of groups). Whats the best way to implement this?
I think I would prefer if it was possible to have an enum field in the
user table which could store multiple values per record (one per
group) but the only practical way I can think to do it is to create
tables for each group and store the users primary key in the tables
corresponding to their group membership.
Following me? ...