= UseCase05 - Create a Listing
** Initiating actor: Owner **
== Description
An owner creates a listing for an animal they own. After creation, the system shows the created listing.
== Scenario
1. Owner opens "My Animals" page.
{{{
SELECT
  a.animal_id,
  a.name,
  a.sex,
  a.date_of_birth,
  a.type,
  a.species,
  a.breed,
  a.located_name
FROM animals a
WHERE a.owner_id = $1
ORDER BY a.animal_id DESC;
}}}
2. Owner clicks on a specific animal and clicks "Create Listing".
3. Owner enters listing information and submits it.
4. System creates the lisitng.
{{{
INSERT INTO listings (owner_id, animal_id, status, price, description, created_at)
VALUES ($1, $2, 'ACTIVE', $3, $4, NOW())
RETURNING listing_id;
}}}