wiki:UseCase0003

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

--

Use-case 0003 - Create Wedding

Initiating actor: Bride / Groom (Wedding owner)

Other actors: None

Description

The registered user creates a new wedding plan by defining the wedding date, budget and notes. Each wedding is connected to exactly one user (owner).

Scenario

  1. The user opens the "Create Wedding" option from the dashboard.
  2. The system displays a form: wedding date, budget, notes.
  3. The user enters the wedding information and submits.
  4. The system inserts the new wedding in the database.
SET search_path TO project;

INSERT INTO wedding("date", budget, notes, user_id)
VALUES (:date, :budget, :notes, :user_id)
RETURNING wedding_id;
  1. The system confirms creation and shows the created wedding details.
SET search_path TO project;

SELECT wedding_id, "date", budget, notes
FROM wedding
WHERE wedding_id = :wedding_id;
Note: See TracWiki for help on using the wiki.