From 784f2aa43bf07122474628cd8165e6d404fb42a3 Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期四, 02 七月 2026 10:21:29 +0800
Subject: [PATCH] 产品添加辅料单位和比率
---
docs/sql/mdm_schema.sql | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/docs/sql/mdm_schema.sql b/docs/sql/mdm_schema.sql
index 0a6b5df..058def5 100644
--- a/docs/sql/mdm_schema.sql
+++ b/docs/sql/mdm_schema.sql
@@ -80,6 +80,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