integrate_source 数据源表 ========================================= 字段 ------------------ +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | 列名 | 类型 | 是否非空 | 默认值 | 备注 | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | id | int | not null | null | 数据源自增 ID | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | name | varchar(100) | -- | null | 数据源名称 | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | creator_id | varchar(255) | -- | null | 数据源创建用户 id | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | source_type | smallint | -- | null | 数据源类型:0->ftp,1->mysql,2->postges,3->Oracle,4->hdfs,5->kudu 待扩展 | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | connection_url | varchar(130) | -- | null | 连接信息 | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | connection_port | int | -- | null | 连接端口 | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | connection_sid | varchar(100) | -- | null | sid | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | connection_user | varchar(100) | -- | null | 连接用户名 | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | connection_password | varchar(100) | -- | null | 连接密码 | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | createtime | long | -- | null | 创建时间 | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | status | smallint | -- | null | 状态。 0-停用,1-正常 | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ | remark | varchar(200) | -- | null | 备注 | +---------------------+--------------+----------+--------+-------------------------------------------------------------------------+ 索引 ------------------ +------+----------+------+ | 字段 | 唯一索引 | 备注 | +------+----------+------+ | 无 | | | +------+----------+------+ 说明 ------------------ 建表语句 ------------------ CREATE TABLE `integrate_source` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT '', `creator_id` varchar(255) DEFAULT '', `source_type` smallint(6) DEFAULT NULL, `connection_url` varchar(130) DEFAULT NULL, `connection_port` int(11) DEFAULT NULL, `connection_sid` varchar(100) DEFAULT NULL, `connection_user` varchar(100) DEFAULT NULL, `connection_password` varchar(100) DEFAULT NULL, `createtime` bigint(20) DEFAULT NULL, `status` smallint(6) DEFAULT NULL, `remark` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;