/*
Navicat Premium Data Transfer
Source Server : chenpeng
Source Server Type : MySQL
Source Server Version : 50723
Source Host : 192.168.12.103:3306
Source Schema : cmidata
Target Server Type : MySQL
Target Server Version : 50723
File Encoding : 65001
Date: 12/11/2018 20:12:07
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_dq_job_instances
-- ----------------------------
DROP TABLE IF EXISTS `t_dq_job_instances`;
CREATE TABLE `t_dq_job_instances` (
`JOB_INS_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '稽核结果ID',
`t_d_RULE_ID` varchar(240) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则ID',
`RULE_ID` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则ID，关联到规则表',
`DATA_TIME` datetime(0) NULL DEFAULT NULL COMMENT '稽核的数据时间（批次）',
`TOTAL_RECORD` bigint(20) NULL DEFAULT NULL COMMENT '稽核总记录数',
`BAD_RECORD` bigint(20) NULL DEFAULT NULL COMMENT '异常（错误）记录数',
`ERR_DATA_FILE_PATH` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '错误文件所在的路径',
`CREATE_TIME` datetime(0) NULL DEFAULT NULL COMMENT '结果生成时间（稽核任务跑完时间）',
PRIMARY KEY (`JOB_INS_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '稽核结果表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_dq_job_instances
-- ----------------------------
INSERT INTO `t_dq_job_instances` VALUES ('1', '', '1', '2018-11-21 10:44:59', 1000, 20, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('10', NULL, '10', '2018-11-12 14:50:58', 110, 5, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('11', '', '11', '2018-11-21 10:44:59', 105, 6, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('12', '', '12', '2018-11-21 10:44:59', 110, 7, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('13', '', '13', '2018-11-21 10:44:59', 120, 5, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('14', '', '14', '2018-11-21 10:44:59', 110, 5, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('15', NULL, '15', '2018-11-21 00:00:00', 0, 0, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('2', '', '2', '2018-11-21 10:44:59', 120, 4, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('3', NULL, '3', '2018-11-21 14:39:50', 110, 3, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('4', '', '4', '2018-11-21 10:44:59', 130, 5, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('5', '', '5', '2018-11-21 10:44:59', 105, 7, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('6', '', '6', '2018-11-21 10:44:59', 110, 3, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('7', '', '7', '2018-11-21 10:44:59', 129, 4, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('8', NULL, '8', '2018-11-21 14:41:58', 2149, 69, NULL, NULL);
INSERT INTO `t_dq_job_instances` VALUES ('9', NULL, '9', NULL, 0, 0, NULL, NULL);
SET FOREIGN_KEY_CHECKS = 1;