Storing available dates of the week in MySQL

Question

I'm working on a booking application, and in the backend, the user will be able to specify which days of the week he wants his venue available on. For instance, he might choose only to make his venue available on friday and saturday.

My question is, how would I go about storing this data in the smartest way?

The first thing that comes to mind, is saving it on the venue's table, but that would as far as I can tell, mean storing it in a comma-seperated list, which is bad.

The other would be a table for available dates, containing the available day as an int (or is this wrong?) and a foreign key for the venue_id.

Answer 1

Don't use a comma delimited string. Create a second table called availableDates.

Use the venueId as a foreign key in the availableDates table.

As you say the availableDates table only needs to be 2 columns. One for the foreign key and one for the day which will be an int.