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 user_id = $1;
   

2. Clicks the "Leave review" button.
3. Client enters rating, comment and submits.

   BEGIN;
   
   INSERT INTO reviews (reviewer_id, rating, comment, created_at)
   VALUES ($1, $2, $3, NOW())
   RETURNING review_id;
   
   INSERT INTO user_reviews (review_id, target_user_id)
   VALUES ($4, $5);
   
   COMMIT;