日志表结构
CREATE TABLE `internal_api_log` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`log_type` varchar(20) NOT NULL COMMENT 'send/receive/callback/error',
`source` varchar(10) NOT NULL COMMENT '来源站点编号',
`target` varchar(10) NOT NULL COMMENT '目标站点编号',
`action` varchar(50) NOT NULL COMMENT '指令action',
`request_data` text COMMENT '请求数据JSON',
`response_data` text COMMENT '响应数据JSON',
`http_code` int(11) DEFAULT '0',
`status` varchar(20) DEFAULT 'success' COMMENT 'success/fail/timeout',
`error_msg` text COMMENT '错误信息',
`created_at` datetime DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `idx_log_type` (`log_type`),
KEY `idx_source` (`source`),
KEY `idx_target` (`target`),
KEY `idx_action` (`action`),
KEY `idx_status` (`status`),
KEY `idx_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='内部API通信日志';