Use-case 0014 - Cancel an Active Booking

Initiating actor: Pet Owner

Other actors: None

Description: An owner decides they no longer need a sitter and cancels an active (Pending or Confirmed) booking request before the job takes place.

Scenario:

1. Pet Owner navigates to their "My Bookings" page.
2. System fetches the owner's current active bookings:

   SELECT booking_id, date_from, address, status 
   FROM bookings 
   WHERE owner_id = (SELECT user_id FROM users WHERE username = 'owner_bojan')
     AND status IN ('Pending', 'Confirmed');
   

3. Owner clicks the "Cancel Booking" button.
4. System updates the booking status:

   UPDATE bookings
   SET status = 'Canceled'
   WHERE booking_id = 'specific-booking-uuid-here';