From 6ad5c2cdc193cf7bb02884961b7434cd7f607a0d Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期四, 16 四月 2026 10:48:09 +0800
Subject: [PATCH] feat(production): 扩展生产工艺路线支持多产品绑定及工单权限控制
---
doc/create_table_process_route.sql | 5 ++++-
1 files changed, 4 insertions(+), 1 deletions(-)
diff --git a/doc/create_table_process_route.sql b/doc/create_table_process_route.sql
index 9bc08ec..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,
- product_id bigint not null default 0 comment '浜у搧id',
+ 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