php - Database Design: schedules, including recurrence - Stack Overflow
As I write this, there are no answers, but I want to predict that it will be decided that the asker should use a database of events with a scheduled (datetime) field, a rec_end (datetime) field and a rec_days (string) field. The rec_days would have the first 3 characters of the days of reoccurence separated by commas, and the string would be exploded at the ',' to read them. So a task that repeats MON,WED,FRI, if the next MON reoccurence was after the rec_end datetime, it won't reoccur after the FRI.
No comments:
Post a Comment