Hello Everyone! I'm working on a multi-store system and I would need to store efficently working days and working hours (aka schedule).

For days i've it figured. I store a int for Opening Days and made constants for everyday and use bitwise operator, so I can use

if (OpeningDays & MONDAY) return true

I also want to store in the database the opening hours, the way I figured was another table like

OpeningHours
id | shop_id | day | from  | to
 1 |    1    |  1  | 10:30 | 14:30 // Monday

BUT, I think this is owful for query performance, because for each store that opens every day I have a minimum of 7 registers in the OpeningHours table, OR more (double) if they have more than one in the same day, like 10:30 to 14:30 and 19:00 to 23:00.

So I'm trying to figure the most efficient way to storing opening hours for each store.

Thank you!!