Changes between Initial Version and Version 1 of UseCase0006

Timestamp:

01/10/26 18:01:25 (10 days ago)

Author:

193284

Comment:

--

UseCase0006

@@ +1 @@
+= Use-case 0006 - Book Venue =
+
+'''Initiating actor:''' Bride / Groom (Wedding owner)
+
+'''Other actors:''' Wedding Organizer (Assistant)
+
+== Description ==
+The user books a venue for the wedding. The venue booking includes date, start/end time, booking status and price, and connects the wedding with a chosen venue.
+
+== Scenario ==
+1. The user opens "Venues" and searches/selects a venue.
+2. The system shows available venues with details.
+
+{{{
+SET search_path TO project;
+
+SELECT v.venue_id, v.name, v.location, v.city, v.capacity, v.price_per_guest, vt.type_name
+FROM venue v
+JOIN venue_type vt ON v.type_id = vt.type_id
+ORDER BY v.city, v.name;
+}}}
+
+3. The user selects a venue and clicks "Book".
+4. The system displays booking form: date, start_time, end_time, status, price.
+5. The user submits booking.
+6. The system inserts the booking into database.
+
+{{{
+SET search_path TO project;
+
+INSERT INTO venue_booking("date", start_time, end_time, status, price, venue_id, wedding_id)
+VALUES (:date, :start_time, :end_time, :status, :price, :venue_id, :wedding_id)
+RETURNING booking_id;
+}}}
+
+7. The system confirms booking and displays booked venue details.