From 4913f563537f78215b7512fad7f41ef971bc3e97 Mon Sep 17 00:00:00 2001 From: Christian Grothoff Date: Mon, 20 Apr 2020 22:15:25 +0200 Subject: work on /products and /instances C API --- src/backenddb/merchant-0001.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'src/backenddb/merchant-0001.sql') diff --git a/src/backenddb/merchant-0001.sql b/src/backenddb/merchant-0001.sql index ad39e793..2c867b34 100644 --- a/src/backenddb/merchant-0001.sql +++ b/src/backenddb/merchant-0001.sql @@ -154,7 +154,7 @@ COMMENT ON COLUMN merchant_inventory.total_stock COMMENT ON COLUMN merchant_inventory.total_sold IS 'Number of products sold, must be below total_stock, non-negative, may never be lowered'; COMMENT ON COLUMN merchant_inventory.total_lost - IS 'Number of products that used to be in stock but were lost (spoiled, damaged), may never be lowered'; + IS 'Number of products that used to be in stock but were lost (spoiled, damaged), may never be lowered; total_stock >= total_sold + total_lost must always hold'; COMMENT ON COLUMN merchant_inventory.address IS 'JSON formatted Location of where the product is stocked'; COMMENT ON COLUMN merchant_inventory.next_restock @@ -174,7 +174,7 @@ CREATE INDEX IF NOT EXISTS merchant_inventory_locks_by_expiration ON merchant_inventory_locks (expiration); COMMENT ON TABLE merchant_inventory_locks - IS 'locks on inventory helt by shopping carts'; + IS 'locks on inventory helt by shopping carts; note that locks MAY not be honored if merchants increase total_lost for inventory'; COMMENT ON COLUMN merchant_inventory_locks.total_locked IS 'how many units of the product does this lock reserve'; COMMENT ON COLUMN merchant_inventory_locks.expiration @@ -215,7 +215,7 @@ CREATE INDEX IF NOT EXISTS merchant_orders_locks_by_order_and_product ON merchant_order_locks (order_serial, product_serial); COMMENT ON TABLE merchant_order_locks - IS 'locks on orders awaiting claim and payment'; + IS 'locks on orders awaiting claim and payment; note that locks MAY not be honored if merchants increase total_lost for inventory'; COMMENT ON COLUMN merchant_order_locks.total_locked IS 'how many units of the product does this lock reserve'; -- cgit v1.2.3