merchant

commit 8f84f6576471c94b16624c44e1b46356e2353268
parent 701840852505bebf4af0e0debe607fe41db62d29
Author: Christian Grothoff <grothoff@gnunet.org>
Date:   Wed, 19 Mar 2025 04:32:03 +0100

improve comments on merchant schema

Diffstat:
M
src/backenddb/merchant-0001.sql
 | 
2
+-
M
src/backenddb/merchant-0006.sql
 | 
4
++++

2 files changed, 5 insertions(+), 1 deletion(-)
diff --git a/src/backenddb/merchant-0001.sql b/src/backenddb/merchant-0001.sql
@@ -451,7 +451,7 @@ CREATE TABLE IF NOT EXISTS merchant_refunds
   ,refund_amount taler_amount_currency NOT NULL
   ,UNIQUE (order_serial, coin_pub, rtransaction_id)
   );
-COMMENT ON TABLE merchant_deposits
+COMMENT ON TABLE merchant_refunds
   IS 'Refunds approved by the merchant (backoffice) logic, excludes abort refunds';
 COMMENT ON COLUMN merchant_refunds.rtransaction_id
   IS 'Needed for uniqueness in case a refund is increased for the same order';
diff --git a/src/backenddb/merchant-0006.sql b/src/backenddb/merchant-0006.sql
@@ -37,6 +37,8 @@ CREATE TABLE IF NOT EXISTS merchant_categories
   ,category_name_i18n BYTEA NOT NULL
   );
 
+COMMENT ON TABLE merchant_categories
+  IS 'product categories (with translations) to group products from inventory (primarily for the point-of-sale app)';
 COMMENT ON COLUMN merchant_categories.category_name
   IS 'name of the category';
 COMMENT ON COLUMN merchant_categories.category_name_i18n
@@ -52,6 +54,8 @@ CREATE INDEX merchant_categories_by_category
 CREATE INDEX merchant_categories_by_product
   ON merchant_product_categories (product_serial);
 
+COMMENT ON TABLE merchant_product_categories
+  IS 'N:M map from products to categories (a product can be in any number of categories, including zero)';
 COMMENT ON COLUMN merchant_product_categories.category_serial
   IS 'Reference to a category the product is part of';
 COMMENT ON COLUMN merchant_product_categories.product_serial