I am trying to make a scheduling app. For a company that requires 2 people per ambulance for a 24 hour period. Most locations have 1 ambulance, 1 has 2 ambulances and 1 has 3 ambulances. 1 location has 1 person and is scheduled separately but daily.
Tables:
-Employees
-Stations including required daily staffing
-Shifts
-Schedule
I want to differentiate schedule and active because people call off, trade, rotate, etc. The โScheduleโ is all the shifts I query from, unless I am doing too much by adding the active schedule.
Is there a question you need help with?
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |