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:
- Pet Sitter goes to their "Pending Requests" dashboard.
- System fetches all bookings assigned to them that are still pending:
- Sitter clicks the "Accept Booking" button on a specific request.
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=?
- System updates the status of the booking in the database to CONFIRMED:
Last modified
7 days ago
Last modified on 05/19/26 01:04:33
Attachments (3)
- UC0007-1.png (22.7 KB ) - added by 7 days ago.
- UC0007-2.png (35.2 KB ) - added by 7 days ago.
- UC0007-3.png (34.7 KB ) - added by 7 days ago.
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.
