New User Registration

Actors: Guest User

1. A guest user selects Register and chooses to register as a regular user.

2. The user enters personal details.

3. The system creates the user with role USER.

INSERT INTO user_entity (first_name, last_name, email, password, role)
VALUES ('John', 'Doe', 'john.doe@email.com', 'hashed_password', 'USER');

INSERT INTO users (id)
VALUES (currval('user_entity_id_seq'));