New User Registration

Actors: Guest User

1. Check if Email Already Exists

SELECT COUNT(*)
FROM user_entity
WHERE email = :email;

2. Create New User Account.

INSERT INTO user_entity (first_name, last_name, email, password, role)
VALUES (:firstName, :lastName, :email, :hashedPassword, 'USER');

3. Create Record in users Table.

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