From a76bfe866c705285b737d593e8629a8be819b8f7 Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期二, 18 八月 2026 14:49:11 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/dev_business' into dev_business --- docs/sql/task_pause_record.sql | 20 ++++++++++++++++++++ 1 files changed, 20 insertions(+), 0 deletions(-) diff --git a/docs/sql/task_pause_record.sql b/docs/sql/task_pause_record.sql new file mode 100644 index 0000000..927afbb --- /dev/null +++ b/docs/sql/task_pause_record.sql @@ -0,0 +1,20 @@ +CREATE TABLE `mes_pro_task_pause_record` ( + `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + `task_id` bigint(20) NOT NULL COMMENT '浠诲姟缂栧彿', + `work_order_id` bigint(20) DEFAULT NULL COMMENT '宸ュ崟缂栧彿', + `workstation_id` bigint(20) DEFAULT NULL COMMENT '宸ヤ綔绔欑紪鍙�', + `reason` varchar(255) NOT NULL COMMENT '鍋滃伐鍘熷洜', + `pause_time` datetime NOT NULL COMMENT '鍋滃伐鏃堕棿', + `pause_user_id` bigint(20) NOT NULL COMMENT '鍋滃伐鎿嶄綔浜篒D', + `resume_time` datetime DEFAULT NULL COMMENT '澶嶅伐鏃堕棿', + `resume_user_id` bigint(20) DEFAULT NULL COMMENT '澶嶅伐鎿嶄綔浜篒D', + `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', + `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鍒涘缓鑰�', + `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '鏇存柊鑰�', + `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎', + `tenant_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '绉熸埛缂栧彿', + PRIMARY KEY (`id`) USING BTREE, + KEY `idx_task_id` (`task_id`) USING BTREE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='鐢熶骇浠诲姟鍋滃伐璁板綍琛�'; -- Gitblit v1.9.3