| Version 1 (modified by , 7 days ago) ( diff ) |
|---|
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:
- Pet Owner selects the "Find a Sitter" button on their dashboard.
Hibernate:
select
s1_0.service_id,
s1_0.description,
s1_0.type
from
project.services s1_0
- Pet Owner selects the specific service they want to request.
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=?
- System provides the sitters that offer this service:
- Owner selects "Book now".
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=?
- Owner submits the necessary details for the booking and submits the form. The system creates the booking with a 'Pending' status:
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=?
Attachments (4)
- UC0004-1.png (8.8 KB ) - added by 7 days ago.
- UC0004-2.png (5.8 KB ) - added by 7 days ago.
- UC0004-3.png (10.4 KB ) - added by 7 days ago.
- UC0004-4.png (11.8 KB ) - added by 7 days ago.
Download all attachments as: .zip
Note:
See TracWiki
for help on using the wiki.
