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;