Changes between Initial Version and Version 1 of BrowseProducts

Timestamp:

12/30/25 16:06:08 (14 hours ago)

Author:

235018

Comment:

--

BrowseProducts

@@ +1 @@
+== Browse Products and Categories
+
+==== Actors: **Guest User / Registered User**
+
+**1.** The user opens the product catalog.
+
+**2.** The system retrieves product data from the database.
+{{{#!sql
+SELECT product.code, product.price, product.description, category.name AS category, store.name AS store FROM product
+JOIN category ON product.category_id = category.id
+JOIN store ON product.store_id = store.store_ID;
+
+}}}
+
+**3.** If the user is interested in a product, the system can provide more data about it.
+
+{{{#!sql
+SELECT product.code, product.price, product.description, category.name AS category, store.name AS store, image.image AS product_image, color.color AS product_color FROM product
+JOIN category ON product.category_id = category.id
+JOIN store ON product.store_id = store.store_ID
+JOIN image ON product.code = image.product_code
+JOIN color ON product.code = color.product_code
+WHERE product.code='00100001';
+
+}}}