Changes between Version 1 and Version 2 of UseCase07

Timestamp:

09/22/26 14:52:57 (22 hours ago)

Author:

236021

Comment:

--

UseCase07

@@ -24 +24 @@
 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;
 }}}
 
@@ -40 +40 @@
 FROM lab_tests lt
 WHERE lt.test_id = (
-SELECT test_id 
-FROM performed_lab_tests 
-WHERE performed_test_id = 1);
+    SELECT test_id
+    FROM performed_lab_tests
+    WHERE performed_test_id = 1
+);
 }}}
 
@@ -49 +50 @@
 {{{
 #!sql
-INSERT INTO lab_results (test_id, results, result_date)
+INSERT INTO lab_results (result_id, test_id, results, result_date)
 VALUES (
+  (SELECT COALESCE(MAX(result_id), 0) + 1 FROM lab_results),
   (SELECT test_id FROM performed_lab_tests WHERE performed_test_id = 1),
   'Blood pressure: 145/90, Glucose: 105 mg/dL',
@@ -85 +87 @@
   SELECT record_id FROM medical_records
   WHERE patient_id = (
-SELECT patient_id 
-FROM performed_lab_tests 
-WHERE performed_test_id = 1)
+    SELECT patient_id
+    FROM performed_lab_tests
+    WHERE performed_test_id = 1
+  )
 );
 }}}