= UseCase11 - Leave a !VetClinic review
** Initiating actor: Client **
== Description
A logged-in client can submit a review about a vet clinic in the system. A client can review a vet clinic only if the client has at least one completed (DONE) appointment at that clinic for at least one of their pets(he is the current owner).
== Scenario
1. Client opens the clinics page.
{{{
SELECT clinic_id, name, city, address
FROM vet_clinics
WHERE clinic_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 clinic_reviews (review_id, target_clinic_id)
VALUES ($4, $5);

COMMIT;
}}}