= Use-case 0004 - Manage Guest List (Add / View Guests) = '''Initiating actor:''' Bride / Groom (Wedding owner) '''Other actors:''' None == Description == The 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. == Scenario == 1. The user selects a wedding. 2. The system shows the guest list for the selected wedding. {{{ SET search_path TO project; SELECT guest_id, first_name, last_name, email FROM guest WHERE wedding_id = :wedding_id ORDER BY last_name, first_name; }}} 3. The user clicks "Add Guest". 4. The system displays a form: first name, last name, email. 5. The user submits guest information. 6. The system inserts the guest into the database. {{{ SET search_path TO project; INSERT INTO guest(first_name, last_name, email, wedding_id) VALUES (:first_name, :last_name, :email, :wedding_id) RETURNING guest_id; }}} 7. The system refreshes and shows the updated list of guests.