Use-case 0010 - View RSVP Status

Initiating actor: Bride / Groom (Wedding owner)

Other actors: Wedding Organizer (Assistant)

Description

The wedding owner views RSVP statuses for invited guests per event. This helps planning seating, catering and logistics.

Scenario

1. The user opens an event.
2. The system shows RSVP summary for that event.

SET search_path TO project;

SELECT g.first_name, g.last_name, g.email, r.status, r.response_date
FROM event_rsvp r
JOIN guest g ON r.guest_id = g.guest_id
WHERE r.event_id = :event_id
ORDER BY g.last_name, g.first_name;

3. The system groups results by RSVP status (accepted/declined/pending).
4. The user can export/print the RSVP list (optional).