Use-case 0006 - Process an Upfront Payment

Initiating actor: Pet Owner

Other actors: None

Description: The owner must provide payment details when submitting a new booking request. The system records the financial transaction upfront and links it securely to the pending booking.

Scenario:

1. Pet Owner navigates to a Sitter's profile and clicks "Book Now".
2. Owner fills out the booking dates, address, and selects their pets.
3. Owner enters the payment amount, chooses 'Card' from the dropdown, and submits the form.
4. System securely creates the booking, and immediately records the payment in the database, satisfying the 1:1 relationship rule:

   INSERT INTO payments (amount, payment_type, booking_id)
   VALUES (
       1500, 
       'Card',
       (SELECT booking_id FROM bookings WHERE address = 'ul. Partizanska br. 10' LIMIT 1)
   );