= Use-case 0004 Implementation - Create a Booking

'''Initiating actor:''' Pet Owner

'''Other actors:''' Pet Sitter

'''Description:'''
A Pet Owner selects "Find a Sitter" button. They must select the specific service they want. The system searches for the sitters who provide that service and the pet owner can select the desired sitter and create the booking and links the requested services using a secure database transaction.

'''Scenario:'''

 1. Pet Owner selects the "Find a Sitter" button on their dashboard.

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

{{{
#!sql
Hibernate: 
    select
        s1_0.service_id,
        s1_0.description,
        s1_0.type 
    from
        project.services s1_0

}}}


 2. Pet Owner selects the specific service they want to request.

[[Image(UC0004-2.png)]]

{{{
#!sql
Hibernate: 
    select
        s1_0.service_id,
        s1_0.description,
        s1_0.type 
    from
        project.services s1_0
Hibernate: 
    select
        ps1_0.user_id,
        ps1_1.email,
        ps1_1.first_name,
        ps1_1.last_name,
        ps1_1.password,
        ps1_1.username 
    from
        project.pet_sitters ps1_0 
    join
        project.users ps1_1 
            on ps1_0.user_id=ps1_1.user_id 
    left join
        project.sitter_services os1_0 
            on ps1_0.user_id=os1_0.sitter_id 
    left join
        project.services os1_1 
            on os1_1.service_id=os1_0.service_id 
    where
        os1_1.type=?
Hibernate: 
    select
        avg(r1_0.rating) 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    where
        b1_0.sitter_id=?
Hibernate: 
    select
        avg(r1_0.rating) 
    from
        project.reviews r1_0 
    join
        project.bookings b1_0 
            on b1_0.booking_id=r1_0.booking_id 
    where
        b1_0.sitter_id=?

}}}



 3. System provides the sitters that offer this service:


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

 4. Owner selects "Book now".

{{{
#!sql
Hibernate: 
    select
        p1_0.pet_id,
        p1_0.age,
        p1_0.description,
        p1_0.name,
        p1_0.owner_id,
        p1_0.pettype_id,
        p1_0.photo,
        p1_0.special_needs 
    from
        project.pets p1_0 
    left join
        project.pet_owners o1_0 
            on o1_0.user_id=p1_0.owner_id 
    where
        o1_0.user_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
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species 
    from
        project.pet_types pt1_0 
    where
        pt1_0.pettype_id=?
Hibernate: 
    select
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species 
    from
        project.pet_types pt1_0 
    where
        pt1_0.pettype_id=?
Hibernate: 
    select
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species 
    from
        project.pet_types pt1_0 
    where
        pt1_0.pettype_id=?
Hibernate: 
    select
        ps1_0.user_id,
        ps1_1.email,
        ps1_1.first_name,
        ps1_1.last_name,
        ps1_1.password,
        ps1_1.username 
    from
        project.pet_sitters ps1_0 
    join
        project.users ps1_1 
            on ps1_0.user_id=ps1_1.user_id 
    where
        ps1_0.user_id=?

}}}
 5. Owner submits the necessary details for the booking and submits the form. The system creates the booking with a 'Pending' status:

[[Image(UC0004-4.png)]]

{{{
#!sql
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
        ps1_0.user_id,
        ps1_1.email,
        ps1_1.first_name,
        ps1_1.last_name,
        ps1_1.password,
        ps1_1.username 
    from
        project.pet_sitters ps1_0 
    join
        project.users ps1_1 
            on ps1_0.user_id=ps1_1.user_id 
    where
        ps1_0.user_id=?
Hibernate: 
    select
        p1_0.pet_id,
        p1_0.age,
        p1_0.description,
        p1_0.name,
        p1_0.owner_id,
        p1_0.pettype_id,
        p1_0.photo,
        p1_0.special_needs 
    from
        project.pets p1_0 
    where
        p1_0.pet_id in (?)
Hibernate: 
    select
        pt1_0.pettype_id,
        pt1_0.needs_outdoor_walk,
        pt1_0.species 
    from
        project.pet_types pt1_0 
    where
        pt1_0.pettype_id=?
Hibernate: 
    select
        s1_0.service_id,
        s1_0.description,
        s1_0.type 
    from
        project.services s1_0
Hibernate: 
    insert 
    into
        project.bookings
        (address, date_from, date_to, owner_id, sitter_id, status, booking_id) 
    values
        (?, ?, ?, ?, ?, ?, ?)
Hibernate: 
    insert 
    into
        project.booking_pets
        (booking_id, pet_id) 
    values
        (?, ?)
Hibernate: 
    insert 
    into
        project.booking_services
        (booking_id, service_id) 
    values
        (?, ?)
Hibernate: 
    insert 
    into
        project.payments
        (amount, booking_id, payment_type, payment_id) 
    values
        (?, ?, ?, ?)
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_owners o1_0 
            on o1_0.user_id=b1_0.owner_id 
    where
        o1_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
        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=?

}}}