Opening Hours table

Databases
1

I need a table of opening hours for each shops, here what I have come with:


CREATE TABLE `opening_hours` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `shop_id` int(11) DEFAULT NULL,
  `day_of_week` int(11) DEFAULT NULL,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  PRIMARY KEY (`id`)
) 



16:00 - 23:00 Monday
16:00 - 23:00 Tuesday
16:00 - 23:00 Wednesday
16:00 - 23:00 Thursday
16:00 - 23:59 Friday
16:00 - 23:59 Saturday
16:00 - 23:00 Sunday

Is that ok?

How would I select date and time from the frontend? Any idea

2

Is this the way you would like to output it?