Changes between Version 1 and Version 2 of UseCase12

Timestamp:

09/22/26 15:44:38 (21 hours ago)

Author:

236021

Comment:

--

UseCase12

@@ -17 +17 @@
 FROM medical_records mr
 WHERE mr.patient_id = (
-  SELECT patient_id FROM users WHERE username = 'maja.veljanova'
+    SELECT p.patient_id
+    FROM patients p
+    JOIN users u ON u.user_id = p.user_id
+    WHERE u.username = '1402994123456'
 );
 }}}
@@ -25 +28 @@
 {{{
 #!sql
-INSERT INTO medical_report (record_id, doctor_id, description, report_date)
+INSERT INTO medical_report (report_id, record_id, doctor_id, description, report_date)
 VALUES (
-  (SELECT record_id FROM medical_records WHERE patient_id = (SELECT patient_id FROM users WHERE username = 'maja.veljanova')),
-  (SELECT doctor_id FROM users WHERE username = 'elena.kirova'),
+  (SELECT COALESCE(MAX(report_id), 0) + 1 FROM medical_report),
+  (SELECT mr.record_id
+   FROM medical_records mr
+   JOIN patients p ON mr.patient_id = p.patient_id
+   JOIN users u ON u.user_id = p.user_id
+   WHERE u.username = '1402994123456'),
+  (SELECT d.doctor_id
+   FROM doctors d
+   JOIN users u ON u.user_id = d.user_id
+   WHERE u.username = 'elena.kirova@medora.com'),
   'Patient presents with hypertension. Recent ECG shows normal sinus rhythm.',
   '2026-05-30'
@@ -47 +58 @@
 FROM medical_report mr
 JOIN doctors d ON mr.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
 WHERE mr.report_id = (
-SELECT MAX(report_id) 
-FROM medical_report);
+    SELECT MAX(report_id)
+    FROM medical_report
+);
 }}}