How to create the MySql DB schema for recurrent events

Question

I am very impressed with how the calendar works. I am currently creating an app to book classes at a CrossFit. and I am very interested in making use of the function of creating recurring events since classes are usually repeated every day with the same schedule. However, I am having problems visualizing how I should create the tables to save events and the recurring events... please, any help would be appreciated... what columns the table has and how many tables would be necessary to create, I'm a bit lost, so sorry.

Muthulakshmi Kalaiselvan · Answer

Hi,Thank you for contacting Syncfusion support. Based on the information provided we have analyzed your
requirement "How to create the MySQL database schema for recurrence
events in the calendar?". As of now, we don’t have any samples for the MySQL database. But we have already prepared samples related to the SQLite database for the calendar and firebase. Please find the following KB to SQLite database
and firebase,https://www.syncfusion.com/kb/12399/how-to-load-data-from-offline-sqlite-database-to-flutter-calendarhttps://www.syncfusion.com/kb/12616/how-to-add-the-appointments-to-firestore-database-using-flutter-calendarIn the meantime, we are working with the sample for the MySQL database for recurring events in the calendar. We will update you on the further
details on or before May 6, 2022. We appreciate your patience until then.Regards,Muthulakshmi

Jean Cuervo · Answer

Hi Muthulakshmi thanks for your quick answer!

Regarding the creation of recurring events, I understand that it would be the same but inserting a events as BULK or BATCH?

and one more question... is it possible to add events from the schedule view?

thanks one more time for your pacience and help!

Indumathi Ravichandran · Answer

Hi Jean,Regarding Query: Regarding the creation of recurring
events, I understand that it would be the same but inserting a events as BULK
or BATCH?We are unable to understand your requirement clearly and
your requirement is adding BULK or BATCH of events in Flutter Calendar or MySql
database. Can you please share your requirement clearly. It would be helpful
for us to analyze and provide you a solution at the earliest.Regarding Query: is it possible to add events from the
schedule view?Yes, you can add the events from the schedule view.We hope that this helps you. Please let us know if you
need further assistance.Regards,Indumathi R

Jean Cuervo · Answer

Sorry I may be the one that is confused I am kind of new.. my question is at the moment of create a recurrent event, lets say I want to create an event that will repeat all days for a whole month at 9am, how is this kind of events save them in the database? do I need to create 31 entries in the database with same information, do I need to add an extra column in the db table to identify is a recurrence event?

thanks for answer and really sorry to bother you

Indumathi Ravichandran · Answer

Hi Jean,Regarding Query: how is this kind of events save them in the
database? do I need to create 31 entries in the database with same information,No need to create 31 entries for recurrence appointments in the
database table. We have prepared the simple custom appointments sample for your
reference. Kindly create the table in the database with required fields for
appointments, for recurrence events kindly specify the recurrence rule in the appropriate
field and it automatically create UI with recurrence appointment in the Flutter
Calendar UI. Please find the sample from the following link.We have attached the reference image for adding the required
fields with value in Firebase database. In the same way you can add the fields
with values in MySql database.Sample link:https://www.syncfusion.com/downloads/support/directtrac/general/ze/flutter_customappointment-2102323283.zipWe hope that this helps you. Please let us know if you need
further assistance.Regards,Indumathi R