Changes between Initial Version and Version 1 of UseCase0004


Ignore:
Timestamp:
01/10/26 18:00:49 (10 days ago)
Author:
193284
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UseCase0004

    v1 v1  
     1= Use-case 0004 - Manage Guest List (Add / View Guests) =
     2
     3'''Initiating actor:''' Bride / Groom (Wedding owner)
     4
     5'''Other actors:''' None
     6
     7== Description ==
     8The wedding owner manages the guest list by adding guests and viewing existing guests for a specific wedding. Guests are stored in the database and linked to the wedding.
     9
     10== Scenario ==
     111. The user selects a wedding.
     122. The system shows the guest list for the selected wedding.
     13
     14{{{
     15SET search_path TO project;
     16
     17SELECT guest_id, first_name, last_name, email
     18FROM guest
     19WHERE wedding_id = :wedding_id
     20ORDER BY last_name, first_name;
     21}}}
     22
     233. The user clicks "Add Guest".
     244. The system displays a form: first name, last name, email.
     255. The user submits guest information.
     266. The system inserts the guest into the database.
     27
     28{{{
     29SET search_path TO project;
     30
     31INSERT INTO guest(first_name, last_name, email, wedding_id)
     32VALUES (:first_name, :last_name, :email, :wedding_id)
     33RETURNING guest_id;
     34}}}
     35
     367. The system refreshes and shows the updated list of guests.