I am creating a model of recurring events with exceptions.
Based on this question What's the best way to model recurring events in a calendar application?
Particularly the link in this question https://github.com/bmoeskau/Extensible/blob/master/recurrence-overview.md
This raises the question of how to implement the transfer of the event.
There are two ideas: to make a copy of the event that is transferred or create a table RescheduleEvent with fields from_date and to_date, which will refer to the Event table.
What is the best approach to implement? Or are there any other better approaches?