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.

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.

SELECT u.user_id
FROM users u
WHERE u.username = 'maja.veljanova'
  AND u.is_active = TRUE;

4. System retrieves the linked patient profile.

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.