Changes between Initial Version and Version 1 of UseCase07

Timestamp:

01/24/26 14:27:17 (2 weeks ago)

Author:

231035

Comment:

--

UseCase07

@@ +1 @@
+= UseCase07 - Create an Appointment
+** Initiating actor: Owner **
+== Description
+An owner schedules an appointment for one of their pets at a vet clinic they choose. The owner selects one of their animals, selects a clinic and submits the appointment request. The system then confirms the appointment has been created.
+== Scenario
+1. Owner opens a specific vet clinic.
+{{{
+SELECT
+  clinic_id,
+  name,
+  city,
+  address,
+  email,
+  phone,
+  open_time,
+  close_time,
+  not_working_isodow
+FROM vet_clinics
+WHERE clinic_id = $1;
+}}}
+2. Owner clicks "Create an appointment".
+{{{
+SELECT
+  a.animal_id,
+  a.name,
+  a.species,
+  a.breed
+FROM animals a
+WHERE a.owner_id = $1
+ORDER BY a.name;
+}}}
+3. Owner fills in the form.
+{{{
+BEGIN;
+
+SELECT 1
+FROM appointments ap
+WHERE ap.clinic_id = $1
+  AND ap.date_time = $2
+  AND ap.status = 'CONFIRMED'
+FOR UPDATE;
+
+INSERT INTO appointments (
+  clinic_id,
+  animal_id,
+  responsible_owner_id,
+  status,
+  date_time,
+  notes
+)
+VALUES (
+  $1,
+  $3,
+  $4,
+  'CONFIRMED',
+  $2,
+  $5
+)
+RETURNING appointment_id;
+
+COMMIT;
+}}}