Changes between Initial Version and Version 1 of UseCase18

Timestamp:

06/14/26 21:05:57 (5 days ago)

Author:

236021

Comment:

--

UseCase18

@@ +1 @@
+= UseCase18 - System Administrator Manages Users =
+
+== Initiating Actor - `System Administrator` ==
+
+== Description ==
+A system administrator creates new user accounts and manages existing ones. The admin can register patients, doctors, lab technicians, and other admins, and can view and filter all users in the system.
+
+== Scenario ==
+
+1. Admin navigates to the user management section and views all users in the system.
+
+{{{
+#!sql
+SELECT
+  u.user_id,
+  u.username,
+  u.role,
+  u.first_name,
+  u.last_name,
+  u.is_active
+FROM users u
+ORDER BY u.role, u.username;
+}}}
+
+2. Admin filters users by role.
+
+{{{
+#!sql
+SELECT
+  u.user_id,
+  u.username,
+  u.role,
+  u.first_name,
+  u.last_name,
+  u.is_active
+FROM users u
+WHERE u.role = 'DOCTOR'
+ORDER BY u.username;
+}}}
+
+3. Admin clicks "Create User" and enters the new user's details.
+
+{{{
+#!sql
+INSERT INTO users (username, password, role, first_name, last_name, is_active)
+VALUES (
+  'nikola.trajkov',
+  'password123',
+  'DOCTOR',
+  'Nikola',
+  'Trajkov',
+  TRUE
+)
+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')
+);
+}}}
+
+5. System displays the updated user list confirming the new account.
+
+{{{
+#!sql
+SELECT
+  u.user_id,
+  u.username,
+  u.role,
+  u.first_name,
+  u.last_name,
+  u.is_active
+FROM users u
+ORDER BY u.role, u.username;
+}}}