CREATE TABLE `ws_log` ( `flow_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流水号', `orig_domain` varchar(100) DEFAULT NULL COMMENT '应用域编码', `trans_ido` varchar(100) DEFAULT NULL COMMENT '交易流水号', `service_name` varchar(100) DEFAULT NULL COMMENT '服务名', `operate_name` varchar(100) DEFAULT NULL COMMENT '操作名', `action_code` varchar(1) DEFAULT NULL COMMENT '交易操作类型', `route_type` varchar(10) DEFAULT NULL COMMENT '路由类型', `route_value` varchar(100) DEFAULT NULL COMMENT '路由值', `process_time` datetime DEFAULT NULL COMMENT '处理时间', `cloblog` longtext DEFAULT NULL COMMENT '日志内容', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `busi_id` varchar(500) DEFAULT NULL, `rsp_code` varchar(10) DEFAULT NULL COMMENT '应答码', PRIMARY KEY (`flow_id`, `create_time`), KEY `auto_shard_key_flow_id` (`flow_id`) BLOCK_SIZE 16384 GLOBAL, KEY `trans_ido` (`trans_ido`, `operate_name`, `cloblog`(255), `create_time`, `rsp_code`) BLOCK_SIZE 16384 GLOBAL, KEY `ws_log_busi_id` (`busi_id`(255)) BLOCK_SIZE 16384 GLOBAL, KEY `ws_log_create_time` (`create_time`) BLOCK_SIZE 16384 GLOBAL, KEY `ws_log_operate_name` (`operate_name`) BLOCK_SIZE 16384 GLOBAL, KEY `ws_log_trans_ido` (`trans_ido`) BLOCK_SIZE 16384 GLOBAL ) AUTO_INCREMENT = 2007060604000144 DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.0' REPLICA_NUM = 3 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 10 COMMENT = '记录接口日志'