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.