= 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).