Use-case 0009 - RSVP for Event

Initiating actor: Guest

Other actors: None

Description

An invited guest responds to an invitation for a specific wedding event (accepted/declined/pending). The RSVP is stored in the database for tracking.

Scenario

1. The guest opens the RSVP invitation.
2. The system displays event info and RSVP options.
3. The guest selects RSVP status and submits.
4. The system saves the RSVP response.

SET search_path TO project;

INSERT INTO event_rsvp(status, response_date, guest_id, event_id)
VALUES (:status, CURRENT_DATE, :guest_id, :event_id)
RETURNING response_id;

5. The system confirms RSVP and displays the selected status.

SET search_path TO project;

SELECT response_id, status, response_date
FROM event_rsvp
WHERE response_id = :response_id;