User Login

Actors: Registered User (USER / ADMIN / INSTRUCTOR)

1. Check if User Exists.”.

The system checks whether a user with the given email exists in the database.

SELECT id, password, role
FROM user_entity
WHERE email = :email;

2. Password Validation (Application Logic).

The entered password is compared with the stored hashed password. If the password is invalid, the login process is stopped. If the password is valid, the process continues.

3. Load User Type Based on Role.

After successful authentication, the system loads the user type according to the role.

If the role is USER:

SELECT id
FROM users
WHERE id = :userId;

If the role is ADMIN:

SELECT id
FROM administrators
WHERE id = :userId;

If the role is INSTRUCTOR:

SELECT id
FROM instructors
WHERE id = :userId;