Schedule for the week by the hour, how to store?

Question

Database design

Schedule

An example of an array in code with a schedule.

[
    'mo' => [0,1,5,6,7],
    'sa' => [5,6,7],
    'fr' => [0,1,7],
]

Sample database implementation


MariaDB server (middle).
The table data is updated only by the user, but there will be a lot of requests based on the schedule.

Will this implementation survive? Does it have problems? If there are other better implementations, please pin them. I will be grateful for help)

Answer 1

If it's just binary free/busy, you can store a whole day as a 24-bit mask, a single integer. Each bit means vacancy resp. hours.