/*
 Navicat Premium Dump SQL

 Source Server         : 2.22.55.89
 Source Server Type    : MySQL
 Source Server Version : 50744 (5.7.44)
 Source Host           : 2.22.55.119:3306
 Source Schema         : idea_fire_safety_hd

 Target Server Type    : MySQL
 Target Server Version : 50744 (5.7.44)
 File Encoding         : 65001

 Date: 07/04/2025 19:32:12
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for company_industry
-- ----------------------------
DROP TABLE IF EXISTS `company_industry`;
CREATE TABLE `company_industry`  (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `company_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '主体id',
  `industry_sector_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业领域表id',
  `industry_sector_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业领域名称',
  `industry_department_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业领域监管部门表id',
  `industry_department_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业领域监管部门名称',
  `created_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建id',
  `created_at` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `my_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `credit_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '统一信用代码',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `company_id`(`company_id`) USING BTREE,
  INDEX `industry_sector_id`(`industry_sector_id`) USING BTREE,
  INDEX `industry_department_id`(`industry_department_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '市场主体_行业领域关联表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of company_industry
-- ----------------------------
INSERT INTO `company_industry` VALUES ('55595233fe3711efaade0242ac110007', '91320211136248646M', NULL, NULL, '1', '市委宣传部', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55596c8afe3711efaade0242ac110007', '913202117673817771', NULL, NULL, '13', '市生态环境局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55596e72fe3711efaade0242ac110007', '91320211583752801U', NULL, NULL, '13', '市生态环境局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55596ec5fe3711efaade0242ac110007', '91320211769137321E', NULL, NULL, '13', '市生态环境局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55596fd4fe3711efaade0242ac110007', '91320211588430027C', NULL, NULL, '15', '市交通运输局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597316fe3711efaade0242ac110007', '913202111361463326', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('5559736bfe3711efaade0242ac110007', '913202117673817771', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('555973b3fe3711efaade0242ac110007', '91320211607954871A', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('555973effe3711efaade0242ac110007', '91320200MA1MQGR73M', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('5559741efe3711efaade0242ac110007', '913202117322436571', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597442fe3711efaade0242ac110007', '91320211MA1P7X4Y3K', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597465fe3711efaade0242ac110007', '913202117746540593', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('5559748bfe3711efaade0242ac110007', '91320211765891183U', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('555974b3fe3711efaade0242ac110007', '91320211748189579J', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597502fe3711efaade0242ac110007', '91320211588430027C', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597535fe3711efaade0242ac110007', '91320211136248646M', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('5559755cfe3711efaade0242ac110007', '91320211583752801U', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597585fe3711efaade0242ac110007', '91320211301944347E', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('555975adfe3711efaade0242ac110007', '91320211769137321E', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('555975d2fe3711efaade0242ac110007', '91320211607952753A', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('555975fcfe3711efaade0242ac110007', '913202112500560589', NULL, NULL, '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('5559768afe3711efaade0242ac110007', '91320211748189579J', NULL, NULL, '23', '市市场监管局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('555976cffe3711efaade0242ac110007', '91320211730714179D', NULL, NULL, '23', '市市场监管局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597701fe3711efaade0242ac110007', '913202112500560589', NULL, NULL, '23', '市市场监管局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('5559795ffe3711efaade0242ac110007', '913202111361463326', NULL, NULL, '30', '市城管局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597995fe3711efaade0242ac110007', '91320211765891183U', NULL, NULL, '30', '市城管局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('555979c7fe3711efaade0242ac110007', '91320211588430027C', NULL, NULL, '30', '市城管局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('555979f1fe3711efaade0242ac110007', '91320211136248646M', NULL, NULL, '30', '市城管局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597a23fe3711efaade0242ac110007', '91320211730714179D', NULL, NULL, '30', '市城管局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597d8afe3711efaade0242ac110007', '91320200MA1MQGR73M', NULL, NULL, '', '消委办', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597dc1fe3711efaade0242ac110007', '91320211136248646M', NULL, NULL, '', '消委办', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597de7fe3711efaade0242ac110007', '91320211583752801U', NULL, NULL, NULL, '市消防救援支队', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597e0cfe3711efaade0242ac110007', '91320211607952753A', NULL, NULL, NULL, '市消防救援支队', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('55597e2ffe3711efaade0242ac110007', '91320211607952753A', NULL, NULL, NULL, '消委办', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('91320200661795074G', '91320200661795074G', NULL, '工贸行业', NULL, '滨湖区应急局', NULL, NULL, NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;
