24 lines
1.2 KiB
SQL
24 lines
1.2 KiB
SQL
--
|
|
-- Table structure for table `trace_data`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `trace_data`;
|
|
CREATE TABLE `trace_data` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`task_id` int NOT NULL COMMENT '跟踪任务ID',
|
|
`imsi` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
|
|
`msisdn` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '',
|
|
`src_addr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '源地址带端口',
|
|
`dst_addr` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '目标地址带端口',
|
|
`if_type` int DEFAULT NULL COMMENT '接口类型，未分类',
|
|
`msg_type` int DEFAULT NULL,
|
|
`msg_direct` int DEFAULT NULL,
|
|
`length` int DEFAULT NULL COMMENT '去除头后的原始数据byte长度',
|
|
`timestamp` bigint DEFAULT '0' COMMENT '毫秒',
|
|
`raw_msg` text COLLATE utf8mb4_general_ci COMMENT '去除头后的原始数据byteBase64',
|
|
`dec_msg` text COLLATE utf8mb4_general_ci COMMENT 'TCP内容消息',
|
|
PRIMARY KEY (`id`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='跟踪_任务数据';
|
|
|
|
-- Dump completed on 2024-09-19 14:26:59
|