How to organize the operating mode of the institution in the database?

Question

MySQL

Good afternoon!
How to properly organize the operation mode of the institution in the database?
It will be output in this format:

Понедельник: 09:00—20:00
Вторник: 09:00—20:00
Среда: 09:00—20:00
Четверг: 09:00—20:00
Пятница: 09:00—20:00
Суббота: 09:00—20:00
Воскресенье: Круглосуточно

There will be many establishments, and all will have different opening hours.

Answer 1

For example, like this:

`organization_id` INT,
`weekdays` SET(1,2,3,4,5,6,7),
`date` DATE,
`from` TIME,
`to` TIME

A date field to organize exceptions, such as on holidays.