= Use-case 0007 Implementation - Accept a Booking

'''Initiating actor:''' Pet Sitter

'''Other actors:''' Pet Owner

'''Description:'''
A Pet Sitter logs in and sees they have a new pending booking request. They review the dates, the requested service, and decide to accept the job. The system updates the booking status.

'''Scenario:'''
1. Pet Sitter goes to their "Pending Requests" dashboard.


[[Image(UC0007-1.png)]]

 2. System fetches all bookings assigned to them that are still pending:
 3. Sitter clicks the "Accept Booking" button on a specific request.

{{{
#!sql
Hibernate: 
    select
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status 
    from
        project.bookings b1_0 
    join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        b1_0.booking_id=?
Hibernate: 
    update
        project.bookings 
    set
        address=?,
        date_from=?,
        date_to=?,
        owner_id=?,
        sitter_id=?,
        status=? 
    where
        booking_id=?
Hibernate: 
    select
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        b1_0.sitter_id,
        b1_0.status 
    from
        project.bookings b1_0 
    left join
        project.pet_sitters s1_0 
            on s1_0.user_id=b1_0.sitter_id 
    where
        s1_0.user_id=? 
    order by
        b1_0.date_from desc
Hibernate: 
    select
        po1_0.user_id,
        po1_1.email,
        po1_1.first_name,
        po1_1.last_name,
        po1_1.password,
        po1_1.username 
    from
        project.pet_owners po1_0 
    join
        project.users po1_1 
            on po1_0.user_id=po1_1.user_id 
    where
        po1_0.user_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        po1_0.user_id,
        po1_1.email,
        po1_1.first_name,
        po1_1.last_name,
        po1_1.password,
        po1_1.username 
    from
        project.pet_owners po1_0 
    join
        project.users po1_1 
            on po1_0.user_id=po1_1.user_id 
    where
        po1_0.user_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        po1_0.user_id,
        po1_1.email,
        po1_1.first_name,
        po1_1.last_name,
        po1_1.password,
        po1_1.username 
    from
        project.pet_owners po1_0 
    join
        project.users po1_1 
            on po1_0.user_id=po1_1.user_id 
    where
        po1_0.user_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        r1_0.review_id,
        r1_0.booking_id,
        r1_0.comment,
        r1_0.rating,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        p1_0.payment_type 
    from
        project.payments p1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.reviews r1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        r1_0.review_id,
        r1_0.booking_id,
        b1_0.booking_id,
        b1_0.address,
        b1_0.date_from,
        b1_0.date_to,
        b1_0.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_0.payment_id,
        p1_0.amount,
        p1_0.booking_id,
        p1_0.payment_type,
        b1_0.sitter_id,
        s1_0.user_id,
        s1_1.email,
        s1_1.first_name,
        s1_1.last_name,
        s1_1.password,
        s1_1.username,
        b1_0.status,
        r1_0.comment,
        r1_0.rating 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=b1_0.owner_id 
    left join
        project.payments p1_0 
            on b1_0.booking_id=p1_0.booking_id 
    left join
        (project.pet_sitters s1_0 
    join
        project.users s1_1 
            on s1_0.user_id=s1_1.user_id) 
        on s1_0.user_id=b1_0.sitter_id 
    where
        r1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?
Hibernate: 
    select
        s1_0.booking_id,
        s1_1.service_id,
        s1_1.description,
        s1_1.type 
    from
        project.booking_services s1_0 
    join
        project.services s1_1 
            on s1_1.service_id=s1_0.service_id 
    where
        s1_0.booking_id=?
Hibernate: 
    select
        p1_0.booking_id,
        p1_1.pet_id,
        p1_1.age,
        p1_1.description,
        p1_1.name,
        p1_1.owner_id,
        o1_0.user_id,
        o1_1.email,
        o1_1.first_name,
        o1_1.last_name,
        o1_1.password,
        o1_1.username,
        p1_1.pettype_id,
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species,
        p1_1.photo,
        p1_1.special_needs 
    from
        project.booking_pets p1_0 
    join
        project.pets p1_1 
            on p1_1.pet_id=p1_0.pet_id 
    left join
        (project.pet_owners o1_0 
    join
        project.users o1_1 
            on o1_0.user_id=o1_1.user_id) 
        on o1_0.user_id=p1_1.owner_id 
    left join
        project.pet_types pt1_0 
            on pt1_0.pettype_id=p1_1.pettype_id 
    where
        p1_0.booking_id=?

}}}

 4. System updates the status of the booking in the database to CONFIRMED:
[[Image(UC0007-2.png)]]

[[Image(UC0007-3.png)]]