From a08dce3de307ce138396db5fe7274ead2ef5c573 Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期二, 20 一月 2026 17:12:08 +0800
Subject: [PATCH] Merge branch 'jtwy' of http://114.132.189.42:9002/r/product-inventory-management-after into sqd-hb

---
 doc/create_table_product_structure.sql |   16 ++++++++++++++++
 1 files changed, 16 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..83af495
--- /dev/null
+++ b/doc/create_table_product_structure.sql
@@ -0,0 +1,16 @@
+# 浜у搧缁撴瀯
+drop table if exists product_structure;
+create table product_structure
+(
+    id                 bigint auto_increment
+        primary key,
+    product_model_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'
+);
+alter table product_structure
+    add parent_id bigint null comment '鐖秈d';

--
Gitblit v1.9.3