ALTER TABLE sup_task  ADD COLUMN files TEXT COMMENT '附件列表';

/*
 Navicat Premium Dump SQL

 Source Server         : 长沙公安数据督查
 Source Server Type    : MySQL
 Source Server Version : 80029 (8.0.29)
 Source Host           : 172.31.217.20:31868
 Source Schema         : negative

 Target Server Type    : MySQL
 Target Server Version : 80029 (8.0.29)
 File Encoding         : 65001

 Date: 22/07/2025 10:41:15
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for data_mailbox_blame_relation
-- ----------------------------
DROP TABLE IF EXISTS `data_mailbox_blame_relation`;
CREATE TABLE `data_mailbox_blame_relation` (
                                               `id` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8_general_ci NOT NULL,
                                               `origin_id` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '清单id',
                                               `blameId` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL COMMENT '关联涉及人',
                                               `oneLevelCode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
                                               `twoLevelCode` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
                                               `oneLevelContent` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
                                               `twoLevelContent` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8_general_ci DEFAULT NULL,
                                               `threeLevelCode` varchar(255) DEFAULT NULL,
                                               `threeLevelContent` varchar(255) DEFAULT NULL,
                                               `threeLevelContentOther` varchar(255) DEFAULT NULL,
                                               PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 ROW_FORMAT=DYNAMIC COMMENT='问题清单人员关联问题表';

SET FOREIGN_KEY_CHECKS = 1;


/*
 Navicat Premium Dump SQL

 Source Server         : 长沙公安数据督查
 Source Server Type    : MySQL
 Source Server Version : 80029 (8.0.29)
 Source Host           : 172.31.217.20:31868
 Source Schema         : negative

 Target Server Type    : MySQL
 Target Server Version : 80029 (8.0.29)
 File Encoding         : 65001

 Date: 22/07/2025 10:41:01
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for data_mailbox_blame
-- ----------------------------
DROP TABLE IF EXISTS `data_mailbox_blame`;
CREATE TABLE `data_mailbox_blame` (
                                      `id` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
                                      `origin_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
                                      `type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '涉及类型',
                                      `BlameEmpNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '涉及人员警号',
                                      `BlameIdCode` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '身份证',
                                      `BlameName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '姓名',
                                      `UpdTime` datetime DEFAULT NULL,
                                      `CrtTime` datetime DEFAULT NULL,
                                      `handleResultCode` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '处理结果code',
                                      `handleResultName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '处理结果',
                                      PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

SET FOREIGN_KEY_CHECKS = 1;


/*
 Navicat Premium Dump SQL

 Source Server         : 长沙公安数据督查
 Source Server Type    : MySQL
 Source Server Version : 80029 (8.0.29)
 Source Host           : 172.31.217.20:31868
 Source Schema         : negative

 Target Server Type    : MySQL
 Target Server Version : 80029 (8.0.29)
 File Encoding         : 65001

 Date: 22/07/2025 10:40:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for data_mailbox
-- ----------------------------
DROP TABLE IF EXISTS `data_mailbox`;
CREATE TABLE `data_mailbox` (
                                `origin_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'id',
                                `discoveryTime` datetime DEFAULT NULL COMMENT '问题发现时间',
                                `responderName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '反映人项目',
                                `contactPhone` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '联系电话',
                                `thingDesc` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '简要描述',
                                `businessTypeCode` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务类型',
                                `businessTypeName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '业务类别名称',
                                `checkStatus` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '核查情况',
                                `checkStatusName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '核查情况',
                                `checkStatusDesc` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '核查情况内容',
                                `processingStatus` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '办理状态',
                                `accountabilityTarget` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '转责对象',
                                `problemSources` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '问题来源',
                                `problemSourcesCode` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '问题来源code',
                                `crtTime` datetime DEFAULT NULL COMMENT '创建时间',
                                `involved_issue` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '涉及问题',
                                `handleSecondDepartName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
                                `handleThreeDepartName` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
                                PRIMARY KEY (`origin_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

SET FOREIGN_KEY_CHECKS = 1;


ALTER TABLE sup_task  ADD COLUMN supervise_require TEXT COMMENT '督察要求';