how can they then be removed from the database?
Most things in the database are linked to users, whether it be physicians or MAs or receptionists. Say an MA gives a vaccine and records it, that is entered into SQL in several places, but the main columns will be Last Touched By and the MAs name. That immunization is forever tied to the MA.
Also, if a physician quits and you delete his account, if he comes back where are you going to put him? If you put him in under a different name, now you have two sets of data linked to the same person.
Is it the schedule that bothers you the most?
