From 1d915922d8197aa5d5dc3e40e3088d983dd6e141 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期五, 13 三月 2026 17:57:59 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/dev_New_kthg' into dev_New_kthg

---
 doc/20260313_坤泰化工.sql |   27 +++++++++++++++++++++++++++
 1 files changed, 27 insertions(+), 0 deletions(-)

diff --git "a/doc/20260313_\345\235\244\346\263\260\345\214\226\345\267\245.sql" "b/doc/20260313_\345\235\244\346\263\260\345\214\226\345\267\245.sql"
new file mode 100644
index 0000000..3cfe25b
--- /dev/null
+++ "b/doc/20260313_\345\235\244\346\263\260\345\214\226\345\267\245.sql"
@@ -0,0 +1,27 @@
+#鍘熸枡琛�
+drop table if exists raw_material;
+create table raw_material
+(
+    id               bigint auto_increment primary key,
+    product_model_id bigint not null default 0 comment '浜у搧鍨嬪彿id',
+    batch_no         varchar(255) null comment '鎵规鍙�',
+    check_type       tinyint null comment '妫�楠岀被鍨� 0鍏ュ満妫� 1杞﹂棿妫� 2鍑哄巶妫�',
+    check_result     tinyint null comment '妫�楠岀粨鏋� 0鍚堟牸 1涓嶅悎鏍�',
+    inspect_state    tinyint null comment '绫诲埆(0:鏈彁浜�;1:宸叉彁浜�)',
+    check_user_name  varchar(255) null comment '妫�楠屽憳鍚嶇О',
+    check_time       date null comment '妫�楠屾棩鏈�',
+    create_time      datetime null comment '褰曞叆鏃堕棿',
+    update_time      datetime null comment '鏇存柊鏃堕棿',
+    index            idx_product_model_id (product_model_id)
+);
+
+drop table if exists raw_material_quality_inspect_item;
+create table raw_material_quality_inspect_item
+(
+    id                      bigint auto_increment primary key,
+    raw_material_id         bigint not null default 0 comment '鍘熸枡id',
+    quality_inspect_item_id bigint not null default 0 comment '璐ㄩ噺妫�楠岄」id',
+    create_time             datetime null comment '褰曞叆鏃堕棿',
+    update_time             datetime null comment '鏇存柊鏃堕棿',
+    unique idx_raw_material_id_quality_inspect_item_id (raw_material_id, quality_inspect_item_id)
+);

--
Gitblit v1.9.3