From 4fedbed9949c6160dcfa216d6660bd3c625f7bce Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期三, 25 六月 2025 11:49:55 +0800
Subject: [PATCH] 优化
---
main-business/src/main/resources/db/migration/postgresql/V20250611160300__create_table_sales_record.sql | 2 --
1 files changed, 0 insertions(+), 2 deletions(-)
diff --git a/main-business/src/main/resources/db/migration/postgresql/V20250611160300__create_table_sales_record.sql b/main-business/src/main/resources/db/migration/postgresql/V20250611160300__create_table_sales_record.sql
index 082816e..4f0fe0e 100644
--- a/main-business/src/main/resources/db/migration/postgresql/V20250611160300__create_table_sales_record.sql
+++ b/main-business/src/main/resources/db/migration/postgresql/V20250611160300__create_table_sales_record.sql
@@ -6,7 +6,6 @@
customer_id BIGINT, -- 瀹㈡埛id
customer VARCHAR(255) NOT NULL, -- 瀹㈡埛
coal_id VARCHAR(255) NOT NULL, -- 鐓ょ id
- coal VARCHAR(255) NOT NULL, -- 鐓ょ
price_including_tax DECIMAL(10, 2) NOT NULL, -- 鍗曚环锛堝惈绋庯級
inventory_quantity DECIMAL(10, 0) NOT NULL, -- 搴撳瓨鏁伴噺
unit VARCHAR(100) NOT NULL, -- 鍗曚綅
@@ -37,7 +36,6 @@
COMMENT ON COLUMN sales_record.sale_date IS '閿�鍞棩鏈�';
COMMENT ON COLUMN sales_record.customer IS '瀹㈡埛';
COMMENT ON COLUMN sales_record.customer_id IS '瀹㈡埛id';
-COMMENT ON COLUMN sales_record.coal IS '鐓ょ';
COMMENT ON COLUMN sales_record.coal_id IS '鐓ょid';
COMMENT ON COLUMN sales_record.unit IS '鍗曚綅';
COMMENT ON COLUMN sales_record.price_including_tax IS '鍗曚环锛堝惈绋庯級';
--
Gitblit v1.9.3