From 5bf65a4d967c90b4ee51c8405ee9bef766530fd8 Mon Sep 17 00:00:00 2001
From: liu <2021943741@qq.com>
Date: 星期五, 16 十月 2026 18:00:36 +0800
Subject: [PATCH] feat(mdm): 计量单位新增重量字段
---
docs/sql/mdm_schema.sql | 8 ++++++++
1 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/docs/sql/mdm_schema.sql b/docs/sql/mdm_schema.sql
index 0a6b5df..16bc41f 100644
--- a/docs/sql/mdm_schema.sql
+++ b/docs/sql/mdm_schema.sql
@@ -34,6 +34,8 @@
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '鍗曚綅缂栧彿',
`code` varchar(50) NOT NULL COMMENT '鍗曚綅缂栫爜',
`name` varchar(50) NOT NULL COMMENT '鍗曚綅鍚嶇О',
+ `type` varchar(20) DEFAULT NULL COMMENT '绫诲瀷锛�48鍗冨厠/100鍗冨厠/鍚級',
+ `weight` decimal(24,6) DEFAULT NULL COMMENT '閲嶉噺(kg)',
`primary_flag` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁涓诲崟浣�',
`primary_id` bigint DEFAULT NULL COMMENT '涓诲崟浣嶇紪鍙�',
`change_rate` decimal(24,6) DEFAULT 1.000000 COMMENT '涓庝富鍗曚綅鎹㈢畻姣斾緥',
@@ -80,6 +82,12 @@
`specification` varchar(200) DEFAULT NULL COMMENT '瑙勬牸鍨嬪彿',
`category_id` bigint DEFAULT NULL COMMENT '鐗╂枡鍒嗙被缂栧彿',
`unit_measure_id` bigint DEFAULT NULL COMMENT '璁￠噺鍗曚綅缂栧彿',
+ `unit_measure_id2` bigint DEFAULT NULL COMMENT '杈呭崟浣�1缂栧彿',
+ `unit_measure_rate1` decimal(24,6) DEFAULT NULL COMMENT '杈呭崟浣�1鎹㈢畻姣旂巼',
+ `unit_measure_id3` bigint DEFAULT NULL COMMENT '杈呭崟浣�2缂栧彿',
+ `unit_measure_rate2` decimal(24,6) DEFAULT NULL COMMENT '杈呭崟浣�2鎹㈢畻姣旂巼',
+ `warehouse_id` bigint DEFAULT NULL COMMENT '榛樿浠撳簱缂栧彿',
+ `warehouse_code` varchar(50) DEFAULT NULL COMMENT '榛樿浠撳簱缂栫爜',
`item_type` tinyint NOT NULL DEFAULT 1 COMMENT '鐗╂枡绫诲瀷锛�1:鐗╂枡 2:浜у搧 3:鍗婃垚鍝侊級',
`status` tinyint NOT NULL DEFAULT 0 COMMENT '鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�',
`purchase_price` decimal(24,2) DEFAULT NULL COMMENT '閲囪喘浠�',
--
Gitblit v1.9.3