UseCase001 - Registering a user

Initiating actor: Unregistered Guest

The goal of this use case is to allow a new visitor to create a permanent account within the system by providing their personal details. Upon successful registration, the system creates a new record in the User table and assigns the user to the Consumer role, enabling them to access personalized features like wishlists and order history.

Scenario

1. User provides their required registration details, including a email, password and username, and submits the registration form.

2. System validates that the email is unique and that all required fields meet the necessary formatting standards.

SELECT COUNT(*) 
FROM User 
WHERE email = 'user@example.com';

3. System creates a new entry in the User table with a unique user_id and the current date_created.

INSERT INTO User (email, password, username, date_created) 
VALUES ('user@example.com', 'hashed_password', 'NewUser', CURRENT_TIMESTAMP);

4. System initializes a corresponding entry in the Consumer table, setting the points_collected to zero and establishing the one-to-one relationship with the new user_id.

INSERT INTO Consumer (user_id, points_collected) 
VALUES (LAST_INSERT_ID(), 0);

5. System confirms the successful account creation and automatically logs the user in.