Changes between Version 2 and Version 3 of UseCase16

Timestamp:

09/22/26 15:59:07 (21 hours ago)

Author:

236021

Comment:

--

UseCase16

@@ -23 +23 @@
   u.is_active
 FROM users u
-WHERE u.username = 'darko.milosev';
+WHERE u.username = 'lab_darko';
 }}}
 
@@ -32 +32 @@
 SELECT u.user_id
 FROM users u
-WHERE u.username = 'darko.milosev'
+WHERE u.username = 'lab_darko'
   AND u.is_active = TRUE;
 }}}
@@ -47 +47 @@
   lt.email
 FROM lab_technician lt
-JOIN users u ON u.lab_technician_id = lt.technician_id
-WHERE u.username = 'darko.milosev';
+JOIN users u ON u.user_id = lt.user_id
+WHERE u.username = 'lab_darko';
 }}}
 
 5. Lab technician is authenticated and redirected to the lab dashboard.
 
-''(No database operation — session/token is application-level)''
+''(No database operation as session/token is application-level)''
 
 6. System displays all pending lab tests for the technician to process.
@@ -71 +71 @@
 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 users u_p ON u_p.user_id = p.user_id
 JOIN doctors d ON plt.doctor_id = d.doctor_id
-JOIN users u_d ON d.doctor_id = u_d.doctor_id
+JOIN users u_d ON u_d.user_id = d.user_id
 ORDER BY plt.test_date;
 }}}