On this case at the events table has a repeated schedule and scheduled by date
example case each of event schedule:
- The event has schedule every month, week and day with start and end of time
- The event has schedule every working days and working hours
- The event has date range schedule
- The event has a date for once converence
for following these problem, I’m so confusing to create the dynamic scheme for these condition
Table structure
events table column
- id PK
- title
- location
event_schedules
I create this scheme referenced from crontab scheduling where it can be create every year, month, week, day, or custom date. And the other condition I would to record event shedule with other option
- id PK
- event_id FK events_table_event_id
- year
- month
- week
- day
- custom_date
- start_time
- end_time
Question
What the best way to handle these data structure problem? I need some reference for taking these problem.