What database structure is better to choose for creating a tour schedule?

Question

MySQL

It is necessary to create a database where you can add a tour where 1) Each tour can be on a specific schedule of the days of the week 2) It can be a certain number 3) You can make exception days 4) You can choose an interval, for example, in a week (one, two) or a month or a year where Every New Year or New Day there will be a guided tour.
Who thinks what's best?

Answer 1

table 1 - description of the tour
table 2 - date of the tour, id of the tour
in the second table you implement the schedule, and the first one is essentially a guide with a description of the tour