服务实例表:m_service ========================== 字段 -------------------- +--------------+----------+------+--------+----------+--------+-----------------------------------+ | 列名 | 类型 | 长度 | 小数点 | 是否非空 | 默认值 | 备注 | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | id | bigint | 20 | 0 | Y | | 主键,自增 ID | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | name | int | 11 | 0 | Y | | 表 ID | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | data_name | varchar | 255 | 0 | N | | 数据名称(数据表) | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | service_type | varchar | 255 | 0 | N | | 服务类型 | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | data_type | varchar | 255 | 0 | N | | 数据类型 | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | biz_type | varchar | 255 | 0 | N | | 业务类型 | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | publish_type | varchar | 255 | 0 | N | | 发布类型 | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | ip | varchar | 255 | 0 | N | | kudu ip | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | port | int | 11 | 0 | N | | kudu port | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | user | varchar | 255 | 0 | N | | kudu user | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | path | varchar | 500 | 0 | N | | data file path | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | tags | varchar | 2000 | 0 | N | | 服务标签,逗号分隔 | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | description | varchar | 255 | 0 | N | | 服务描述 | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | update_time | datetime | 0 | 0 | N | | 更新时间 | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | status | int | 11 | 0 | N | | 服务状态,0-停止,1-正常,2,暂停 | +--------------+----------+------+--------+----------+--------+-----------------------------------+ | remark | varchar | 255 | 0 | N | | 服务备注 | +--------------+----------+------+--------+----------+--------+-----------------------------------+ DDL ------------ .. code:: CREATE TABLE `m_service` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `data_name` varchar(255) DEFAULT NULL, `service_type` varchar(255) DEFAULT NULL, `data_type` varchar(255) DEFAULT NULL, `biz_type` varchar(255) DEFAULT NULL, `publish_type` varchar(255) DEFAULT NULL, `ip` varchar(255) DEFAULT NULL, `port` int(255) DEFAULT NULL, `user` varchar(255) DEFAULT NULL, `path` varchar(255) DEFAULT NULL, `tags` varchar(500) DEFAULT NULL, `description` varchar(2000) DEFAULT NULL, `update_time` datetime DEFAULT NULL, `status` int(255) DEFAULT NULL, `remark` varchar(255) DEFAULT NULL, `data_json` text DEFAULT NULL, `cache_state` int(11) DEFAULT NULL, `cache_level` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=275 DEFAULT CHARSET=utf8;