How do I set up an SQL table to save week days and time in each event record

Question

I'm looking for the efficient way to store week days and times of each event. How do I achieve the following result

Events table

id	name	dates	rel_id
1	hello world	Su 14:56:59, Mo 14:56:59, We 14:56:59, Th 14:56:59, Fr 14:56:59, Sa 14:56:59	1

Update

Is it correct to use an enum list like sa','su','mo','tu','we','th','fr' and then add a record for each day, so each rel_id will have 7 records!

Answer 1

To be honest, store every event by itself.
The reason

1. Su 14:56:59 - this can be any Sunday out of 52 Sundays a year - not very efficient from my point of view
2. If you ever need a report of some sort, you would spend more time extracting dates from a string compared to just read the DB table rows