Changes between Initial Version and Version 1 of UseCase06

Timestamp:

01/24/26 13:38:21 (2 weeks ago)

Author:

231035

Comment:

--

UseCase06

@@ +1 @@
+= 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;
+}}}