Changes between Initial Version and Version 1 of View6

Timestamp:

08/21/26 08:58:11 (26 hours ago)

Author:

235018

Comment:

--

View6

@@ +1 @@
+= Store inventory overview
+
+=== Description
+This view provides an overview of the current inventory of every store, including the products sold, their prices, available quantities, discounts, and product information.
+
+The view is intended for:
+
+- inventory management
+- monitoring product availability
+- store management
+- identifying products with low stock
+
+==== Tables covered by the view:
+
+- Product
+- Store
+- sells
+
+==== SQL код
+{{{#!sql
+CREATE OR REPLACE VIEW vw_store_inventory AS
+SELECT
+    s.store_id,
+    s.name AS store_name,
+
+    p.code AS product_code,
+    p.description,
+    p.price,
+    p.availability,
+    p.approx_production_time,
+
+    sl.quantity,
+    sl.discount
+
+FROM store s
+JOIN sells sl
+    ON sl.store_id = s.store_id
+JOIN product p
+    ON p.code = sl.code;
+
+}}}
+
+==== Logic explanation
+**1.** The `store` table provides store information.
+
+**2.** The `sells` relationship connects stores with the products they sell.
+
+**3.** The `product` table provides product details.
+
+**4.** The quantity and discount are retrieved from `sells`.
+
+**5.** Each row represents a product being sold by a particular store.
+
+==== Reason for view 
+This view is useful because:
+
+- It provides a centralized inventory overview
+- It allows stores to monitor available products
+- It simplifies stock-related queries
+- It allows products and their quantities to be easily compared between stores
+- It can be used to identify products with low availability
+
+Without this view, inventory queries would repeatedly need to join store, sells, and product, increasing the complexity of the application.