wiki:UseCase0005

Version 1 (modified by 193284, 10 days ago) ( diff )

--

Use-case 0005 - Create Wedding Events

Initiating actor: Bride / Groom (Wedding owner)

Other actors: Wedding Organizer (Assistant)

Description

The user creates schedule events for the wedding, such as a church ceremony, reception or party. Each event belongs to a wedding and contains date/time information and status.

Scenario

  1. The user opens the wedding timeline/events section.
  2. The system lists existing events for the wedding.
SET search_path TO project;

SELECT event_id, event_type, "date", start_time, end_time, status
FROM event
WHERE wedding_id = :wedding_id
ORDER BY "date", start_time;
  1. The user selects "Add Event".
  2. The system displays a form: event_type, date, start_time, end_time, status.
  3. The user submits event data.
  4. The system inserts the event into the database.
SET search_path TO project;

INSERT INTO event(event_type, "date", start_time, end_time, status, wedding_id)
VALUES (:event_type, :date, :start_time, :end_time, :status, :wedding_id)
RETURNING event_id;
  1. The system confirms and shows the event list updated.
Note: See TracWiki for help on using the wiki.