From 7488018d52edaafcd4e541c5fdeada8dd2e47b11 Mon Sep 17 00:00:00 2001
From: chenhj <1263187585@qq.com>
Date: 星期一, 22 十二月 2025 16:49:18 +0800
Subject: [PATCH] Merge branch 'jtwy' of http://114.132.189.42:9002/r/product-inventory-management-after into jtwy

---
 doc/create_table_product_structure.sql |   14 ++++++++++++++
 1 files changed, 14 insertions(+), 0 deletions(-)

diff --git a/doc/create_table_product_structure.sql b/doc/create_table_product_structure.sql
new file mode 100644
index 0000000..253548d
--- /dev/null
+++ b/doc/create_table_product_structure.sql
@@ -0,0 +1,14 @@
+# 浜у搧缁撴瀯
+drop table if exists production_product_structure;
+create table product_structure
+(
+    id                 bigint auto_increment
+        primary key,
+    product_id         bigint         not null comment '浜у搧id',
+    process_id         bigint         not null comment '宸ュ簭id',
+    unit_quantity      numeric(16, 4) not null comment '鍗曚綅浜у嚭闇�瑕佹暟閲�',
+    demanded_quantity  numeric(16, 4) not null comment '闇�姹傛暟閲�',
+    unit               varchar(255)   not null comment '鍗曚綅',
+    disk_quantity      numeric(16, 4) not null comment '鐩樻暟閲�',
+    tenant_id          bigint         not null comment '绉熸埛id'
+);

--
Gitblit v1.9.3