Maybe I have thinking about it all wrong, maybe the database should store all the shift patterns for a year (365(6) * 3). For each shift pattern it could store which drivers are on duty. This information could be search to build up a list of shifts the driver is working. This could also speed up the search for who is available within a particular shift.
Date: 23/04/2008
ShiftNumber: 3
CommaSeparatedListOfDrivers: 24,01,06,22,14,15
Something like that would probably work. Otherwise I guess each driver would need to hold this information separately.
...?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment