kknongchang_2506/app/Module/OpenAPI/Databases/GenerateSql/openapi_logs.sql

-- ******************************************************************
-- 表 kku_openapi_logs 的创建SQL
-- 对应的Model: App\Module\OpenAPI\Models\OpenApiLog
-- 警告: 此文件由系统自动生成，禁止修改！
-- ******************************************************************

CREATE TABLE `kku_openapi_logs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `app_id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '应用ID',
  `request_id` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '请求ID',
  `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '请求方法',
  `uri` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '请求路径',
  `headers` json DEFAULT NULL COMMENT '请求头',
  `query_params` json DEFAULT NULL COMMENT '查询参数',
  `body` text COLLATE utf8mb4_unicode_ci COMMENT '请求体',
  `response_status` int NOT NULL DEFAULT '0' COMMENT '响应状态码',
  `response_headers` json DEFAULT NULL COMMENT '响应头',
  `response_body` text COLLATE utf8mb4_unicode_ci COMMENT '响应体',
  `response_time` int NOT NULL DEFAULT '0' COMMENT '响应时间(毫秒)',
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'IP地址',
  `user_agent` text COLLATE utf8mb4_unicode_ci COMMENT 'User Agent',
  `error_message` text COLLATE utf8mb4_unicode_ci COMMENT '错误信息',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_app_id` (`app_id`),
  KEY `idx_request_id` (`request_id`),
  KEY `idx_method` (`method`),
  KEY `idx_response_status` (`response_status`),
  KEY `idx_response_time` (`response_time`),
  KEY `idx_ip_address` (`ip_address`),
  KEY `idx_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='API调用日志表';