Changes between Version 2 and Version 3 of UseCase02
- Timestamp:
- 09/22/26 14:03:02 (12 hours ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
UseCase02
v2 v3 11 11 1. Doctor navigates to the Medora login page. 12 12 13 2. Doctor enters their username and password and submits the login form.13 2. Doctor enters their username (email address) and password and submits the login form. 14 14 15 15 {{{ … … 24 24 u.is_active 25 25 FROM users u 26 WHERE u.username = 'elena.kirova ';26 WHERE u.username = 'elena.kirova@medora.com'; 27 27 }}} 28 28 … … 33 33 SELECT u.user_id 34 34 FROM users u 35 WHERE u.username = 'elena.kirova '35 WHERE u.username = 'elena.kirova@medora.com' 36 36 AND u.is_active = TRUE; 37 37 }}} … … 49 49 d.email_address 50 50 FROM doctors d 51 JOIN users u ON u. doctor_id = d.doctor_id51 JOIN users u ON u.user_id = d.user_id 52 52 JOIN doctor_specialization ds ON d.specialization_id = ds.specialization_id 53 53 JOIN departments dep ON d.department_id = dep.department_id 54 WHERE u.username = 'elena.kirova ';54 WHERE u.username = 'elena.kirova@medora.com'; 55 55 }}} 56 56
