Changes between Initial Version and Version 1 of UseCase05


Ignore:
Timestamp:
01/24/26 13:23:06 (2 weeks ago)
Author:
231035
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • UseCase05

    v1 v1  
     1= UseCase05 - Create a Listing
     2** Initiating actor: Owner **
     3== Description
     4An owner creates a listing for an animal they own. After creation, the system shows the created listing.
     5== Scenario
     61. Owner opens "My Animals" page.
     7{{{
     8SELECT
     9  a.animal_id,
     10  a.name,
     11  a.sex,
     12  a.date_of_birth,
     13  a.type,
     14  a.species,
     15  a.breed,
     16  a.located_name
     17FROM animals a
     18WHERE a.owner_id = $1
     19ORDER BY a.animal_id DESC;
     20}}}
     212. Owner clicks on a specific animal and clicks "Create Listing".
     223. Owner enters listing information and submits it.
     234. System creates the lisitng.
     24{{{
     25INSERT INTO listings (owner_id, animal_id, status, price, description, created_at)
     26VALUES ($1, $2, 'ACTIVE', $3, $4, NOW())
     27RETURNING listing_id;
     28}}}
     29
     30
     31
     32
     33