Mysql Select Only Staff with Specified Number of Consecutive Free Time Slots

mysql,timeslots

Using a bit more data than you posted, I found a query that might do what you need. It does use the variables as you predicted :) but I hope it's pretty self-explanatory. Let's start with the table: CREATE TABLE a_free (`Staff_ID` int, `Avail_Slots_Datetime` datetime) ; INSERT INTO a_free (`Staff_ID`,...

Building an appointment booking system in Rails

ruby-on-rails,domain-model,appointment,timeslots

Look like a fun project. :) I would personally not model the "existing time", i.e I would not have a background job create "empty" data. I would try a model like this: Where the User table? I would not use a shared User model for the two different User types....