problem of correspondence between scheduled shifts and actual shifts
-1
votes
1
answer
33
views
The
employee
has a strong key.
On the one hand I record the shift calendar of each employee (shift calendar
) and on the other hand I record the shifts that were actually carried out by the employee.
Now if employee "X" has two shifts, one on Monday morning and the other on Tuesday morning, and let's assume that he arrives on Monday evening. When he arrives, is he referring to the Monday morning shift where he arrived late or the Tuesday morning shift where he arrived anticipated?
There is no correspondence between the scheduled shifts and the shifts carried out
How can I add a match without creating redundancy?

Asked by Domenico Lugubre
(1 rep)
May 10, 2024, 04:22 PM
Last activity: May 10, 2024, 08:24 PM
Last activity: May 10, 2024, 08:24 PM