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_item.sql | 9 ++++++++-
1 files changed, 8 insertions(+), 1 deletions(-)
diff --git a/doc/create_table_process_route_item.sql b/doc/create_table_process_route_item.sql
index ea0a8a7..dae2614 100644
--- a/doc/create_table_process_route_item.sql
+++ b/doc/create_table_process_route_item.sql
@@ -5,7 +5,10 @@
id bigint auto_increment primary key,
route_id bigint not null default 0 comment '宸ヨ壓璺嚎id',
product_model_id bigint not null default 0 comment '浜у搧id',
+ product_model_ids varchar(1024) null comment '澶氫骇鍝乮d锛岄�楀彿鍒嗛殧',
+ drag_sort bigint not null default 0 comment '鎷栨嫿鎺掑簭',
process_id bigint not null default 0 comment '宸ュ簭id',
+ is_quality tinyint not null default 0 comment '鏄惁璐ㄦ 0 涓嶆槸 1 鏄�',
tenant_id bigint not null comment '绉熸埛id',
create_time datetime null comment '褰曞叆鏃堕棿',
update_time datetime null comment '鏇存柊鏃堕棿'
@@ -50,9 +53,13 @@
create_time datetime null comment '褰曞叆鏃堕棿',
update_time datetime null comment '鏇存柊鏃堕棿',
work_order_no varchar(255) not null default '' comment '宸ュ崟缂栧彿',
+ plan_start_time datetime null comment '璁″垝寮�濮嬫椂闂�',
+ plan_end_time datetime null comment '璁″垝缁撴潫鏃堕棿',
+ actual_start_time datetime null comment '瀹為檯寮�濮嬫椂闂�',
+ actual_end_time datetime null comment '瀹為檯缁撴潫鏃堕棿',
status int not null default 0 comment '鐘舵�� 1 寰呯‘璁� 2 寰呯敓浜� 3鐢熶骇涓� 4宸茬敓浜� ',
tenant_id bigint not null comment '绉熸埛id'
);
alter table product_process
- add salary_quota numeric(16,3) null comment '宸ヨ祫瀹氶';
\ No newline at end of file
+ add salary_quota numeric(16,3) null comment '宸ヨ祫瀹氶';
--
Gitblit v1.9.3