Changes between Initial Version and Version 1 of UseCase0009


Ignore:
Timestamp:
01/10/26 18:02:30 (10 days ago)
Author:
193284
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UseCase0009

    v1 v1  
     1= Use-case 0009 - RSVP for Event =
     2
     3'''Initiating actor:''' Guest
     4
     5'''Other actors:''' None
     6
     7== Description ==
     8An invited guest responds to an invitation for a specific wedding event (accepted/declined/pending). The RSVP is stored in the database for tracking.
     9
     10== Scenario ==
     111. The guest opens the RSVP invitation.
     122. The system displays event info and RSVP options.
     133. The guest selects RSVP status and submits.
     144. The system saves the RSVP response.
     15
     16{{{
     17SET search_path TO project;
     18
     19INSERT INTO event_rsvp(status, response_date, guest_id, event_id)
     20VALUES (:status, CURRENT_DATE, :guest_id, :event_id)
     21RETURNING response_id;
     22}}}
     23
     245. The system confirms RSVP and displays the selected status.
     25
     26{{{
     27SET search_path TO project;
     28
     29SELECT response_id, status, response_date
     30FROM event_rsvp
     31WHERE response_id = :response_id;
     32}}}