Changes between Version 1 and Version 2 of UseCase05PrototypeImplementation


Ignore:
Timestamp:
02/07/26 20:50:00 (17 hours ago)
Author:
231035
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • UseCase05PrototypeImplementation

    v1 v2  
    55== Scenario
    661. Owner opens "My Animals" page.
     7[[Image(listing.png)]]
    78{{{
    89SELECT
    … …  
    1920ORDER BY a.animal_id DESC;
    2021}}}
    21 2. Owner clicks on a specific animal.
    22 {{{
    23 SELECT
    24   a.animal_id,
    25   a.owner_id,
    26   a.name,
    27   a.sex,
    28   a.date_of_birth,
    29   a.photo_url,
    30   a.type,
    31   a.species,
    32   a.breed,
    33   a.located_name
    34 FROM animals a
    35 WHERE a.animal_id = 2
    36   AND a.owner_id = (SELECT user_id FROM users WHERE username = 'client.mila');
    37 }}}
    38 3. Clicks on the "Create Listing" button.
    39 4. Owner enters listing information and submits it.
    40 5. System creates the lisitng.
     222. Clicks on the "Create Listing" button.
     233. Owner enters listing information and submits it.
     24[[Image(listing2.png)]]
     254. System creates the lisitng.
    4126{{{
    4227INSERT INTO listings (owner_id, animal_id, status, price, description, created_at)
    … …  
    5540RETURNING listing_id;
    5641}}}
     42[[Image(listing3.png)]]
    5743
    5844