Changes between Version 2 and Version 3 of UseCase18

Timestamp:

09/22/26 16:03:16 (21 hours ago)

Author:

236021

Comment:

--

UseCase18

@@ -39 +39 @@
 }}}
 
-3. Admin enters the new doctor's professional details, and the system creates the doctor profile first.
+3. Admin enters the new login credentials, and the system creates the user account first, since the doctor profile will need to reference it.
 
 {{{
 #!sql
-INSERT INTO doctors (specialization_id, department_id, first_name, last_name, email_address, level_id)
+INSERT INTO users (username, password, role, first_name, last_name, is_active)
 VALUES (
-  (SELECT specialization_id FROM doctor_specialization WHERE specialization_name = 'Cardiology'),
-  (SELECT department_id FROM departments WHERE department_name = 'Cardiology'),
+  'nikola.trajkov2@medora.com',
+  '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO',
+  'DOCTOR',
   'Nikola',
   'Trajkov',
-  'nikola.trajkov@cardio.com',
-  (SELECT level_id FROM doctor_level WHERE level = 'RESIDENT')
+  TRUE
 )
-RETURNING doctor_id;
+RETURNING user_id;
 }}}
 
-4. Admin enters the new login credentials, and the system creates the user account linked to that doctor profile.
+4. Admin enters the new doctor's professional details, and the system creates the doctor profile linked to that user account.
 
 {{{
 #!sql
-INSERT INTO users (username, password, role, first_name, last_name, is_active, doctor_id)
+INSERT INTO doctors (doctor_id, first_name, last_name, email_address, level_id, specialization_id, department_id, user_id)
 VALUES (
-  'nikola.trajkov',
-  'password123',
-  'DOCTOR',
+  (SELECT COALESCE(MAX(doctor_id), 0) + 1 FROM doctors),
   'Nikola',
   'Trajkov',
-  TRUE,
-  (SELECT MAX(doctor_id) FROM doctors)
+  'nikola.trajkov2@medora.com',
+  (SELECT level_id FROM doctor_level WHERE level = 'RESIDENT'),
+  (SELECT specialization_id FROM doctor_specialization WHERE specialization_name = 'CARDIOLOGY'),
+  (SELECT department_id FROM departments WHERE department_name = 'CARDIOLOGY_DEPT'),
+  (SELECT MAX(user_id) FROM users)
 )
-RETURNING user_id;
+RETURNING doctor_id;
 }}}