This is a much more practical answer. Point #1 seems exactly right.

Even without modern SQL arrays one could even keep references to place, per user, in a simple comma separated text field and munge it in code. Elegant? Probably not. But perhaps more practical then some of the approaches presented.

But modern SQL does have arrays.