== 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:
{{{
#!sql
INSERT INTO payments (amount, payment_type, booking_id)
VALUES (
    1500, 
    'Card',
    (SELECT booking_id FROM bookings WHERE address = 'ul. Partizanska br. 10' LIMIT 1)
);
}}}