How to model Recurring events?

Hi -

I am about design a data model for a Calendar application. Here are some basic requirements:

1...In this application events (Appointments - like in Outlook) can be created. These events can be one time or they can be recurring. The recurrance can be finite or infinite. i.e an event can occur every Monday for current year OR an event can occur every day until end of time.

2...Also user should be able to manage (modify/delete) each occurance of a recurring event indivisually. The modification/updates to any particular occurance of an event must not affect other occurances.

My question would be what kind of tables/logic would be best to achive this functionality?

Any thoughts?

Thanks,

Satish Received on Wed Jun 13 2001 - 05:38:37 CEST