The primary key of the table
Dienstplan
is
VK + Datum + Dienstbeginn
which is logical, because no one person can start working more than once at the same time. However, if on another branch the same employee is planned with the start of duty at the same time, it disappears from the first roster without warning.
Options:
Change the primary to VK + Datum + Dienstbeginn + Mandant
Test for this specific case before writing the data to the database and issue a warning/error to the user.
The primary key of the table
Dienstplan
isVK + Datum + Dienstbeginn
which is logical, because no one person can start working more than once at the same time. However, if on another branch the same employee is planned with the start of duty at the same time, it disappears from the first roster without warning.Options:
VK + Datum + Dienstbeginn + Mandant