diff options
author | Christian Grothoff <christian@grothoff.org> | 2020-04-20 22:15:25 +0200 |
---|---|---|
committer | Christian Grothoff <christian@grothoff.org> | 2020-04-20 22:15:25 +0200 |
commit | 4913f563537f78215b7512fad7f41ef971bc3e97 (patch) | |
tree | 6ea3211685029f63738a42f4dc2fc6574087a80e /src/backenddb/merchant-0001.sql | |
parent | a01d45c4f35aa5195af542cdc2244f4940667d21 (diff) | |
download | merchant-4913f563537f78215b7512fad7f41ef971bc3e97.tar.gz merchant-4913f563537f78215b7512fad7f41ef971bc3e97.tar.bz2 merchant-4913f563537f78215b7512fad7f41ef971bc3e97.zip |
work on /products and /instances C API
Diffstat (limited to 'src/backenddb/merchant-0001.sql')
-rw-r--r-- | src/backenddb/merchant-0001.sql | 6 |
1 files changed, 3 insertions, 3 deletions
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'; |