Changes between Initial Version and Version 1 of UseCase16

Timestamp:

06/14/26 21:01:45 (5 days ago)

Author:

236021

Comment:

--

UseCase16

@@ +1 @@
+= UseCase16 - Lab Technician Login/Authentication =
+
+== Initiating Actor - `Lab Technician` ==
+
+== Description ==
+A lab technician logs into the Medora system using their username and password. The system verifies the credentials, checks the account is active, and grants access to the lab overview.
+
+== Scenario ==
+
+1. Lab technician navigates to the Medora login page.
+
+2. Lab technician enters their username and password and submits the login form.
+
+{{{
+#!sql
+SELECT
+  u.user_id,
+  u.username,
+  u.password,
+  u.role,
+  u.first_name,
+  u.last_name,
+  u.is_active
+FROM users u
+WHERE u.username = 'darko.milosev';
+}}}
+
+3. System verifies the account is active and the password matches.
+
+{{{
+#!sql
+SELECT u.user_id
+FROM users u
+WHERE u.username = 'darko.milosev'
+  AND u.is_active = TRUE;
+}}}
+
+4. System retrieves the linked lab technician profile.
+
+{{{
+#!sql
+SELECT
+  lt.technician_id,
+  lt.user_id,
+  lt.certification
+FROM lab_technician lt
+WHERE lt.user_id = (SELECT user_id FROM users WHERE username = 'darko.milosev');
+}}}
+
+5. Lab technician is authenticated and redirected to the lab dashboard.
+
+''(No database operation — session/token is application-level)''
+
+6. System displays all pending lab tests for the technician to process.
+
+{{{
+#!sql
+SELECT
+  plt.performed_test_id,
+  lt.test_name,
+  u_p.first_name AS patient_first_name,
+  u_p.last_name AS patient_last_name,
+  u_d.first_name AS doctor_first_name,
+  u_d.last_name AS doctor_last_name,
+  plt.test_date,
+  plt.notes
+FROM performed_lab_tests plt
+JOIN lab_tests lt ON plt.test_id = lt.test_id
+JOIN patients p ON plt.patient_id = p.patient_id
+JOIN users u_p ON p.patient_id = u_p.patient_id
+JOIN doctors d ON plt.doctor_id = d.doctor_id
+JOIN users u_d ON d.doctor_id = u_d.doctor_id
+ORDER BY plt.test_date;
+}}}