From ca0565e53494417b3779759f8d3898e07bfd5929 Mon Sep 17 00:00:00 2001
From: liyong <18434998025@163.com>
Date: 星期二, 20 一月 2026 14:09:16 +0800
Subject: [PATCH] Merge remote-tracking branch 'refs/remotes/origin/jtwy' 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