I am trying to create a calendar application that can support multiple calendars, for instance Indian, Nepali, Russian etc. Users can enable or disable the calendars according to their needs.
I have an idea in mind to make the English calendar as a base and create a mapping table for additional calendars. But I am not quite sure what is the efficient way to design database schema. Can you provide me the best way for designing the relevant database schema?
Since each calendar has different national holidays as well I want to support for it as well.
My work so far
My entity-relationship diagram so far:
base_calendar: Stores the English date
additional_calendar: English equivalent date (for example in BS)