Changes between Version 1 and Version 2 of UseCase06

Timestamp:

09/19/26 16:08:05 (3 days ago)

Author:

236021

Comment:

--

UseCase06

@@ -39 +39 @@
 {{{
 #!sql
-INSERT INTO performed_lab_tests (patient_id, doctor_id, test_id, test_date, notes)
+INSERT INTO performed_lab_tests (patient_id, doctor_id, technician_id, test_id, test_date, notes)
 VALUES (
   (SELECT patient_id FROM users WHERE username = 'maja.veljanova'),
   (SELECT doctor_id FROM users WHERE username = 'elena.kirova'),
+  (SELECT technician_id FROM lab_technician WHERE username = 'lab_marina'),
   (SELECT test_id FROM lab_tests WHERE test_name = 'Complete Blood Count'),
   '2026-06-05',