Changes between Version 1 and Version 2 of UseCase14

Timestamp:

09/22/26 15:51:31 (12 hours ago)

Author:

236021

Comment:

--

UseCase14

@@ -21 +21 @@
 JOIN allergies a ON mra.allergy_id = a.allergy_id
 WHERE mra.record_id = (
-  SELECT record_id FROM medical_records
-  WHERE patient_id = (
-SELECT patient_id 
-FROM users 
-WHERE username = 'maja.veljanova')
+    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'
 );
 }}}
@@ -50 +50 @@
 FROM medical_record_allergies mra
 WHERE mra.record_id = (
-  SELECT record_id FROM medical_records
-  WHERE patient_id = (SELECT patient_id FROM users WHERE username = 'maja.veljanova')
+    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'
 )
-  AND mra.allergy_id = (SELECT allergy_id FROM allergies WHERE name = 'Penicillin');
+  AND mra.allergy_id = (SELECT allergy_id FROM allergies WHERE name = 'IBUPROFEN');
 }}}
 
@@ -62 +65 @@
 INSERT INTO medical_record_allergies (record_id, allergy_id, reaction, severity)
 VALUES (
-  (SELECT record_id FROM medical_records WHERE patient_id = (SELECT patient_id FROM users WHERE username = 'maja.veljanova')),
-  (SELECT allergy_id FROM allergies WHERE name = 'Penicillin'),
-  'Rash and swelling',
+  (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 allergy_id FROM allergies WHERE name = 'IBUPROFEN'),
+  'Stomach upset and mild hives',
   'MODERATE'
 );
@@ -82 +89 @@
 JOIN allergies a ON mra.allergy_id = a.allergy_id
 WHERE mra.record_id = (
-  SELECT record_id FROM medical_records
-  WHERE patient_id = (SELECT patient_id FROM users WHERE username = 'maja.veljanova')
+    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'
 );
 }}}