Changes between Version 1 and Version 2 of UseCase06

Timestamp:

05/17/26 19:11:34 (8 days ago)

Author:

181201

Comment:

--

UseCase06

@@ -1 @@
-== Use-case 0006 - Process a Payment
+== Use-case 0006 - Process an Upfront Payment
 
 '''Initiating actor:''' Pet Owner
@@ -6 +6 @@
 
 '''Description:'''
-The owner must pay for a confirmed booking. The system finds unpaid bookings for that user, and the owner submits their payment method. The system records the financial transaction and links it securely to the booking.
+The owner must provide payment details when submitting a new booking request. The system records the financial transaction upfront and links it securely to the pending booking.
 
 '''Scenario:'''
- 1. Pet Owner navigates to their "Pending Payments" dashboard.
- 2. System fetches confirmed bookings that do not have a matching payment record yet using a LEFT JOIN:
-{{{
-#!sql
-SELECT b.booking_id, b.address, b.date_from 
-FROM bookings b
-LEFT JOIN payments p ON b.booking_id = p.booking_id
-WHERE b.owner_id = (SELECT user_id FROM users WHERE username = 'owner_bojan')
-  AND b.status = 'CONFIRMED'
-  AND p.payment_id IS NULL;
-}}}
- 3. Owner selects a booking, chooses 'CREDIT_CARD', and submits the payment.
- 4. System securely records the payment in the database, satisfying the 1:1 relationship rule:
+ 1. Pet Owner navigates to a Sitter's profile and clicks "Book Now".
+ 2. Owner fills out the booking dates, address, and selects their pets.
+ 3. Owner enters the payment amount, chooses 'Card' from the dropdown, and submits the form.
+ 4. System securely creates the booking, and immediately records the payment in the database, satisfying the 1:1 relationship rule:
 {{{
 #!sql
@@ -27 +18 @@
 VALUES (
     1500, 
-    'CREDIT_CARD',
+    'Card',
     (SELECT booking_id FROM bookings WHERE address = 'ul. Partizanska br. 10' LIMIT 1)
 );