I'm doing an online booking system for B&B accomdation.
Originally they just had a start date and end date for which days of the year they are open.
They now want to incorporate extra dates they may be open or closed - i.e. multiple open and close dates.
Could someone give me ideas on how to build this into the database schema? How can I build checks to see if a booking is possible for certain dates?
Any hints, links to tutorials etc would be appreciated
Thanks
Originally they just had a start date and end date for which days of the year they are open.
They now want to incorporate extra dates they may be open or closed - i.e. multiple open and close dates.
Could someone give me ideas on how to build this into the database schema? How can I build checks to see if a booking is possible for certain dates?
Any hints, links to tutorials etc would be appreciated
Thanks