Changes between Initial Version and Version 1 of UseCase01

Timestamp:

06/12/26 16:19:48 (8 days ago)

Author:

236021

Comment:

--

UseCase01

@@ +1 @@
+= UseCase01 - Patient LoginAuthentication =
+
+== Initiating Actor - `Patient` ==
+
+
+== Description ==
+A patient logs into the Medora healthcare system using their username and password. The system verifies the credentials and then it checks if the account is active, and grants access to the patient portal.
+
+== Scenario ==
+
+1. Patient navigates to the Medora login page.
+
+2. Patient enters their username and password and submits the login form.
+
+{{{
+#!sql
+SELECT
+  u.user_id,
+  u.username,
+  u.password,
+  u.role,
+  u.first_name,
+  u.last_name,
+  u.is_active
+FROM users u
+WHERE u.username = 'maja.veljanova';
+}}}
+
+3. System verifies if the account is active and the password matches.
+
+{{{
+#!sql
+SELECT u.user_id
+FROM users u
+WHERE u.username = 'maja.veljanova'
+  AND u.is_active = TRUE;
+}}}
+
+4. System retrieves the linked patient profile.
+
+{{{
+#!sql
+SELECT
+  p.patient_id,
+  p.date_of_birth,
+  p.gender,
+  p.phone_number,
+  p.embg
+FROM patients p
+WHERE p.user_id = (SELECT user_id FROM users WHERE username = 'maja.veljanova');
+}}}
+
+5. Patient is authenticated and then redirected to their profile dashboard.