25 lines
1.4 KiB
SQL
25 lines
1.4 KiB
SQL
--
|
||
-- Table structure for table `trace_task_hlr`
|
||
--
|
||
|
||
DROP TABLE IF EXISTS `trace_task_hlr`;
|
||
|
||
CREATE TABLE `trace_task_hlr` (
|
||
`id` int NOT NULL AUTO_INCREMENT,
|
||
`trace_id` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务编号',
|
||
`imsi` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'IMSI',
|
||
`msisdn` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT 'MSISDN',
|
||
`start_time` bigint DEFAULT '0' COMMENT '开始时间',
|
||
`end_time` bigint DEFAULT '0' COMMENT '结束时间',
|
||
`status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0' COMMENT '任务状态（0停止 1进行）',
|
||
`msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '任务信息',
|
||
`remark` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '备注说明',
|
||
`create_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '创建者',
|
||
`create_time` bigint DEFAULT '0' COMMENT '创建时间',
|
||
`update_by` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '更新者',
|
||
`update_time` bigint DEFAULT '0' COMMENT '更新时间',
|
||
PRIMARY KEY (`id`) USING BTREE
|
||
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='跟踪_任务给HRL网元';
|
||
|
||
-- Dump completed on 2024-09-19 14:26:59
|