Changes between Version 1 and Version 2 of UseCase05

Timestamp:

09/19/26 16:06:33 (3 days ago)

Author:

236021

Comment:

--

UseCase05

@@ -17 +17 @@
   mr.patient_id
 FROM medical_records mr
-WHERE mr.patient_id = (
-SELECT patient_id 
-FROM patients 
-WHERE user_id = (
-SELECT user_id 
-FROM users 
-WHERE username = 'maja.veljanova'));
+WHERE mr.patient_id = (SELECT patient_id FROM users WHERE username = 'maja.veljanova');
 }}}
 
@@ -44 +38 @@
 INSERT INTO medical_record_symptoms (record_id, symptom_id, severity)
 VALUES (
-  (SELECT record_id FROM medical_records WHERE patient_id = (SELECT patient_id FROM patients WHERE user_id = (SELECT user_id FROM users WHERE username = 'maja.veljanova'))),
+  (SELECT record_id FROM medical_records WHERE patient_id = (SELECT patient_id FROM users WHERE username = 'maja.veljanova')),
   (SELECT symptom_id FROM symptoms WHERE name = 'Headache'),
   'MODERATE'
@@ -58 +52 @@
   'Essential hypertension',
   'High blood pressure condition',
-  (SELECT patient_id FROM patients WHERE user_id = (SELECT user_id FROM users WHERE username = 'maja.veljanova')),
-  (SELECT doctor_id FROM doctors WHERE user_id = (SELECT user_id FROM users WHERE username = 'elena.kirova'))
+  (SELECT patient_id FROM users WHERE username = 'maja.veljanova'),
+  (SELECT doctor_id FROM users WHERE username = 'elena.kirova')
 )
 RETURNING diagnosis_id;
@@ -76 +70 @@
 FROM diagnosis d
 JOIN doctors doc ON d.doctor_id = doc.doctor_id
-JOIN users u ON doc.user_id = u.user_id
-WHERE d.diagnosis_id = (
-SELECT MAX(diagnosis_id) 
-FROM diagnosis);
+JOIN users u ON u.doctor_id = doc.doctor_id
+WHERE d.diagnosis_id = (SELECT MAX(diagnosis_id) FROM diagnosis);
 }}}