Re: Organisational question: surely someone has implemented many Boolean values (tags) and a solution exist

On Thu, Jan 20, 2011 at 17:00, Richard Quadling <rquadling@gmail.com> wrote: > I'd have my items table, my tags table and a join table for the two. > My join table is really simple. UniqueID, ItemID, TagID. > Yes, that is the first approach that I mentioned. It looks to be a good compromise. > I'd recommend using a nested set approach for the tags > (http://dev.mysql.com/tech-resources/articles/hierarchical-data.html > gives a good explanation on the issues and methodology of nested > sets). > That is terrific, at least the first half. The second half, with the Venn diagrams, is awkward! -- Dotan Cohen http://gibberish.co.il http://what-is-what.com