/*
 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:38
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for industry_sector
-- ----------------------------
DROP TABLE IF EXISTS `industry_sector`;
CREATE TABLE `industry_sector`  (
  `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci 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 industry_sector
-- ----------------------------
INSERT INTO `industry_sector` VALUES ('1', 'HYLY001', '电力企业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('10', 'HYLY010', '消防领域', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('11', 'HYLY011', '群租房', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('12', 'HYLY012', '民政行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('13', 'HYLY013', '技工院校', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('14', 'HYLY014', '职业培训机构', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('15', 'HYLY015', '人力资源机构', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('16', 'HYLY016', '劳务派遣单位', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('17', 'HYLY017', '自然资源和规划行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('18', 'HYLY018', '危废处置企行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('19', 'HYLY019', '房屋市政工程', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('2', 'HYLY002', '油气输送管道企业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('20', 'HYLY020', '既有建筑行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('21', 'HYLY021', '燃气行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('22', 'HYLY022', '环卫行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('23', 'HYLY023', '户外广告设施', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('24', 'HYLY024', '户外招牌设施', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('25', 'HYLY025', '交通运输行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('26', 'HYLY026', '水利领域', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('27', 'HYLY027', '农业机械', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('28', 'HYLY028', '畜牧兽医', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('29', 'HYLY029', '农药企业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('3', 'HYLY003', '学校', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('30', 'HYLY030', '农村沼气设施', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('31', 'HYLY031', '休闲农业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('32', 'HYLY032', '渔业水产', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('33', 'HYLY033', '大型商业综合体（含商超）', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('34', 'HYLY034', '餐饮行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('35', 'HYLY035', '加油站', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('36', 'HYLY036', '废品回收站', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('37', 'HYLY037', '专业市场', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('38', 'HYLY038', '文旅行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('39', 'HYLY039', '卫生健康行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('4', 'HYLY004', '学科类+复读类', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('40', 'HYLY040', '工贸行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('41', 'HYLY041', '危化行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('42', 'HYLY042', '烟花爆竹', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('43', 'HYLY043', '特种设备安全', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('44', 'HYLY044', '体育行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('45', 'HYLY045', '粮储行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('46', 'HYLY046', '邮政快递行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('5', 'HYLY005', '托管机构', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('6', 'HYLY006', '高等学历继续教育', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('7', 'HYLY007', '科研院所', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('8', 'HYLY008', '民爆', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
INSERT INTO `industry_sector` VALUES ('9', 'HYLY009', '船舶修造行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;