Changes between Version 1 and Version 2 of UseCase15
- Timestamp:
- 09/22/26 15:56:10 (12 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UseCase15
v1 v2 17 17 FROM medical_records mr 18 18 WHERE mr.patient_id = ( 19 SELECT patient_id FROM users WHERE username = 'maja.veljanova' 19 SELECT p.patient_id 20 FROM patients p 21 JOIN users u ON u.user_id = p.user_id 22 WHERE u.username = '1402994123456' 20 23 ); 21 24 }}} … … 34 37 JOIN allergies a ON mra.allergy_id = a.allergy_id 35 38 WHERE mra.record_id = ( 36 SELECT record_id FROM medical_records 37 WHERE patient_id = (SELECT patient_id FROM users WHERE username = 'maja.veljanova') 39 SELECT mr.record_id 40 FROM medical_records mr 41 JOIN patients p ON mr.patient_id = p.patient_id 42 JOIN users u ON u.user_id = p.user_id 43 WHERE u.username = '1402994123456' 38 44 ); 39 45 }}} … … 43 49 {{{ 44 50 #!sql 45 INSERT INTO prescriptions (medication_name) 46 VALUES ('Lisinopril') 51 INSERT INTO prescriptions (prescription_id, medication_name) 52 VALUES ( 53 (SELECT COALESCE(MAX(prescription_id), 0) + 1 FROM prescriptions), 54 'Lisinopril' 55 ) 47 56 RETURNING prescription_id; 48 57 }}} … … 54 63 INSERT INTO prescription_medical_records (record_id, prescription_id, dosage, frequency, duration, notes) 55 64 VALUES ( 56 (SELECT record_id FROM medical_records WHERE patient_id = (SELECT patient_id FROM users WHERE username = 'maja.veljanova')), 65 (SELECT mr.record_id 66 FROM medical_records mr 67 JOIN patients p ON mr.patient_id = p.patient_id 68 JOIN users u ON u.user_id = p.user_id 69 WHERE u.username = '1402994123456'), 57 70 (SELECT MAX(prescription_id) FROM prescriptions), 58 71 '10mg', … … 77 90 JOIN prescriptions p ON pmr.prescription_id = p.prescription_id 78 91 WHERE pmr.record_id = ( 79 SELECT record_id FROM medical_records 80 WHERE patient_id = (SELECT patient_id FROM users WHERE username = 'maja.veljanova') 92 SELECT mr.record_id 93 FROM medical_records mr 94 JOIN patients p ON mr.patient_id = p.patient_id 95 JOIN users u ON u.user_id = p.user_id 96 WHERE u.username = '1402994123456' 81 97 ); 82 98 }}}
