dba-kit
(张天师)
5
» binlog-schema list -s fund-mysql fund_task db table
{
"result": true,
"msg": "",
"sources": [
{
"result": true,
"msg": "CREATE TABLE `table` ( `createtime` datetime DEFAULT CURRENT_TIMESTAMP, `updatetime` datetime DEFAULT CURRENT_TIMESTAMP, `fund_code` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '基金代码', `period` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '周期', `type_name` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '指标名称', `value` double DEFAULT NULL COMMENT '指标数值', `start_date` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '指标开始时间', `end_date` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '指标结束时间', PRIMARY KEY (`fund_code`,`period`,`type_name`) /*T![clustered_index] CLUSTERED */) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci /*T![placement] PLACEMENT POLICY=`on_ssd` */",
"source": "fund-mysql",
"worker": "dm-********-18262"
}
]
}
»