This blog post could be helpful for those who seek a way to store and retrieve all appointments information like Resources, TimeMarkers, Categories. It also provides a handy way to handle recurrence exceptions without any additional code.
1. Database design (This step can be avoided if a DataModel is initially created and then a database is generated from it).
The key points that need to be taken into consideration when planning the database are:
- Where to save appointments
- Where to save recurrent appointments’ exceptions
- Where to save resources and how to relate them with appointments
Here is the database schema used in...