Use-case 0001 - User Registration

Initiating actor: Guest (Unauthenticated visitor)

Other actors: None

Description: The guest creates a new account in the system by providing personal information (name, email, phone, gender, birthday). The system validates that the email is unique and saves the user in the database.

Scenario:

User opens the registration page.

System displays the registration form with fields: first name, last name, email, phone number, gender, birthday.

User fills the form and submits.

System validates that the email is not already used.

SET search_path TO project;

SELECT user_id
FROM "user"
WHERE email = :email;

If the email is unique, the system creates a new account.

SET search_path TO project;

INSERT INTO "user"(first_name, last_name, email, phone_number, gender, birthday)
VALUES (:first_name, :last_name, :email, :phone_number, :gender, :birthday)
RETURNING user_id;

System confirms successful registration and shows the login page.