-- 资讯类别
SET NAMES utf8mb4;

DROP TABLE IF EXISTS `biz_information_category`;
CREATE TABLE `biz_information_category`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `category_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编码（业务唯一）',
  `category_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `parent_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '上级编码，关联本表 category_code',
  `category_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型',
  `module_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '模块编码（01养殖资讯，02畜牧资源，03农技课堂）',
  `visible` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '1可见 0不可见',
  `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '0存在 2删除',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `uk_category_code`(`category_code`) USING BTREE,
  INDEX `idx_parent_code`(`parent_code`) USING BTREE,
  INDEX `idx_category_type`(`category_type`) USING BTREE,
  INDEX `idx_del_flag`(`del_flag`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 43 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '资讯类别' ROW_FORMAT = Dynamic;



-- ----------------------------
-- Records of biz_information_category
-- ----------------------------
DELETE FROM `biz_information_category`;
INSERT INTO `biz_information_category` VALUES (1, '001', '养殖标准', NULL, NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (2, '002', '科技项目指南', NULL, NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (3, '003', '产业政策', NULL, NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (4, '001001', '繁育作业', '001', '1', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (5, '001002', '饲养工作', '001', '1', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (6, '001003', '免疫程序', '001', '1', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (7, '001004', '环境调控', '001', '1', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (8, '001005', '饲料配方', '001', '2', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (9, '001006', '牦牛投喂', '001', '2', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (10, '001007', '设备操作', '001', '3', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (11, '001008', '设备保养', '001', '3', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (12, '001009', '设备排障', '001', '3', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (13, '001010', '设备维修', '001', '3', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (14, '001011', '牦牛生长', '001', '4', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (15, '001012', '牦牛出栏', '001', '4', '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (16, '001013', '疾病决策', '001', '5', '01', '0', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (17, '002001', '高新技术', '002', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (18, '002002', '农业科技', '002', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (19, '002003', '社会发展', '002', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (20, '002004', '基础研究', '002', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (21, '003001', '涉农政策', '003', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (22, '003002', '产业项目', '003', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (23, '003003', '惠农补贴', '003', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (24, '003004', '共富项目', '003', NULL, '01', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (25, '004001', '兽医人员', '004', '6', '02', '0', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (26, '004002', '专家团队', '004', '6', '02', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (27, '004003', '诊疗机构', '004', '6', '02', '0', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (28, '004004', '医疗设备', '004', '6', '02', '0', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (29, '004005', '专家', '004', '7', '02', '0', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (30, '004006', '技术成果', '004', '7', '02', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (31, '004007', '共享仪器', '004', '7', '02', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (32, '004008', '视频课程', '004', '7', '02', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (33, '005', '视频课程', NULL, NULL, '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (34, '006', '实战培训', NULL, NULL, '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (35, '005001', '基础养殖', '005', '8', '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (36, '005002', '疫病防治', '005', '8', '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (37, '005003', '繁育技术', '005', '8', '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (38, '005004', '政策解读', '005', '8', '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (39, '006001', '未开始', '006', NULL, '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (40, '006002', '报名中', '006', NULL, '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (41, '006003', '已报满', '006', NULL, '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
INSERT INTO `biz_information_category` VALUES (42, '006004', '已截止', '006', NULL, '03', '1', '0', 'admin', '2026-05-23 13:48:46', '', NULL, NULL);
