== 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:
{{{
#!sql
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')
);
}}}