How to design a class calendar?

Question

Database design

Good afternoon!
There is a calendar of this kind


. And the question is, how can you organize a database for this?
There are different types of classes, and I would like to set a specific date for each of them, but this may not be right, since there are one-time events, and conditional trainings are repeated every week for some time.
Also, each lesson still has a specific time

. And if with ready-made data I can figure out how to present them to the user, then there are no ideas at all about how to store them. I thought about a separate table for types of classes, and a separate table for each class (with a date), but again the question arises about the appropriateness of such a solution, since then a lot of data is obtained.
In any case, I will be glad for any help.

The database can be either MySql or MongoDb if that matters

. Any help would be appreciated anyway,
Thanks in advance

Answer 1

A table for the types of activities (if you need one): training, meeting, visit to the doctor, etc.
Table for specific classes - contains a link to the type of lesson and a specific date and time
Table for the schedule of recurring classes - contains a link to the type of lesson and schedule (every Monday, every third Wednesday, etc.)
According to the table with schedules + according to the table of specific classes and build this chart. As an option, according to the schedule table, records can be created in the table of specific classes - it is convenient to see that on Wednesdays you have a visit to your parents, and on Fridays - training (but this particular Friday - a date). But there are both pluses and minuses in creating specific recordings on a schedule.