Regular User Registration Process

Authors: Registered Regular User

A new user registers on the platform as a regular user, gaining the ability to read stories, leave comments, likes, and manage their reading list.

1. The user selects the option to register as a regular user on the platform.

2. The system displays a registration form requesting username, email, name, surname, and password.

3. The user fills in and submits the registration form.

4. The system inserts a new record into the USERS table.

INSERT INTO USERS (username, email, name, surname, password)
VALUES ('sara_reader', 'sara.books@gmail.com', 'Sara', 'Petkovska', '$2a$10$hashedpassword004');

5. The system registers the user as a regular user in the REGULAR_USER table using the generated user_id.

INSERT INTO REGULAR_USER (user_id)
VALUES (4);

6. The system confirms successful registration and redirects the user to the platform homepage.