= UseCase06 - Leave a client review
** Initiating actor: Client **
== Description
A logged-in client can submit a review about another user in the system.
== Scenario
1. Client opens a target user profile.
[[Image(creview.png)]]
{{{
 select r1_0.review_id,
r1_0.comment,
r1_0.created_at,
r1_0.is_deleted,
r1_0.rating,
r1_0.reviewer_id,
r2_0.user_id,
r2_0.created_at,
r2_0.email,
r2_0.name,
r2_0.surname,
r2_0.password_hash,
r2_0.username,
r1_0.updated_at 
from user_reviews ur1_0 
join reviews r1_0 on r1_0.review_id=ur1_0.review_id 
join users r2_0 on r2_0.user_id=r1_0.reviewer_id 
where ur1_0.target_user_id=? and r1_0.is_deleted=false
 order by r1_0.created_at desc
}}}
2. Clicks the "Leave review" button.
[[Image(creview1.png)]]
3. Client enters rating, comment and submits.
[[Image(creview2.png)]]
[[Image(creview3.png)]]
{{{
insert into reviews (comment,created_at,is_deleted,rating,reviewer_id,updated_at) 
values (?,?,?,?,?,?)
}}}