From 8cb5d3440208a3be3e772e65f1bd0ec63031ba62 Mon Sep 17 00:00:00 2001 From: wlzboy <66905212@qq.com> Date: 星期三, 17 十二月 2025 08:37:14 +0800 Subject: [PATCH] feat: 增加服务单派发通知 --- sql/sys_notify_send_log.sql | 19 +++++++++++-------- 1 files changed, 11 insertions(+), 8 deletions(-) diff --git a/sql/sys_notify_send_log.sql b/sql/sys_notify_send_log.sql index fa0f91b..3335ee4 100644 --- a/sql/sys_notify_send_log.sql +++ b/sql/sys_notify_send_log.sql @@ -3,33 +3,36 @@ -- 鐢ㄤ簬璁板綍鍚勭被閫氱煡娑堟伅鐨勫彂閫佽褰曪紝瀹炵幇闃查噸鏈哄埗 -- 纭繚鍚屼竴浠诲姟鍚屼竴浜哄悓涓�閫氱煡绫诲瀷鍙彂閫佷竴娆� -- =========================================== - DROP TABLE IF EXISTS `sys_notify_send_log`; CREATE TABLE `sys_notify_send_log` ( - `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID', - `task_id` bigint(20) NOT NULL COMMENT '浠诲姟ID', - `user_id` bigint(20) NOT NULL COMMENT '鎺ユ敹鐢ㄦ埛ID', + `id` bigint NOT NULL AUTO_INCREMENT COMMENT '涓婚敭ID', + `notify_task_id` bigint DEFAULT NULL COMMENT '鍏宠仈鐨勯�氱煡浠诲姟ID', + `task_id` bigint NOT NULL COMMENT '浠诲姟ID', + `user_id` bigint NOT NULL COMMENT '鎺ユ敹鐢ㄦ埛ID', `user_name` varchar(64) DEFAULT NULL COMMENT '鎺ユ敹鐢ㄦ埛濮撳悕', `notify_type` varchar(32) NOT NULL COMMENT '閫氱煡绫诲瀷锛歍ASK_ASSIGN-浠诲姟鍒嗛厤, STATUS_CHANGE-鐘舵�佸彉鏇�, TASK_CREATE-浠诲姟鍒涘缓', `channel` varchar(32) NOT NULL COMMENT '閫氱煡娓犻亾锛歐ECHAT-寰俊璁㈤槄娑堟伅, SMS-鐭俊, APP_PUSH-APP鎺ㄩ��, SITE_MSG-绔欏唴娑堟伅', + `send_content` text, `send_status` char(1) DEFAULT '0' COMMENT '鍙戦�佺姸鎬侊細0-寰呭彂閫�, 1-鍙戦�佹垚鍔�, 2-鍙戦�佸け璐�', `send_time` datetime DEFAULT NULL COMMENT '鍙戦�佹椂闂�', `send_result` varchar(500) DEFAULT NULL COMMENT '鍙戦�佺粨鏋�/閿欒淇℃伅', - `retry_count` int(11) DEFAULT 0 COMMENT '閲嶈瘯娆℃暟', + `retry_count` int DEFAULT '0' COMMENT '閲嶈瘯娆℃暟', `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿', `create_by` varchar(64) DEFAULT '' COMMENT '鍒涘缓鑰�', `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿', `update_by` varchar(64) DEFAULT '' COMMENT '鏇存柊鑰�', `remark` varchar(500) DEFAULT NULL COMMENT '澶囨敞', + `response_msg` text COMMENT '鍝嶅簲娑堟伅', PRIMARY KEY (`id`), - UNIQUE KEY `uk_task_user_type_channel` (`task_id`, `user_id`, `notify_type`, `channel`) COMMENT '鍚屼竴浠诲姟鍚屼竴鐢ㄦ埛鍚屼竴绫诲瀷鍚屼竴娓犻亾鍙兘鏈変竴鏉¤褰�', + UNIQUE KEY `uk_task_user_type_channel` (`task_id`,`user_id`,`notify_type`,`channel`) COMMENT '鍚屼竴浠诲姟鍚屼竴鐢ㄦ埛鍚屼竴绫诲瀷鍚屼竴娓犻亾鍙兘鏈変竴鏉¤褰�', KEY `idx_task_id` (`task_id`), KEY `idx_user_id` (`user_id`), KEY `idx_notify_type` (`notify_type`), KEY `idx_send_status` (`send_status`), - KEY `idx_create_time` (`create_time`) -) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='閫氱煡鍙戦�佽褰曡〃'; + KEY `idx_create_time` (`create_time`), + KEY `idx_notify_task_id` (`notify_task_id`) +) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='閫氱煡鍙戦�佽褰曡〃'; -- =========================================== -- 浣跨敤璇存槑锛� -- Gitblit v1.9.1