programs_info/胡埭市场主体两张清单/于杰/company_main.sql

/*
 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 14:56:10
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for company_main
-- ----------------------------
DROP TABLE IF EXISTS `company_main`;
CREATE TABLE `company_main`  (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `district_c` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区县',
  `street_c` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '街镇',
  `community_c` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '村社区',
  `name_c` 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 '统一信用代码',
  `legal_person` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '法人',
  `phone_c` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `industry_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业类别/所属行业',
  `business_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经营状态BUSINESS_STATUS',
  `label_c` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业标签多选名称',
  `label_id` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业标签多选',
  `register_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册地址',
  `actual_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实际经营地址',
  `park_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在园区多选xxx',
  `build_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '所在建筑多选xxx',
  `fire_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消防设施类型名称',
  `industry_c` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业领域xxxx',
  `industry_regulators` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '行业监管部门xxxx',
  `local_management_dept` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '属地管理部门',
  `special_c` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专项领域xxxxx',
  `special_regulators` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专项领域监管部门xxxxx',
  `is_c_in_c` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否厂中厂',
  `c_in_c_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '厂中厂分级分类',
  `is_high_risk` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否较大风险作业',
  `high_risk_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '较大风险作业类型多选xxx',
  `fire_supervision_level` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消防监管等级',
  `safety_inspector` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '安全巡查员',
  `safety_inspector_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '安全巡查员phone',
  `created_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建id',
  `created_at` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `updated_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新id',
  `updated_at` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `my_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `my_status` tinyint(1) NULL DEFAULT NULL COMMENT '状态0正常1删除',
  `fire_instructor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消防指导员',
  `fire_instructor_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消防指导员phone',
  `safety_manager` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位安全负责人',
  `safety_manager_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位安全负责人phone',
  `safety_administrator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '安全管理员',
  `safety_administrator_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '安全管理员phone',
  `fire_safety_officer` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消防安全员',
  `fire_safety_officer_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消防安全员phone',
  `fire_control_center_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消控中心',
  `incorporation_time` datetime NULL DEFAULT NULL COMMENT '成立日期',
  `registered_capital` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册资本',
  `registered_capital_unit` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '注册资本单位',
  `approval_time` datetime NULL DEFAULT NULL COMMENT '核准日期',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '市场主体' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of company_main
-- ----------------------------
INSERT INTO `company_main` VALUES ('1', '滨湖区', '胡埭镇', '花汇苑社区', '无锡市新科表面工程材料有限公司', '913202111361463326', '薛永宗', '85504122', '稀有稀土金属冶炼', '1', '工贸企业,机械', 'QYBQ0006001,QYBQ0004015', '无锡市滨湖区胡埭工业安置区北区丁香路7号', '无锡市滨湖区胡埭镇花汇苑社区丁香路7号', NULL, NULL, NULL, '工贸行业', '市应急局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '王玉琦', '18961828190', '王玉琦', '18961828190', NULL, NULL, NULL, '1900-01-19 00:00:00', '100', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('10', '滨湖区', '胡埭镇', '富润社区', '无锡市红杉铜业有限公司', '913202117673817771', '刘洪宾', '85072630', '常用有色金属冶炼', '1', '工贸企业,有色,厂中厂出租,厂中厂承租', 'QYBQ0006001,QYBQ0004017,QYBQ0001002,QYBQ0001001', '无锡市滨湖区胡埭镇陆藕路21-7', '无锡市滨湖区胡埭镇富润社区陆藕路21－7号', '', '', '', '工贸行业', '市应急局', '滨湖区胡埭镇应急部门', '', '', '0', '', '0', '', '', '', '', '', NULL, '', NULL, '', NULL, '', '', '李栋梁', '15961280265', '蒋志军', '13771008978', '', '', '', '1900-04-20 00:00:00', '1000', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('11', '滨湖区', '胡埭镇', '鸿翔村', '无锡市红光精密铸件厂', '91320211607954871A', '浦惠清', '85595173', '通用设备制造业', '1', '工贸企业,机械', 'QYBQ0006001,QYBQ0004015', '无锡市滨湖区胡埭镇人民西路48号', '无锡市滨湖区胡埭镇鸿翔村环镇西路39号', NULL, NULL, NULL, '危废处置企行业', '市生态环境局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '浦惠清', '13606189671', '徐婷婷', '13812285339', NULL, NULL, NULL, '1900-01-19 00:00:00', '800', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('12', '滨湖区', '胡埭镇', '龙延村', '无锡晶智鑫精密模塑科技有限公司', '91320200MA1MQGR73M', '秦立林', '85539986', '塑料制品业', '1', '工贸企业,轻工,机械,二级重点单位', 'QYBQ0006001,QYBQ0004016,QYBQ0004015,QYBQ0003002', '无锡市滨湖区胡埭镇龙延村龙胆路1号', '无锡市滨湖区胡埭镇龙延村龙胆路1号', NULL, NULL, NULL, '危化行业', '市应急局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '秦立林', '18912378218', '闵晓峰', '13861793977', NULL, NULL, '0510-85539984', '1900-01-20 00:00:00', '1600', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('12bb56b5456ac4dd89d4896fb70eede3', '滨湖区', '胡埭镇', '龙延村', 'cc3主体名称', '3202889977', 'ee', 'ff', 'gg', '1', 'i', NULL, 'j', 'k', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '0', '2', NULL, NULL, NULL, 'x', '2025-02-28 16:58:21', 'z', '2025-02-28 16:58:23', '', 0, '刘建新', '13338103310', '吴浩庸', '13706179961', '王仕兴', '13771182516', '张建厂', '18012398223', '18021186363', NULL, '1000', '人民币', NULL);
INSERT INTO `company_main` VALUES ('13', '滨湖区', '胡埭镇', '马鞍村', '无锡恺瑞化纤有限公司', '913202117322436571', '宣红华', '68005505', '纤维素纤维原料及纤维制造', '1', '工贸企业,纺织厂,二级重点单位', 'QYBQ0006001,QYBQ00081004,QYBQ0003002', '无锡市滨湖区胡埭镇刘闾路198号', '无锡市滨湖区胡埭镇马鞍村刘闾路198号', NULL, NULL, NULL, '工贸行业', '市应急局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, '二级重点单位', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '宣红华', '13901515118', '张学江', '13951512763', NULL, NULL, NULL, '1900-01-20 00:00:00', '4000', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('14', '滨湖区', '胡埭镇', '富安村', '无锡市绍隆科技有限公司', '91320211MA1P7X4Y3K', '包珊媚', '13771171111', '通用仪器仪表制造', '1', '工贸企业,机械,厂中厂承租', 'QYBQ0006001,QYBQ0004015,QYBQ0001001', '无锡市滨湖区胡埭镇胡埭路29号', '无锡市滨湖区胡埭镇富安村胡埭路10号北179米绍隆科技厂房', NULL, NULL, NULL, '交通运输行业', '市交通运输局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '钱锋', '13806195128', '王涛', '13771571429', NULL, NULL, NULL, '1900-01-20 00:00:00', '200', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('15', '滨湖区', '胡埭镇', '张舍村', '无锡市鑫金热处理有限公司', '913202117746540593', '付昌元', '13912376668', '金属制品业', '1', '工贸企业,机械,厂中厂承租', 'QYBQ0006001,QYBQ0004015,QYBQ0001001', '无锡市滨湖区胡埭镇工业园B区25号', '无锡市滨湖区胡埭镇张舍村纬四路20号', NULL, NULL, NULL, '工贸行业', '市应急局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '刘建新', '13338103310', '薄其山', '13961873168', NULL, NULL, NULL, '1900-05-20 00:00:00', '150', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('16', '滨湖区', '胡埭镇', '张舍村', '无锡市铸诚铸造有限公司', '91320211765891183U', '浦雪兴', '85582508', '黑色金属冶炼和压延加工业', '1', '工贸企业,冶金等工业,厂中厂承租', 'QYBQ0006001,QYBQ0004004,QYBQ0001001', '无锡市滨湖区胡埭工业园南区胡埭路12-7', '无锡市滨湖区胡埭镇张舍村胡埭路12号', NULL, NULL, NULL, '危废处置企行业', '市生态环境局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '浦雪兴', '13621507779', '吴云峰', '13961831833', NULL, NULL, NULL, '1900-04-20 00:00:00', '500', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('17', '滨湖区', '胡埭镇', '鸿翔村', '无锡华立聚能装备有限公司', '91320211748189579J', '薛仲华', '85180940', '专用设备制造业', '10', '工贸企业,机械,厂中厂承租', 'QYBQ0006001,QYBQ0004015,QYBQ0001001', '无锡市滨湖区雪浪街道科教软件园14号楼四楼', '无锡市滨湖区胡埭镇鸿翔村石榴路15号', NULL, NULL, NULL, '危化行业', '市应急局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '周斌贤', '13921280000', '袁瑞清', '13915349779', NULL, NULL, NULL, '1900-03-20 00:00:00', '11111', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('2', '滨湖区', '胡埭镇', '花汇苑社区', '无锡韩宴餐饮管理有限公司', '91320211588430027C', '张义', '85577877', '其他餐饮业', '1', '工贸企业,轻工,厂中厂承租,二级重点单位', 'QYBQ0006001,QYBQ0004016,QYBQ0001001,QYBQ0003002', '无锡市滨湖区胡埭工业园胡埭路8号', '无锡市滨湖区胡埭工业园胡埭路8号', NULL, NULL, NULL, '交通运输行业', '市交通运输局', '滨湖区胡埭镇交通运输部门', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '张建厂', '18012398223', '张建厂', '18012398223', NULL, NULL, NULL, '1900-11-20 00:00:00', '3000', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('22bb56b5456ac4dd89d4896fb70eede3', '滨湖区', '胡埭镇', '龙延村', 'cc4主体名称', '3202778899', 'ee', 'ff', 'gg', '2', 'i', NULL, 'j', 'k', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '3', '0', '1', '消防监管等级', '安全巡查员', '安全巡查员phone', '1', '2025-02-28 16:58:21', '1', '2025-02-28 16:58:23', '备注', 0, '刘建新', '13338103310', '单位安全负责人', '单位安全负责人phone', '安全管理员', '安全管理员phone', '张建厂', '18012398223', '18021186363', '2025-03-07 10:11:28', '1000', '人民币', '2025-03-07 10:11:41');
INSERT INTO `company_main` VALUES ('2bb56b5456ac4dd89d4896fb70eede34', '滨湖区', '胡埭镇', '龙延村', '无锡晶智鑫精密模塑科技有限公司', '91320200MA1MQGR73M', '秦立林', '85539986', '塑料制品业', '2', '工贸企业,轻工,机械,二级重点单位', NULL, '无锡市滨湖区胡埭镇龙延村龙胆路1号', '无锡市滨湖区胡埭镇龙延村龙胆路1号', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', '0', '2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '刘建新', '13338103310', '秦立林', '18912378218', '闵晓峰', '13861793977', '张建厂', '18012398223', '18021186363', '2016-07-27 16:01:21', '1600', '人民币', '2024-07-22 16:01:41');
INSERT INTO `company_main` VALUES ('3', '滨湖区', '胡埭镇', '花汇苑社区', '无锡市梁溪包装有限公司', '91320211136248646M', '曹波', '85514512', '纸制品制造', '1', '工贸企业,轻工,厂中厂承租', 'QYBQ0006001,QYBQ0004016,QYBQ0001001', '无锡市滨湖区胡埭镇莲杆路7-1', '无锡市滨湖区胡埭镇花汇苑社区莲杆路7－1号', NULL, NULL, NULL, '工贸行业', '市应急局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '王渊', '13961816012', '李丹', '18921299355', NULL, NULL, NULL, '1900-01-19 00:00:00', '150', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('4', '滨湖区', '胡埭镇', '马鞍村', '江苏永瀚特种合金技术股份有限公司', '91320211583752801U', '曹阳', '0510-85629222', '铸造及其他金属制品制造', '1', '工贸企业,机械,二级重点单位', 'QYBQ0006001,QYBQ0004015,QYBQ0003002', '无锡市滨湖区胡埭镇刘闾路11号', '无锡市滨湖区胡埭镇马鞍村刘闾路11号', NULL, NULL, NULL, '危废处置企行业', '市生态环境局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, '二级重点单位', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '贺剑', '13709218329', '查申荣', '18006152857', NULL, NULL, '85623606', '1900-11-20 00:00:00', '27599', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('5', '滨湖区', '胡埭镇', '马鞍村', '诺熙科技（无锡）有限公司', '91320211301944347E', '王一琦', '13961858899', '通用零部件制造', '1', '工贸企业,机械', 'QYBQ0006001,QYBQ0004015', '无锡市滨湖区胡埭镇马鞍村芸香路3号', '无锡市滨湖区胡埭镇马鞍村芸香路3号', NULL, NULL, NULL, '危化行业', '市应急局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '王一琦', '13961897566', '王勇强', '13861773029', NULL, NULL, NULL, '1900-01-20 00:00:00', '5000', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('6', '滨湖区', '胡埭镇', '张舍村', '无锡华翔化纤有限公司', '91320211730714179D', '王进平', '85062183', '纤维素纤维原料及纤维制造', '11', '工贸企业,纺织厂', 'QYBQ0006001,QYBQ00081004', '无锡市苏锡路606号', '无锡市滨湖区胡埭镇张舍村刘塘路1号', NULL, NULL, NULL, '特种设备安全', '市市场监管局', '滨湖区胡埭镇应急部门', 'xxxx', 'xxxx', '0', NULL, '0', NULL, '一级重点单位', '张庆', '13585089258', NULL, NULL, NULL, NULL, NULL, NULL, '俞耀兴', '13861818009', '张庆', '13585089258', '俞耀兴', '13861818009', '俞耀兴', '13861818009', '85623605', '1900-01-20 00:00:00', '1200', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('7', '滨湖区', '胡埭镇', '夏渎村', '无锡锡南科技股份有限公司', '91320211769137321E', '李忠良', '85390161', '金属制品业', '1', '工贸企业,涉爆粉尘,机械', 'QYBQ0006001,QYBQ0009005,QYBQ0004015', '无锡市滨湖区旭天智慧园10-501', '无锡市滨湖区胡埭镇夏渎村冬青路20号', NULL, NULL, NULL, '危化行业', '市应急局', '滨湖区胡埭镇应急部门', 'xxxx', 'xxxx', '1', '1', '1', '1', '二级重点单位', '张明哲', '13771078196', NULL, NULL, NULL, NULL, NULL, NULL, '肖英', '13914126311', '张明哲', '13771078196', '肖英', '13914126311', '肖鹏', '13914126312', '18021186363', '1900-05-20 00:00:00', '10000', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('8', '滨湖区', '胡埭镇', '胡埭村', '无锡琳达织造有限公司', '91320211607952753A', '吴浩庸', '85596210', '服饰制造', '1', '工贸企业,纺织厂,厂中厂出租,厂中厂承租,二级重点单位', 'QYBQ0006001,QYBQ00081004,QYBQ0001002,QYBQ0001001,QYBQ0003002', '无锡市滨湖区胡埭镇鸿翔路28号', '无锡市滨湖区胡埭镇胡埭村鸿翔路28号', NULL, NULL, NULL, '工贸行业', '市应急局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, '二级重点单位', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '吴浩庸', '13706179961', '王仕兴', '13771182516', NULL, NULL, NULL, '1900-01-19 00:00:00', '1500', '人民币', '1900-01-20 00:00:00');
INSERT INTO `company_main` VALUES ('9', '滨湖区', '胡埭镇', '富润社区', '无锡市法兰锻造有限公司', '913202112500560589', '李刚亮', '85581954', '通用设备制造业', '1', '工贸企业,机械', 'QYBQ0006001,QYBQ0004015', '无锡市滨湖区胡埭镇振胡路288号', '无锡市滨湖区胡埭镇富润社区振胡北路88号', NULL, NULL, NULL, '交通运输行业', '市交通运输局', '滨湖区胡埭镇应急部门', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '李刚亮', '18962815805', '赵小飞', '18921530833', NULL, NULL, NULL, '1900-01-19 00:00:00', '10000', '人民币', '1900-01-20 00:00:00');

-- ----------------------------
-- 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
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '市场主体_行业领域关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of company_industry
-- ----------------------------
INSERT INTO `company_industry` VALUES ('1', '1', '40', '工贸行业', '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('10', '10', '40', '工贸行业', '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('11', '11', '18', '危废处置企行业', '13', '市生态环境局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('12', '12', '41', '危化行业', '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('13', '13', '40', '工贸行业', '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('14', '14', '25', '交通运输行业', '15', '市交通运输局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('15', '15', '40', '工贸行业', '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('16', '16', '18', '危废处置企行业', '13', '市生态环境局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('17', '17', '41', '危化行业', '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('2', '2', '25', '交通运输行业', '15', '市交通运输局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('3', '3', '40', '工贸行业', '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('4', '4', '18', '危废处置企行业', '13', '市生态环境局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('5', '5', '41', '危化行业', '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('6', '6', '43', '特种设备安全', '23', '市市场监管局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('7', '7', '41', '危化行业', '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('8', '8', '40', '工贸行业', '21', '市应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_industry` VALUES ('9', '9', '25', '交通运输行业', '15', '市交通运输局', NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for company_special
-- ----------------------------
DROP TABLE IF EXISTS `company_special`;
CREATE TABLE `company_special`  (
  `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',
  `special_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专项领域id',
  `special_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专项领域名称',
  `special_department_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '专项领域部门id',
  `special_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
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '市场主体_专项领域关联表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of company_special
-- ----------------------------
INSERT INTO `company_special` VALUES ('1', '6', '11', '安全生产', '1816722357937807361', '区应急局', NULL, NULL, NULL, NULL);
INSERT INTO `company_special` VALUES ('2', '7', '36', '危化品或剧毒、易制爆、易制毒三类危化品', '1816722357937807361', '区应急局', NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for company_high_risk
-- ----------------------------
DROP TABLE IF EXISTS `company_high_risk`;
CREATE TABLE `company_high_risk`  (
  `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',
  `high_risk_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类型',
  `high_risk_type_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
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '市场主体较大风险作业类型' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of company_high_risk
-- ----------------------------
INSERT INTO `company_high_risk` VALUES ('cTl5IEW9SRwypaI7N6r', '2', '4', NULL, '1', '2025-03-03 15:05:25', NULL, NULL);
INSERT INTO `company_high_risk` VALUES ('MquflddlmexiXdtmDov', '1', '3', NULL, '1', '2025-03-03 15:08:48', NULL, NULL);
INSERT INTO `company_high_risk` VALUES ('NtV7xc2HkdNsQ85knJn', '2', '1', NULL, '1', '2025-03-03 15:05:25', NULL, NULL);
INSERT INTO `company_high_risk` VALUES ('PMmZtCTjFmUEIESLdfP', '2', '3', NULL, '1', '2025-03-03 15:05:25', NULL, NULL);

-- ----------------------------
-- Table structure for company_business
-- ----------------------------
DROP TABLE IF EXISTS `company_business`;
CREATE TABLE `company_business`  (
  `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',
  `business_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '经营状态',
  `business_status_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
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '市场主体经营状态-暂时不是多选' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of company_business
-- ----------------------------

-- ----------------------------
-- Table structure for company_address
-- ----------------------------
DROP TABLE IF EXISTS `company_address`;
CREATE TABLE `company_address`  (
  `id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `park_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '园区id',
  `building_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '楼栋id',
  `floor_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '楼层id,多选,逗号隔开',
  `company_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '市场主题id',
  `site_plan_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '场所平面图名称',
  `site_plan_url` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '场所平面图url',
  `risk_color_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '风险四色图名称',
  `risk_color_url` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '风险四色图url',
  `created_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建id',
  `created_at` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `updated_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新id',
  `updated_at` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `my_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `my_status` tinyint(1) NULL DEFAULT NULL COMMENT '状态0正常1删除',
  `credit_code` 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 company_address
-- ----------------------------
INSERT INTO `company_address` VALUES ('1', 'MA1001NE605H00004334443000773311250103000722', 'MA1001NE605H0000444224030044332223010101011435', '1层,-1层,2层', '202e432e70e144539279a2691e7678db', 'WechatIMG97.jpg', '1347598334746951680', '大框@2x (1).png', '1347598353394827264', NULL, '2025-03-07 15:54:46', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `company_address` VALUES ('2', 'MA1001NE605H00004334443000773311250103000722', 'MA1001NE605H0000444224030044332223010101011435', '1层,-1层,2层', '2bb56b5456ac4dd89d4896fb70eede34', 'WechatIMG97.jpg', '1347598334746951680', '大框@2x (1).png', '1347598353394827264', NULL, '2025-03-07 15:54:46', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `company_address` VALUES ('3', 'MA1001NE605H00004334443000773311250103000722', 'MA1001NE605H0000444224030044332223010101011435', '1层,-1层,2层', '369e496ba08e4b1da1e1742c84f60c16', 'WechatIMG97.jpg', '1347598334746951680', '大框@2x (1).png', '1347598353394827264', NULL, '2025-03-07 15:54:46', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `company_address` VALUES ('LdcFGr1m7AsUvYqPnjE', 'MA1001NE605H00004334443000773311250103000722', 'MA1001NE605H0000444224030044332223010101011435', '-2层,-1层', '1', '', '', '', '', '', '2025-03-05 09:45:10', '', NULL, '', NULL, NULL);
INSERT INTO `company_address` VALUES ('vVysb6wBJaVRk9gntct', 'MA1001NE605H00004334443000773311250103000722', 'MA1001NE605H0000444224030044332223010101011435', '1层,-2层,-1层', '2', '', '', '', '', '', '2025-03-05 14:56:53', '', NULL, '', NULL, NULL);
INSERT INTO `company_address` VALUES ('xfAg8beZ2HycHAL6UCy', 'MA1001NE605H00004334443000773311250103000722', 'MA1001NE605H0000444224030044332223010101011435', '1层,-1层,2层', '1', 'WechatIMG97.jpg', '1347598334746951680', '大框@2x (1).png', '1347598353394827264', NULL, '2025-03-07 15:54:46', NULL, NULL, NULL, NULL, NULL);

-- ----------------------------
-- Table structure for company_fire_facilities
-- ----------------------------
DROP TABLE IF EXISTS `company_fire_facilities`;
CREATE TABLE `company_fire_facilities`  (
  `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',
  `fire_type` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '消防设施类型',
  `fire_value` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '消防设施各个指标json存放',
  `created_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建id',
  `created_at` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `updated_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新id',
  `updated_at` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `my_remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `my_status` tinyint(1) NULL DEFAULT NULL COMMENT '状态0正常1删除',
  `credit_code` 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 company_fire_facilities
-- ----------------------------
INSERT INTO `company_fire_facilities` VALUES ('LRGHwxlNRxMdDIoVZYM', '1', '1', '{\"消防水池容量（m³）\":\"33\",\"消防水池位置\":\"22\",\"消防水箱位置\":\"11\",\"气压罐容量\":\"333\",\"消防水箱容量（m³）\":\"444\",\"消防泵数量\":\"555\"}', NULL, '2025-03-04 14:13:47', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `company_fire_facilities` VALUES ('okcCRvh2q4kWYxhSYaF', '2', '1', '{\"消防水池容量（m³）\":\"qq2\",\"消防水池位置\":\"dd1\",\"消防水箱位置\":\"vv1\",\"气压罐容量\":\"ff1\",\"消防水箱容量（m³）\":\"gg1\",\"消防泵数量\":\"hh1\"}', NULL, '2025-03-04 14:20:59', NULL, NULL, NULL, NULL, NULL);
INSERT INTO `company_fire_facilities` VALUES ('xhCnDhVPH5D9nS4mHdb', '2', '1', '{\"消防水池容量（m³）\":\"1112\",\"消防水池位置\":\"2232\",\"消防水箱位置\":\"3344\",\"气压罐容量\":\"4455\",\"消防水箱容量（m³）\":\"5566\",\"消防泵数量\":\"6677\"}', NULL, '2025-03-04 14:11:58', NULL, NULL, NULL, NULL, NULL);

SET FOREIGN_KEY_CHECKS = 1;