Changes between Version 1 and Version 2 of UseCase18

Timestamp:

09/19/26 17:13:20 (4 days ago)

Author:

236021

Comment:

--

UseCase18

@@ -39 +39 @@
 }}}
 
-3. Admin clicks "Create User" and enters the new user's details.
+3. Admin enters the new doctor's professional details, and the system creates the doctor profile first.
 
 {{{
 #!sql
-INSERT INTO users (username, password, role, first_name, last_name, is_active)
+INSERT INTO doctors (specialization_id, department_id, first_name, last_name, email_address, level_id)
+VALUES (
+  (SELECT specialization_id FROM doctor_specialization WHERE specialization_name = 'Cardiology'),
+  (SELECT department_id FROM departments WHERE department_name = 'Cardiology'),
+  'Nikola',
+  'Trajkov',
+  'nikola.trajkov@cardio.com',
+  (SELECT level_id FROM doctor_level WHERE level = 'RESIDENT')
+)
+RETURNING doctor_id;
+}}}
+
+4. Admin enters the new login credentials, and the system creates the user account linked to that doctor profile.
+
+{{{
+#!sql
+INSERT INTO users (username, password, role, first_name, last_name, is_active, doctor_id)
 VALUES (
   'nikola.trajkov',
@@ -50 +66 @@
   'Nikola',
   'Trajkov',
-  TRUE
+  TRUE,
+  (SELECT MAX(doctor_id) FROM doctors)
 )
 RETURNING user_id;
-}}}
-
-4. System creates the role-specific profile linked to the new user.
-
-{{{
-#!sql
-INSERT INTO doctors (user_id, specialization_id, department_id, first_name, last_name, email_address, level_id)
-VALUES (
-  (SELECT user_id FROM users WHERE username = 'nikola.trajkov'),
-  (SELECT specialization_id FROM doctor_specialization WHERE specialization_name = 'Cardiology'),
-  (SELECT department_id FROM departments WHERE department_name = 'Cardiology'),
-  'Nikola',
-  'Trajkov',
-  'nikola.trajkov@cardio.com',
-  (SELECT level_id FROM doctor_level WHERE level = 'RESIDENT')
-);
 }}}