== New User Registration

==== Actors: **Guest User**

**1.** Check if Email Already Exists


{{{#!sql
SELECT COUNT(*)
FROM user_entity
WHERE email = :email;

}}}


**2.** Create New User Account.


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

}}}



**3.** Create Record in users Table.


{{{#!sql
INSERT INTO users (id)
VALUES (currval('user_entity_id_seq'));


}}}