From ec26e9a878b9478b0851fe3a98d8cca564c05cc4 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期一, 05 一月 2026 18:02:25 +0800
Subject: [PATCH] 产品工单关联对应增删改查

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

diff --git a/doc/create_table_production_product_main.sql b/doc/create_table_production_product_main.sql
new file mode 100644
index 0000000..18fb92d
--- /dev/null
+++ b/doc/create_table_production_product_main.sql
@@ -0,0 +1,36 @@
+drop table if exists production_product_main;
+create table production_product_main
+(
+    id            bigint auto_increment
+        primary key,
+    product_no    varchar(255) not null comment '鎶ュ伐鍗曞彿',
+    user_id       bigint       not null comment '鎶ュ伐鐢ㄦ埛id',
+    work_order_id bigint       not null comment '宸ュ崟id',
+    status        int          not null comment '鐘舵�� 0 寰呮姤宸� 1 寰呯‘璁�',
+    create_time   datetime     null comment '褰曞叆鏃堕棿',
+    tenant_id          bigint         not null comment '绉熸埛id'
+);
+
+drop table if exists production_product_output;
+create table production_product_output
+(
+    id               bigint auto_increment
+        primary key,
+    product_main_id  bigint         not null comment '鎶ュ伐鍗昳d',
+    product_model_id bigint         not null comment '浜у搧id',
+    quantity         numeric(16, 4) not null comment '鏁伴噺',
+    create_time      datetime       null comment '褰曞叆鏃堕棿',
+    tenant_id          bigint         not null comment '绉熸埛id'
+);
+
+drop table if exists production_product_input;
+create table production_product_input
+(
+    id               bigint auto_increment
+        primary key,
+    product_main_id  bigint         not null comment '鎶ュ伐鍗昳d',
+    product_model_id bigint         not null comment '浜у搧id',
+    quantity         numeric(16, 4) not null comment '鏁伴噺',
+    create_time      datetime       null comment '褰曞叆鏃堕棿',
+    tenant_id          bigint         not null comment '绉熸埛id'
+)

--
Gitblit v1.9.3