Use-case 0004 - Create a Booking

Initiating actor: Pet Owner

Other actors: Pet Sitter

Description: A Pet Owner finds a Pet Sitter they like and requests a booking. The system creates the booking and links the selected pets using a secure database transaction.

Scenario:

1. Pet Owner views the profile of a sitter and clicks "Book Now".
2. Owner fills out the dates, location, selects the pets, and submits.
3. System creates the booking with a 'Pending' status:

   INSERT INTO bookings (status, date_from, date_to, address, owner_id, sitter_id)
   VALUES (
       'Pending', '2026-06-10', '2026-06-12', 'ul. Partizanska br. 10',
       (SELECT user_id FROM users WHERE username = 'owner_bojan'),
       (SELECT user_id FROM users WHERE username = 'sitter_filip')
   );