-- MySQL dump 10.13 Distrib 8.0.43, for Linux (x86_64) -- -- Host: localhost Database: log -- ------------------------------------------------------ -- Server version 8.0.43 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `log` -- CREATE DATABASE /*!32312 IF NOT EXISTS*/ `log` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */ /*!80016 DEFAULT ENCRYPTION='N' */; USE `log`; -- -- Table structure for table `operation_log` -- DROP TABLE IF EXISTS `operation_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `operation_log` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增id', `trace_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '全链路串联ID', `parent_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '父子调用层级ID', `op_time` datetime(3) DEFAULT NULL COMMENT '操作时间(毫秒)', `project` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '端/服务:operate/front/tl-control...', `module` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '功能模块(可读):对焦/串口/患者...', `operation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '操作(可读):一键标定/打开端口...', `operator` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '谁:登录用户/工程师/系统/设备SN', `input` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '输入(JSON;大对象只存文件名/关键字段)', `output` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '输出(JSON;同上)', `result` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '结果:成功/失败', `error` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '报错:消息+堆栈摘要', `elapsed_ms` bigint DEFAULT NULL COMMENT '耗时(ms)', `level` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '级别(操作级默认)', `house_sn` int DEFAULT NULL COMMENT '仓室号(便于按舱过滤)', `well_sn` int DEFAULT NULL COMMENT 'well号', `tl_sn` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '设备SN', `host` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '来源主机/IP', `create_time` datetime(3) DEFAULT NULL COMMENT '入库时间', PRIMARY KEY (`id`) USING BTREE, KEY `idx_trace` (`trace_id`) USING BTREE COMMENT '按trace_id拉链路/join system_log', KEY `idx_query` (`project`,`module`,`op_time`) USING BTREE COMMENT '按项目>模块>时间查询', KEY `idx_device` (`tl_sn`,`house_sn`,`op_time`) USING BTREE COMMENT '按设备/舱查询', KEY `idx_optime` (`op_time`) USING BTREE COMMENT '保留期清理用' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='全量操作日志(操作审计);与system_log经trace_id关联'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `operation_log` -- LOCK TABLES `operation_log` WRITE; /*!40000 ALTER TABLE `operation_log` DISABLE KEYS */; /*!40000 ALTER TABLE `operation_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `system_log` -- DROP TABLE IF EXISTS `system_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `system_log` ( `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id', `level_string` varchar(254) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '等级', `trace_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '链路id', `message` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '详情', `logger_name` varchar(254) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '名称', `thread_name` varchar(254) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '线程名', `caller_filename` varchar(254) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '文件名', `caller_class` varchar(254) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '类', `caller_method` varchar(254) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '方法', `caller_line` char(4) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '行数', `exception_message` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT '异常信息', `create_by` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL COMMENT '创建时间', `update_by` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '修改人', `update_time` datetime NOT NULL COMMENT '修改时间', `deleted` timestamp NOT NULL COMMENT '已删除: 操作时间戳', PRIMARY KEY (`id`) USING BTREE, KEY `trace_id` (`trace_id`) USING BTREE, KEY `create_time` (`create_time`) USING BTREE, KEY `update_time` (`update_time`) USING BTREE, KEY `deleted` (`deleted`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='系统日志'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `system_log` -- LOCK TABLES `system_log` WRITE; /*!40000 ALTER TABLE `system_log` DISABLE KEYS */; /*!40000 ALTER TABLE `system_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping routines for database 'log' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2026-06-27 20:13:59