I am creating two appointments systems and I can't seem to get a hang of one aspect for each.
if there are set times for appointments of 30 mins each, eg 0900, 0930 1230 1400, 1630, need I have a table that contains all possible appointment slots? Just seems a bit excessive when many of them won't actually be booked.
The second booking system has no set appointment times. You can 'book' for any time between 0930 and 1630 (except 1200 - 1300), and the only restriction is that no more than 50 people are 'in' at the same time.
If anyone can give me a nudge on either question, it would help me greatly.