UseCase02 - Doctor Login / Authentication

Initiating Actor - Doctor

Description

A doctor logs into the Medora healthcare system using their username and password. The system verifies the credentials, checks that the account is active, retrieves the doctor's profile with department and specialization, and grants access to the doctor's portal.

Scenario

1. Doctor navigates to the Medora login page.

2. Doctor enters their username (email address) 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 = 'elena.kirova@medora.com';

3. System verifies the account is active and the password matches.

SELECT u.user_id
FROM users u
WHERE u.username = 'elena.kirova@medora.com'
  AND u.is_active = TRUE;

4. System retrieves the linked doctor profile with specialization and department.

SELECT
  d.doctor_id,
  ds.specialization_name,
  dep.department_name,
  d.first_name,
  d.last_name,
  d.email_address
FROM doctors d
JOIN users u ON u.user_id = d.user_id
JOIN doctor_specialization ds ON d.specialization_id = ds.specialization_id
JOIN departments dep ON d.department_id = dep.department_id
WHERE u.username = 'elena.kirova@medora.com';

5. Doctor is authenticated and redirected to their dashboard.