The events would still need to be tied to a date though.
I am not sure how to model this data exactly but I would approach it as event 1->N date property. Then you would calculate your date ranges for each date property once and connect events to dates. I am assuming some sort of relational db. Date:Manip is slower than some of the other options. But it is super powerful. | [reply] |
Well, you either need to store the definition for the event or the complete list of events. Storing the definition and expanding it to the full list when needed keeps the database of events simple and easy to work on. On the other hand, it's probably going to be pretty slow when you need to go through the list and calculate if each event matches a given day. The opposite is true of storing an expanded list of dates for each event. It's a trade like everything else. | [reply] |