As a system user (nurse/doctor/pharmacist/lab technician), I want the system to automatically store the responsible clinical staff details in the t_visitdetails table when a patient visits the facility, so that all patient visit records capture the correct staff involved for accurate tracking, auditing, and continuity of care.

Acceptance Criteria

Store Nurse Details

• Given a patient visit is created
• When a nurse is assigned to the patient
• Then the system must store the nurse’s user ID in the t_visitdetails table.

Store Doctor Details

• Given a patient visit is created
• When a doctor is assigned to the patient
• Then the system must store the doctor’s user ID in the t_visitdetails table.

Store Pharmacist Details

• Given medications are dispensed or reviewed for the visit
• When a pharmacist is involved
• Then the system must store the pharmacist’s user ID in the t_visitdetails table.

Store Lab Technician Details

• Given lab tests are ordered during the visit
• When a lab technician processes the sample
• Then the system must store the lab technician’s user ID in the t_visitdetails table.