/* Navicat Premium Data Transfer Source Server : 0测试数据库_47.113.226.116 Source Server Type : MySQL Source Server Version : 50744 Source Host : 47.113.226.116:3306 Source Schema : idea_fire_safety_hd Target Server Type : MySQL Target Server Version : 50744 File Encoding : 65001 Date: 10/03/2025 13:52:47 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for special -- ---------------------------- DROP TABLE IF EXISTS `special`; CREATE TABLE `special` ( `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键', `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `create_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人', `update_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '专项领域表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of special -- ---------------------------- INSERT INTO `special` VALUES ('1', '三级消防和日常监管', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('10', '安全消防', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('11', '安全生产', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('12', '市场监督', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('13', '律师事务所', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('14', '房屋租赁', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('15', '持证合法经营', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('16', '教育文体', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('17', '既有建筑', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('18', '治安', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('19', '派出所以外的日常消防监管', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('2', '交通运输', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('20', '消防', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('21', '消防安全', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('22', '消防执法', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('23', '消防监管', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('24', '燃气', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('25', '特种设备', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('26', '环保', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('27', '瓶改电', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('28', '用电', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('29', '电动自行车等质量', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('3', '住建', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('30', '电动车全链条专项整治行动', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('31', '电气线路', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('32', '租赁', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('33', '综治', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('34', '违建', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('35', '食品安全', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('36', '危化品或剧毒、易制爆、易制毒三类危化品', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('37', '压力容器、电梯等', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('38', '易制毒、易制爆', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('39', '消防、危化品或易燃易爆物品、治安', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('4', '住房租赁', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('40', '燃气、危废', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('41', '燃气、危废、房屋租赁', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('42', '燃气、既有建筑、房屋租赁', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('43', '燃气、用电(瓶改电)', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('44', '特种设备、产品质量', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('45', '特种设备、电动自行车质量', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('46', '特种设备(压力容器、电梯、行车、叉车等)', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('47', '用电(燃气、瓶改电)', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('48', '银行、保险', '2025-02-24 15:33:48', '2025-02-24 15:33:48', NULL, NULL); INSERT INTO `special` VALUES ('5', '供电', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('6', '卫健', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('7', '危化品或易燃易爆物品', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('8', '危废', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); INSERT INTO `special` VALUES ('9', '商务', '2025-02-24 15:33:47', '2025-02-24 15:33:47', NULL, NULL); SET FOREIGN_KEY_CHECKS = 1;