Hello,

I am attempting to create a database for a charity organisation, the database will hold information about there volunteers, roles, languages, building, and shifts.

One of the main problems I have at the moment is how would I cater for the shifts.


Open Sunday - Monday
6 Shifts at present
different days are open for different shifts


Any help pointers greatly appriciated.

This is what I have so far.

Shift
id
day
stime
etime

I also would need to allow a change for certain periods, example a couple of days over Christmas the shift patterns change.