源数据与目标数据的映射(2张无关联的表联查)

 

表1:源数据表

 DROP TABLE IF EXISTS `src_data_source`;
 CREATE TABLE `src_data_source`  (
   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键id‘,
   `name` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘‘ COMMENT ‘数据源名称‘,
   `source_type` tinyint(2) NOT NULL DEFAULT 0 COMMENT ‘数据源类型:1.MySQL,5.Oracle,10.达梦‘,
   `jdbc_url` varchar(500) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘‘ COMMENT ‘jdbc-url‘,
   `jdbc_user` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘‘ COMMENT ‘jdbc-user‘,
   `jdbc_pwd` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘‘ COMMENT ‘jdbc-pwd‘,
   `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT ‘‘ COMMENT ‘描述‘,
   `source_status` bit(1) NOT NULL DEFAULT b‘0‘ COMMENT ‘状态:0.false-停用,1.true-启用‘,
   `version` int(11) NULL DEFAULT NULL COMMENT ‘版本(乐观锁保留字段)‘,
   `create_time` datetime NULL DEFAULT NULL COMMENT ‘创建时间‘,
   `update_time` datetime NULL DEFAULT NULL COMMENT ‘修改时间‘,
   `create_user` bigint(20) NULL DEFAULT NULL COMMENT ‘创建人‘,
   `update_user` bigint(20) NULL DEFAULT NULL COMMENT ‘修改人‘,
   PRIMARY KEY (`id`) USING BTREE
 ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = ‘源数据源‘ ROW_FORMAT = Dynamic;
 ?
 -- ----------------------------
 -- Records of src_data_source
 -- ----------------------------
 INSERT INTO `src_data_source` VALUES (6, ‘腾讯云‘, 1, ‘jdbc:mysql://192.168.1.109:3306/dragon?autoReconnect=true&useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=CONVERT_TO_NULL&useSSL=false&serverTimezone=CTT‘, ‘root‘, ‘root‘, ‘wqeqw‘, b‘0‘, NULL, ‘2021-07-01 18:07:58‘, ‘2021-07-06 15:29:22‘, 1,
上一篇:自定义校验


下一篇:二三维GIS智慧环保应用平台