From a383e7dbc619cdb468979d4863349c43550a9af2 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期四, 16 四月 2026 11:33:13 +0800
Subject: [PATCH] feat(production): 扩展生产工艺路线支持多产品绑定及工单权限控制

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

diff --git a/doc/create_table_process_route.sql b/doc/create_table_process_route.sql
index 4a453f8..c58dedb 100644
--- a/doc/create_table_process_route.sql
+++ b/doc/create_table_process_route.sql
@@ -3,7 +3,10 @@
 create table process_route
 (
     id          bigint auto_increment primary key,
+    bom_id      bigint   not null default 0 comment 'BOMid',
     product_model_id  bigint       not null default 0 comment '浜у搧id',
+    process_route_code varchar(255) not null default '' comment '宸ヨ壓璺嚎缂栧彿',
+    product_model_ids varchar(1024) null comment '澶氫骇鍝乮d锛岄�楀彿鍒嗛殧',
     description varchar(255) not null default '' comment '鎻忚堪',
     tenant_id   bigint       not null comment '绉熸埛id',
     create_time datetime     null comment '褰曞叆鏃堕棿',

--
Gitblit v1.9.3