How to store work schedules of doctors in the database?

Question

Database design

Hello, I store work schedules in the database in one line. The table has fields:
Reception start date, Reception end date - Here I store the dates
Monday, Tuesday, Wednesday, Thursday, Friday and Saturday - Here I store the reception time by day of the week.
Charts can be created for 1-2-3 weeks, a month, several days.
How to properly organize the saving of graphs in the database?
Store charts by week, day or whole?
I can display charts for a month and a week, but I don’t know how to display charts for 2-3 weeks and cross charts (for example, from 11/30/2020 - 12/05/2020).
Tell me how to implement it?

Answer 1

It is better to store by day
availability_schedule
id - bigint (guid)
doc_id - int
base_date - date (perhaps it is worth inserting the base date, then start end will be just time)
start - datetime
end - datetime
doc_spec - int (doctor's main specialization)
Plus you do this scheme just requests and ready-made intervals are given to you.
You implement the breakdown by months and so on already in the application.