I need an idea on how to store some information in a database.
Let us assume that I want to build an application that allows a user to record what bars he visited each day.
The number of bars is variable, and a user typically visits more than one bar every day.
Now, my first idea is that I should build a comma-separated string out of the id's of each bar, and store it on a single column on a hypothetical table named barsVisited.
Is there perhaps some better way how to do this, or should I just proceed with this idea?
thank you in advance.