Home Esplora Aiuto
Accedi
zhangtao
/
programs_info
Segui 1
Vota 0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): 099f5d4f5a
Rami (Branch) Tag
programs_info
/
胡埭市场主体两张清单
/
于杰
/
industry_sector.sql

industry_sector.sql 7.8 KB
Cronologia Originale

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 0测试数据库_47.113.226.116
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 50744
    7. 

  7.  Source Host           : 47.113.226.116:3306
    8. 

  8.  Source Schema         : idea_fire_safety_hd
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 50744
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 10/03/2025 13:52:38
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for industry_sector
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `industry_sector`;
    24. 

  24. CREATE TABLE `industry_sector`  (
    25. 

  25.   `id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
    26. 

  26.   `number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编号',
    27. 

  27.   `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
    28. 

  28.   `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
    29. 

  29.   `create_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建时间',
    30. 

  30.   `update_time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改时间',
    31. 

  31.   `create_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
    32. 

  32.   `update_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改人',
    33. 

  33.   PRIMARY KEY (`id`) USING BTREE
    34. 

  34. ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '行业领域表' ROW_FORMAT = Dynamic;
    35. 

  35. 

  36. -- ----------------------------
    37. 

  37. -- Records of industry_sector
    38. 

  38. -- ----------------------------
    39. 

  39. INSERT INTO `industry_sector` VALUES ('1', 'HYLY001', '电力企业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    40. 

  40. INSERT INTO `industry_sector` VALUES ('10', 'HYLY010', '消防领域', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    41. 

  41. INSERT INTO `industry_sector` VALUES ('11', 'HYLY011', '群租房', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    42. 

  42. INSERT INTO `industry_sector` VALUES ('12', 'HYLY012', '民政行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    43. 

  43. INSERT INTO `industry_sector` VALUES ('13', 'HYLY013', '技工院校', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    44. 

  44. INSERT INTO `industry_sector` VALUES ('14', 'HYLY014', '职业培训机构', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    45. 

  45. INSERT INTO `industry_sector` VALUES ('15', 'HYLY015', '人力资源机构', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    46. 

  46. INSERT INTO `industry_sector` VALUES ('16', 'HYLY016', '劳务派遣单位', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    47. 

  47. INSERT INTO `industry_sector` VALUES ('17', 'HYLY017', '自然资源和规划行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    48. 

  48. INSERT INTO `industry_sector` VALUES ('18', 'HYLY018', '危废处置企行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    49. 

  49. INSERT INTO `industry_sector` VALUES ('19', 'HYLY019', '房屋市政工程', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    50. 

  50. INSERT INTO `industry_sector` VALUES ('2', 'HYLY002', '油气输送管道企业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    51. 

  51. INSERT INTO `industry_sector` VALUES ('20', 'HYLY020', '既有建筑行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    52. 

  52. INSERT INTO `industry_sector` VALUES ('21', 'HYLY021', '燃气行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    53. 

  53. INSERT INTO `industry_sector` VALUES ('22', 'HYLY022', '环卫行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    54. 

  54. INSERT INTO `industry_sector` VALUES ('23', 'HYLY023', '户外广告设施', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    55. 

  55. INSERT INTO `industry_sector` VALUES ('24', 'HYLY024', '户外招牌设施', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    56. 

  56. INSERT INTO `industry_sector` VALUES ('25', 'HYLY025', '交通运输行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    57. 

  57. INSERT INTO `industry_sector` VALUES ('26', 'HYLY026', '水利领域', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    58. 

  58. INSERT INTO `industry_sector` VALUES ('27', 'HYLY027', '农业机械', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    59. 

  59. INSERT INTO `industry_sector` VALUES ('28', 'HYLY028', '畜牧兽医', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    60. 

  60. INSERT INTO `industry_sector` VALUES ('29', 'HYLY029', '农药企业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    61. 

  61. INSERT INTO `industry_sector` VALUES ('3', 'HYLY003', '学校', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    62. 

  62. INSERT INTO `industry_sector` VALUES ('30', 'HYLY030', '农村沼气设施', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    63. 

  63. INSERT INTO `industry_sector` VALUES ('31', 'HYLY031', '休闲农业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    64. 

  64. INSERT INTO `industry_sector` VALUES ('32', 'HYLY032', '渔业水产', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    65. 

  65. INSERT INTO `industry_sector` VALUES ('33', 'HYLY033', '大型商业综合体（含商超）', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    66. 

  66. INSERT INTO `industry_sector` VALUES ('34', 'HYLY034', '餐饮行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    67. 

  67. INSERT INTO `industry_sector` VALUES ('35', 'HYLY035', '加油站', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    68. 

  68. INSERT INTO `industry_sector` VALUES ('36', 'HYLY036', '废品回收站', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    69. 

  69. INSERT INTO `industry_sector` VALUES ('37', 'HYLY037', '专业市场', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    70. 

  70. INSERT INTO `industry_sector` VALUES ('38', 'HYLY038', '文旅行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    71. 

  71. INSERT INTO `industry_sector` VALUES ('39', 'HYLY039', '卫生健康行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    72. 

  72. INSERT INTO `industry_sector` VALUES ('4', 'HYLY004', '学科类+复读类', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    73. 

  73. INSERT INTO `industry_sector` VALUES ('40', 'HYLY040', '工贸行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    74. 

  74. INSERT INTO `industry_sector` VALUES ('41', 'HYLY041', '危化行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    75. 

  75. INSERT INTO `industry_sector` VALUES ('42', 'HYLY042', '烟花爆竹', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    76. 

  76. INSERT INTO `industry_sector` VALUES ('43', 'HYLY043', '特种设备安全', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    77. 

  77. INSERT INTO `industry_sector` VALUES ('44', 'HYLY044', '体育行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    78. 

  78. INSERT INTO `industry_sector` VALUES ('45', 'HYLY045', '粮储行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    79. 

  79. INSERT INTO `industry_sector` VALUES ('46', 'HYLY046', '邮政快递行业', NULL, '18/2/2025 05:56:23', '18/2/2025 05:56:23', NULL, NULL);
    80. 

  80. INSERT INTO `industry_sector` VALUES ('5', 'HYLY005', '托管机构', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    81. 

  81. INSERT INTO `industry_sector` VALUES ('6', 'HYLY006', '高等学历继续教育', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    82. 

  82. INSERT INTO `industry_sector` VALUES ('7', 'HYLY007', '科研院所', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    83. 

  83. INSERT INTO `industry_sector` VALUES ('8', 'HYLY008', '民爆', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    84. 

  84. INSERT INTO `industry_sector` VALUES ('9', 'HYLY009', '船舶修造行业', NULL, '18/2/2025 05:56:22', '18/2/2025 05:56:22', NULL, NULL);
    85. 

  85. 

  86. SET FOREIGN_KEY_CHECKS = 1;
    87. 

  87.