Hour Database Adalo

@CNST I would not go for a big prepared calendar you have to maintain regularly.

  1. Each company should have a pattern of working hours/shifts based on weekdays.
    For work with weekdays see: How to derive weekdays from a date - #2 by Ben
  2. Each company has a holiday calendar (public holidays etc.).
  3. During the operating hours (standard working days and opening hours except holidays) a company has one or many shifts. (=> Closed during lunch break)
  4. Each shift has one or many employees assigned.
  5. A shift can have multiple slots/session to be booked.
  6. A customer can book a session in a certain time slot with an available employee.
2 Likes