表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;
?