= 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.
{{{
SELECT user_id, username, name, surname
FROM users
WHERE username = 'client.igor';
}}}
2. Clicks the "Leave review" button.
3. Client enters rating, comment and submits.
{{{
BEGIN;

WITH new_review AS (
  INSERT INTO reviews (reviewer_id, rating, comment, created_at)
  VALUES (
    (SELECT user_id FROM users WHERE username = 'client.sara'),
    5,
    'Very helpful and professional. Recommended!',
    NOW()
  )
  RETURNING review_id
)

INSERT INTO user_reviews (review_id, target_user_id)
SELECT
  nr.review_id,
  (SELECT user_id FROM users WHERE username = 'client.igor')
FROM new_review nr;

COMMIT;
}}}