/*
Navicat Premium Dump SQL
Source Server : 127.0.0.1-7002-mysql
Source Server Type : MySQL
Source Server Version : 80039 (8.0.39)
Source Host : 127.0.0.1:7002
Source Schema : mysql_pangu_cv
Target Server Type : MySQL
Target Server Version : 80039 (8.0.39)
File Encoding : 65001
Date: 29/12/2025 14:44:44
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for db_aizt_confidence_level_config
-- ----------------------------
DROP TABLE IF EXISTS `db_aizt_confidence_level_config`;
CREATE TABLE `db_aizt_confidence_level_config` (
`id` int NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`scene_code` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT '场景编码',
`scene_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL COMMENT '场景名称',
`confidence_level` double NOT NULL DEFAULT 0 COMMENT '置信度',
`update_time` datetime NOT NULL COMMENT '更新时间',
`create_time` datetime NOT NULL COMMENT '创建时间',
`del_flag` tinyint NOT NULL DEFAULT 0 COMMENT '逻辑删除标识',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 191 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_520_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of db_aizt_confidence_level_config
-- ----------------------------
INSERT INTO `db_aizt_confidence_level_config` VALUES (1, '0001', '受流器_集电靴丢失或折断', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (3, '0002', '受流器安装底座_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (5, '0003', '受流器安装底座吊挂螺栓_反光无法判断状态', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (7, '0004', '受流器安装底座吊挂螺栓_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (9, '0005', '受流器安装底座吊挂螺栓_螺栓松动', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (11, '0006', '受流器安装底座吊挂螺栓_螺栓防松标记线不完整清晰可见', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (13, '0007', '受流器熔断器保险_保险不清晰可见', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (15, '0008', '受流器熔断器保险_保险弹出', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (17, '0009', '受流器碳滑块_碳滑块磨耗超限', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (19, '0010', '受流器碳滑块_碳滑块丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (21, '0011', '受流器线缆固定线卡_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (23, '0012', '受流器线缆固定线卡_线卡松动', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (25, '0013', '受流器线缆固定线卡_线卡丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (27, '0014', '受流器线缆固定线卡螺栓_反光无法判断状态', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (29, '0015', '受流器线缆固定线卡螺栓_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (31, '0016', '受流器线缆固定线卡螺栓_螺栓松动', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (33, '0017', '受流器线缆固定线卡螺栓_螺栓防松标记线不完整清晰可见', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (35, '0018', '受流器集电靴_集电靴丢失或折断', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (37, '0019', '受流器集电靴紧固螺栓_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (39, '0020', '排障器_排障器丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (41, '0021', '排障器_排障器损伤或变形扭曲', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (43, '0022', '排障器_异物', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (45, '0023', '排障器螺栓_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (47, '0024', '牵引中心销_止铁片松动', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (49, '0025', '牵引中心销开槽螺栓止铁片_止铁片松动', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (51, '0026', '空压机通风导管螺栓_导管吊挂', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (53, '0027', '空压机通风导管螺栓_螺栓松动', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (55, '0028', '车下油压减震器区域_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (57, '0029', '车下油压减震器固定螺栓_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (59, '0030', '车下油压减震器固定螺栓_螺栓松动', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (61, '0031', '车下油压减震器固定螺栓_螺栓防松标记线不完整清晰可见', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (63, '0032', '车下箱门-AGTU电器控制箱_箱门打开', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (65, '0033', '车下箱门-制动控制单元箱_箱门打开', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (67, '0034', '车下箱门-压缩机电器控制箱_箱门打开', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (69, '0035', '车下箱门-四方锁_四方锁未锁闭', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (71, '0036', '车下箱门-四方锁_无法判断锁闭状态', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (73, '0037', '车下箱门-搭扣锁_搭扣锁打开', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (75, '0038', '车下箱门-搭扣锁_搭扣锁插销不在位', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (77, '0039', '车下箱门-牵引逆变器箱_箱门打开', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (79, '0040', '车厢箱门-辅助逆变器箱_箱门打开', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (81, '0041', '车下箱门-蓄电池箱_箱门打开', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (83, '0042', '车下箱门-辅助控制箱_箱门打开', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (85, '0043', '车下箱门-配电箱_箱门打开', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (87, '0044', '车间连接线_连接线脱落', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (89, '0045', '车间连接线-线缆_线缆吊挂', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (91, '0046', '车间连接线-卡箍_连接线脱落', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (93, '0047', '车间连接线-卡箍_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (95, '0048', '转向架轴箱端盖螺栓_反光无法判断状态', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (97, '0049', '转向架轴箱端盖螺栓_螺栓松动', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (99, '0050', '转向架轴箱端盖螺栓防松铁丝_防松铁丝丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (101, '0051', '转向架轴箱端盖螺栓防松铁丝_防松铁丝折断', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (103, '0052', '转向架轴箱端盖螺栓防松铁丝_防松铁丝被遮挡', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (105, '0053', '转向架轴箱端盖螺栓_螺栓防松标记线不完整清晰可见', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (107, '0054', '轮缘润滑装置_装置磨耗超限', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (109, '0055', '轮缘润滑装置_装置被部分遮挡', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (111, '0056', '轮缘润滑装置润滑块_润滑块缺失或部分缺失', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (113, '0057', '轴箱转臂节点托板固定螺栓_螺栓松动', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (115, '0058', '轴箱转臂节点托板固定螺栓防松铁丝_防松铁丝丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (117, '0059', '轴箱转臂节点托板固定螺栓防松铁丝_防松铁丝折断', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (119, '0060', '轴箱转臂节点托板固定螺栓_螺栓防松标记线不完整清晰可见', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (121, '0061', '防滑速度传感器区域_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (123, '0062', '防滑速度传感器紧固螺栓_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (125, '0063', '防滑速度传感器紧固螺栓_螺栓松动', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (127, '0064', '防滑速度传感器紧固螺栓_螺栓防松标记线不完整清晰可见', 1, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (129, '0065', '高度调整杆_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (131, '0066', '高度调整杆固定臂底部固定螺栓_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (133, '0067', '高度调整杆固定臂底部固定螺栓_螺栓松动', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (135, '0068', '高度调整杆底部固定螺栓_螺栓丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (137, '0069', '高度调整杆底部固定螺栓_螺栓开口销折断或丢失', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (139, '0070', '高度调整杆底部固定螺栓_螺栓松动', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (141, '0071', '排障器_排障器裂纹', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (143, '0072', '空气弹簧_空气弹簧破损', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (145, '0073', '空气弹簧_空气弹簧裂纹', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (147, '0074', '空气弹簧橡胶堆_橡胶堆裂纹', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (149, '0075', '防滑三角支架_三角支架断裂', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (151, '0076', '防滑三角支架_三角支架裂纹', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (153, '0077', '空气弹簧_异物', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (155, '0078', '空气弹簧橡胶堆_异物', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (157, '0079', '防滑三角支架_异物', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (159, '0080', '车间连接线_异物', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (161, '0081', '车间折棚_异物', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (163, '0082', '车间连接线_连接线套管脱落', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (165, '0083', '车间连接线_连接线破损或裂纹', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (183, '0084', '车门_车门打开', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (185, '0085', '车下箱门-四方锁_四方锁橡胶盖打开', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (187, '0086', '车间折棚_折棚松动', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
INSERT INTO `db_aizt_confidence_level_config` VALUES (189, '0087', '车间折棚_折棚破洞或裂口', 0.5, '2025-08-18 00:00:00', '2025-08-18 00:00:00', 0);
SET FOREIGN_KEY_CHECKS = 1;