Главная Обзор Помощь
Регистрация Вход
lbyzx123
/
huimv-baqing
Следить 1
В избранное 0
Ответвить 0
Файлы Обсуждения 0 Запросы на слияние 0 Коммиты 71 Релизы 0 Вики

西藏巴青项目

Дерево: 5de38b4a11
Ветки Метки
huimv-baqing
/
sql
/
biz_information_category.sql

biz_information_category.sql 8.3KB
История Исходник

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374 
  1. -- 资讯类别
    2. 

  2. SET NAMES utf8mb4;
    3. 

  3. 

  4. DROP TABLE IF EXISTS `biz_information_category`;
    5. 

  5. CREATE TABLE `biz_information_category`  (
    6. 

  6.   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
    7. 

  7.   `category_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编码（业务唯一）',
    8. 

  8.   `category_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
    9. 

  9.   `parent_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上级编码，关联本表 category_code',
    10. 

  10.   `category_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
    11. 

  11.   `module_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模块编码（01养殖资讯，02畜牧资源，03农技课堂）',
    12. 

  12.   `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '1可见 0不可见',
    13. 

  13.   `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '0存在 2删除',
    14. 

  14.   `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
    15. 

  15.   `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
    16. 

  16.   `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
    17. 

  17.   `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
    18. 

  18.   `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
    19. 

  19.   PRIMARY KEY (`id`) USING BTREE,
    20. 

  20.   UNIQUE INDEX `uk_category_code`(`category_code`) USING BTREE,
    21. 

  21.   INDEX `idx_parent_code`(`parent_code`) USING BTREE,
    22. 

  22.   INDEX `idx_category_type`(`category_type`) USING BTREE,
    23. 

  23.   INDEX `idx_del_flag`(`del_flag`) USING BTREE
    24. 

  24. ) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '资讯类别' ROW_FORMAT = Dynamic;
    25. 

  25. 

  26. 

  27. 

  28. -- ----------------------------
    29. 

  29. -- Records of biz_information_category
    30. 

  30. -- ----------------------------
    31. 

  31. DELETE FROM `biz_information_category`;
    32. 

  32. INSERT INTO `biz_information_category` VALUES (1, '001', '养殖标准', NULL, NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    33. 

  33. INSERT INTO `biz_information_category` VALUES (2, '002', '科技项目指南', NULL, NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    34. 

  34. INSERT INTO `biz_information_category` VALUES (3, '003', '产业政策', NULL, NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    35. 

  35. INSERT INTO `biz_information_category` VALUES (4, '001001', '繁育作业', '001', '1', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    36. 

  36. INSERT INTO `biz_information_category` VALUES (5, '001002', '饲养工作', '001', '1', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    37. 

  37. INSERT INTO `biz_information_category` VALUES (6, '001003', '免疫程序', '001', '1', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    38. 

  38. INSERT INTO `biz_information_category` VALUES (7, '001004', '环境调控', '001', '1', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    39. 

  39. INSERT INTO `biz_information_category` VALUES (8, '001005', '饲料配方', '001', '2', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    40. 

  40. INSERT INTO `biz_information_category` VALUES (9, '001006', '牦牛投喂', '001', '2', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    41. 

  41. INSERT INTO `biz_information_category` VALUES (10, '001007', '设备操作', '001', '3', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    42. 

  42. INSERT INTO `biz_information_category` VALUES (11, '001008', '设备保养', '001', '3', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    43. 

  43. INSERT INTO `biz_information_category` VALUES (12, '001009', '设备排障', '001', '3', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    44. 

  44. INSERT INTO `biz_information_category` VALUES (13, '001010', '设备维修', '001', '3', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    45. 

  45. INSERT INTO `biz_information_category` VALUES (14, '001011', '牦牛生长', '001', '4', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    46. 

  46. INSERT INTO `biz_information_category` VALUES (15, '001012', '牦牛出栏', '001', '4', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    47. 

  47. INSERT INTO `biz_information_category` VALUES (16, '001013', '疾病决策', '001', '5', '01', '0', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    48. 

  48. INSERT INTO `biz_information_category` VALUES (17, '002001', '高新技术', '002', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    49. 

  49. INSERT INTO `biz_information_category` VALUES (18, '002002', '农业科技', '002', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    50. 

  50. INSERT INTO `biz_information_category` VALUES (19, '002003', '社会发展', '002', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    51. 

  51. INSERT INTO `biz_information_category` VALUES (20, '002004', '基础研究', '002', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    52. 

  52. INSERT INTO `biz_information_category` VALUES (21, '003001', '涉农政策', '003', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    53. 

  53. INSERT INTO `biz_information_category` VALUES (22, '003002', '产业项目', '003', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    54. 

  54. INSERT INTO `biz_information_category` VALUES (23, '003003', '惠农补贴', '003', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    55. 

  55. INSERT INTO `biz_information_category` VALUES (24, '003004', '共富项目', '003', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    56. 

  56. INSERT INTO `biz_information_category` VALUES (25, '004001', '兽医人员', '004', '6', '02', '0', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    57. 

  57. INSERT INTO `biz_information_category` VALUES (26, '004002', '专家团队', '004', '6', '02', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    58. 

  58. INSERT INTO `biz_information_category` VALUES (27, '004003', '诊疗机构', '004', '6', '02', '0', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    59. 

  59. INSERT INTO `biz_information_category` VALUES (28, '004004', '医疗设备', '004', '6', '02', '0', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    60. 

  60. INSERT INTO `biz_information_category` VALUES (29, '004005', '专家', '004', '7', '02', '0', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    61. 

  61. INSERT INTO `biz_information_category` VALUES (30, '004006', '技术成果', '004', '7', '02', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    62. 

  62. INSERT INTO `biz_information_category` VALUES (31, '004007', '共享仪器', '004', '7', '02', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    63. 

  63. INSERT INTO `biz_information_category` VALUES (32, '004008', '视频课程', '004', '7', '02', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    64. 

  64. INSERT INTO `biz_information_category` VALUES (33, '005', '视频课程', NULL, NULL, '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    65. 

  65. INSERT INTO `biz_information_category` VALUES (34, '006', '实战培训', NULL, NULL, '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    66. 

  66. INSERT INTO `biz_information_category` VALUES (35, '005001', '基础养殖', '005', '8', '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    67. 

  67. INSERT INTO `biz_information_category` VALUES (36, '005002', '疫病防治', '005', '8', '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    68. 

  68. INSERT INTO `biz_information_category` VALUES (37, '005003', '繁育技术', '005', '8', '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    69. 

  69. INSERT INTO `biz_information_category` VALUES (38, '005004', '政策解读', '005', '8', '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    70. 

  70. INSERT INTO `biz_information_category` VALUES (39, '006001', '未开始', '006', NULL, '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    71. 

  71. INSERT INTO `biz_information_category` VALUES (40, '006002', '报名中', '006', NULL, '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    72. 

  72. INSERT INTO `biz_information_category` VALUES (41, '006003', '已报满', '006', NULL, '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    73. 

  73. INSERT INTO `biz_information_category` VALUES (42, '006004', '已截止', '006', NULL, '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
    74. 

  74.