SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_dq_rule_def
-- ----------------------------
DROP TABLE IF EXISTS `t_dq_rule_def`;
CREATE TABLE `t_dq_rule_def` (
`RULE_ID` varchar(240) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '规则ID',
`RULE_NAME` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则名称',
`RULE_DESCRIPTION` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则描述',
`TYPE_NAME` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则类型',
`TYPE_DESCRIPTION` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '规则类型描述（业务角度）',
`CATALOG_ID_1` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据源系统ID',
`CATALOG_ID_2` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '源数据分类ID',
`table_NAME` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '稽核的表/接口',
`COLUMN_NAME` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '稽核的字段属性',
`DATA_CYCLE` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '稽核周期',
PRIMARY KEY (`RULE_ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of t_dq_rule_def
-- ----------------------------
INSERT INTO `t_dq_rule_def` VALUES ('1', '业务电脑需求', NULL, '一致性', '姓名格式不合法', '1', '2', '业务电路信息', '客户ID', '周');
INSERT INTO `t_dq_rule_def` VALUES ('10', NULL, NULL, NULL, NULL, '10', NULL, NULL, NULL, '');
INSERT INTO `t_dq_rule_def` VALUES ('11', '脑需求', NULL, '不相同', '不合法', '1', '2', '业务电路信息', '客户ID', '周');
INSERT INTO `t_dq_rule_def` VALUES ('12', '需求', NULL, '不同', '格式不合法', '1', '2', '业务电路信息', '客户ID', '周');
INSERT INTO `t_dq_rule_def` VALUES ('13', '资源管理需求', NULL, '一致性', '姓名格式不合法', '1', '2', '业务电路信息', '客户ID', '周');
INSERT INTO `t_dq_rule_def` VALUES ('14', '电脑需求', NULL, '相', '姓名', '1', '2', '业务电路信息', '客户ID', '周');
INSERT INTO `t_dq_rule_def` VALUES ('15', '资源', NULL, '好一致', '好合法', '1', '6', '业务电路信息', '客户ID', '周');
INSERT INTO `t_dq_rule_def` VALUES ('2', 'ashdfjas', '', '周', '周', '1', '2', '发射口', '客户ID', '周');
INSERT INTO `t_dq_rule_def` VALUES ('3', '业务电', NULL, '一性', '姓合法', '1', '5', '业务电路信息', '客户ID', '周');
INSERT INTO `t_dq_rule_def` VALUES ('4', '业务电脑', NULL, '致性', '姓不合法', '1', '4', '业务电路信息', '客户ID', '周');
INSERT INTO `t_dq_rule_def` VALUES ('5', '业务电脑需', NULL, '相同性', '姓式不合法', '1', '4', '业务电路信息', '客户ID', '周');
INSERT INTO `t_dq_rule_def` VALUES ('6', '电脑需', NULL, '相同', '式不合法', '1', '3', '业务电路信息', '客户ID', '周');
INSERT INTO `t_dq_rule_def` VALUES ('7', '脑需', NULL, '性', '合法', '1', '3', '业务电路信息', '客户ID', '周');
INSERT INTO `t_dq_rule_def` VALUES ('8', '', NULL, '', '', '1', '', '', '', NULL);
INSERT INTO `t_dq_rule_def` VALUES ('9', '', NULL, '', '', '7', '', '', '', NULL);
SET FOREIGN_KEY_CHECKS = 1;