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


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


What the best way to handle these data structure problem? I need some reference for taking these problem.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.