/* Navicat Premium Dump SQL Source Server : cf-mysql Source Server Type : MySQL Source Server Version : 80042 (8.0.42) Source Host : 192.168.0.81:3326 Source Schema : cf_v1 Target Server Type : MySQL Target Server Version : 80042 (8.0.42) File Encoding : 65001 Date: 22/09/2025 13:31:20 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for f_batch -- ---------------------------- DROP TABLE IF EXISTS `f_batch`; CREATE TABLE `f_batch` ( `batch_num` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '批次号（唯一标识）', `batch_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '批次名称', `chicken_count` int NOT NULL DEFAULT 0 COMMENT '鸡只数量', `hatch_date` date NOT NULL COMMENT '出生日期', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:新建, 1:育成中, 2:完成）', `variety_id` bigint NOT NULL COMMENT '品系ID（复制字段，不随原表变动）', `variety_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '品种（复制字段，不随原表变动）', `lineage` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '系别（复制字段，不随原表变动）', `generation` int NOT NULL DEFAULT 0 COMMENT '代数（复制字段，不随原表变动）', `batch_type` tinyint NOT NULL DEFAULT 0 COMMENT '批次类型（0:育种 1:祖代）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`batch_num`) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, INDEX `batch_number`(`batch_num` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '批次信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_batch -- ---------------------------- -- ---------------------------- -- Table structure for f_sop_bind -- ---------------------------- DROP TABLE IF EXISTS `f_sop_bind`; CREATE TABLE `f_sop_bind` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '批次SOPID', `batch_num` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '批次ID（关联f_batch）', `chicken_id` bigint COMMENT '个体ID', `sop_id` bigint NOT NULL COMMENT 'SOPID（关联f_sop）', `sop_type` tinyint(1) NOT NULL COMMENT 'SOP类型 1:饲喂2：药物3：疫苗', `gender` tinyint(1) NOT NULL COMMENT '性别', `status` tinyint(1) NOT NULL COMMENT '绑定状态（0:已绑定, 1:已解绑）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `sop_id`(`sop_id` ASC) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, INDEX `f_batch_ibfk_1`(`batch_num` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '批次/个体SOP绑定表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for f_breeding_egg -- ---------------------------- DROP TABLE IF EXISTS `f_breeding_egg`; CREATE TABLE `f_breeding_egg` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '种蛋ID', `cage_id` bigint NULL DEFAULT NULL COMMENT '鸡笼ID（关联f_chicken_cage）', `female_chicken_id` bigint NOT NULL COMMENT '母鸡ID（关联f_chicken）', `family_num` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '家系配种ID（关联f_family）', `egg_count` int NOT NULL DEFAULT 0 COMMENT '产蛋数', `egg_type` tinyint NOT NULL DEFAULT 0 COMMENT '蛋分类（0:好种蛋, 1:好菜蛋, 2:畸形蛋, 3:破蛋）', `lay_date` date NOT NULL COMMENT '产蛋日期', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `cage_id`(`cage_id` ASC) USING BTREE, INDEX `female_chicken_id`(`female_chicken_id` ASC) USING BTREE, INDEX `breed_pair_id`(`family_num` ASC) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_breeding_egg_ibfk_1` FOREIGN KEY (`cage_id`) REFERENCES `f_chicken_cage` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_breeding_egg_ibfk_2` FOREIGN KEY (`female_chicken_id`) REFERENCES `f_chicken` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_breeding_egg_ibfk_4` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_breeding_egg_ibfk_5` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '种蛋管理表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_breeding_egg -- ---------------------------- -- ---------------------------- -- Table structure for f_cage_change -- ---------------------------- DROP TABLE IF EXISTS `f_cage_change`; CREATE TABLE `f_cage_change` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '换笼记录ID', `source_cage_id` bigint NULL DEFAULT NULL COMMENT '源鸡笼ID（关联f_chicken_cage）', `target_cage_id` bigint NOT NULL COMMENT '目标鸡笼ID（关联f_chicken_cage）', `chicken_id` bigint NOT NULL COMMENT '鸡只ID（关联f_chicken）', `bind_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '换笼绑定时间', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:待处理, 1:已确认, 2:作废）', `cross_coop` tinyint NOT NULL COMMENT '是否跨鸡舍（0:不跨鸡舍, 1:跨鸡舍）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `source_cage_id`(`source_cage_id` ASC) USING BTREE, INDEX `target_cage_id`(`target_cage_id` ASC) USING BTREE, INDEX `chicken_id`(`chicken_id` ASC) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_cage_change_ibfk_1` FOREIGN KEY (`source_cage_id`) REFERENCES `f_chicken_cage` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_cage_change_ibfk_2` FOREIGN KEY (`target_cage_id`) REFERENCES `f_chicken_cage` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_cage_change_ibfk_3` FOREIGN KEY (`chicken_id`) REFERENCES `f_chicken` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_cage_change_ibfk_4` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_cage_change_ibfk_5` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '换笼管理表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_cage_change -- ---------------------------- -- ---------------------------- -- Table structure for f_chicken -- ---------------------------- DROP TABLE IF EXISTS `f_chicken`; CREATE TABLE `f_chicken` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鸡只ID', `batch_num` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '批次号（关联f_batch）', `gender` tinyint NOT NULL DEFAULT 0 COMMENT '性别（0:公, 1:母）', `hatch_date` date NOT NULL COMMENT '出生日期', `wing_tag_num` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '翅号Num（关联f_wing_tag）', `electronic_id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '电子编号（RFID或唯一标识）', `leg_tag` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '脚号', `family_id` bigint NULL DEFAULT NULL COMMENT '家系ID（可为空）', `cage_id` bigint NULL DEFAULT NULL COMMENT '笼ID（关联f_chicken_cage）', `cull_time` datetime NULL DEFAULT NULL COMMENT '淘汰时间', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:在养, 1:已淘汰, 2:死亡）', `cull_reason` tinyint NULL DEFAULT NULL COMMENT '淘汰原因（“病鸡”、“弱鸡”、“实验”、“老化\r\n（性能下降）”）', `disposal_method` tinyint NULL DEFAULT NULL COMMENT '处置方式（如“无害化”，“食堂”，“屠宰场”等）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `wing_tag_num`(`wing_tag_num` ASC) USING BTREE, INDEX `cage_id`(`cage_id` ASC) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, INDEX `f_chicken_ibfk_1`(`batch_num` ASC) USING BTREE, CONSTRAINT `f_chicken_ibfk_1` FOREIGN KEY (`batch_num`) REFERENCES `f_batch` (`batch_num`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_chicken_ibfk_2` FOREIGN KEY (`wing_tag_num`) REFERENCES `f_wing_tag` (`wing_tag_num`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_chicken_ibfk_3` FOREIGN KEY (`cage_id`) REFERENCES `f_chicken_cage` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_chicken_ibfk_4` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_chicken_ibfk_5` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '鸡只个体信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_chicken -- ---------------------------- -- ---------------------------- -- Table structure for f_chicken_cage -- ---------------------------- DROP TABLE IF EXISTS `f_chicken_cage`; CREATE TABLE `f_chicken_cage` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '鸡笼ID', `cage_num` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '鸡笼编号', `chicken_coop_id` int NOT NULL COMMENT '鸡舍ID（关联鸡舍表）', `manager` bigint NULL DEFAULT NULL COMMENT '管理员（关联用户ID）', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态（0:正常 1:异常）', `max_capacity` int NOT NULL DEFAULT 0 COMMENT '最大容量', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `manager`(`manager` ASC) USING BTREE, INDEX `f_chicken_cage_ibfk_1`(`chicken_coop_id` ASC) USING BTREE, CONSTRAINT `f_chicken_cage_ibfk_1` FOREIGN KEY (`chicken_coop_id`) REFERENCES `f_chicken_coop` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_chicken_cage_ibfk_2` FOREIGN KEY (`manager`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '鸡笼信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_chicken_cage -- ---------------------------- -- ---------------------------- -- Table structure for f_chicken_coop -- ---------------------------- DROP TABLE IF EXISTS `f_chicken_coop`; CREATE TABLE `f_chicken_coop` ( `id` int NOT NULL AUTO_INCREMENT, `coop_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '鸡舍编号', `coop_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '鸡舍名称', `standard_cage_num` int NULL DEFAULT 0 COMMENT '标准笼子数量', `status` tinyint(1) NOT NULL COMMENT '状态(0:正常 1:异常)', `coop_type` tinyint NOT NULL COMMENT '鸡舍类型（1：育成舍 2： 产蛋舍）', `factory` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '厂区', `manager` bigint NULL DEFAULT NULL COMMENT '管理员', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_chicken_coop -- ---------------------------- -- ---------------------------- -- Records of f_chicken_feed -- ---------------------------- -- ---------------------------- -- Table structure for f_chicken_metatarsal -- ---------------------------- DROP TABLE IF EXISTS `f_chicken_metatarsal`; CREATE TABLE `f_chicken_metatarsal` ( `id` bigint NOT NULL AUTO_INCREMENT, `chicken_id` bigint NOT NULL, `record_date` datetime NOT NULL, `metatarsal_length` double NOT NULL COMMENT '跖骨长(mm)', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_chicken_metatarsal -- ---------------------------- -- ---------------------------- -- Table structure for f_chicken_tibia -- ---------------------------- DROP TABLE IF EXISTS `f_chicken_tibia`; CREATE TABLE `f_chicken_tibia` ( `id` bigint NOT NULL AUTO_INCREMENT, `chicken_id` bigint NOT NULL, `record_date` datetime NOT NULL, `tibia_length` double NOT NULL, `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_chicken_tibia -- ---------------------------- -- ---------------------------- -- Records of f_chicken_vaccine -- ---------------------------- -- ---------------------------- -- Table structure for f_chicken_weight -- ---------------------------- DROP TABLE IF EXISTS `f_chicken_weight`; CREATE TABLE `f_chicken_weight` ( `id` bigint NOT NULL AUTO_INCREMENT, `chicken_id` bigint NOT NULL COMMENT '鸡只ID（关联f_chicken）', `record_date` date NOT NULL COMMENT '记录日期（YYYY-MM-DD格式）', `weight_value` double NOT NULL DEFAULT 0 COMMENT '体重值（单位：克）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '鸡体重信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_chicken_weight -- ---------------------------- -- ---------------------------- -- Table structure for f_coop_batch_report -- ---------------------------- DROP TABLE IF EXISTS `f_coop_batch_report`; CREATE TABLE `f_coop_batch_report` ( `id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `title` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL, `report_cycle` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '统计周期 （年：Y 月：M 日：D 季：Q 周：W）', `coop_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'coop|egg (统计育成舍或产蛋舍)', `year` int NOT NULL COMMENT '年', `month` tinyint NULL DEFAULT NULL COMMENT '月', `day` tinyint NULL DEFAULT NULL COMMENT '日', `week` tinyint NULL DEFAULT NULL COMMENT '周', `quarter` tinyint NULL DEFAULT NULL COMMENT '季度', `last_save0` int NOT NULL DEFAULT 0 COMMENT '上日存栏-公', `last_save1` int NOT NULL DEFAULT 0 COMMENT '上日存栏-母', `save0` int NOT NULL DEFAULT 0 COMMENT '本日存栏-公', `save1` int NOT NULL DEFAULT 0 COMMENT '本日存栏-母', `cull0` int NOT NULL DEFAULT 0 COMMENT '本日淘汰数量-公', `cull1` int NOT NULL DEFAULT 0 COMMENT '本日淘汰数量-母', `in0` int NULL DEFAULT 0 COMMENT '本日转入-公', `in1` int NULL DEFAULT 0 COMMENT '本日转入-母', `out0` int NULL DEFAULT 0 COMMENT '本日转出-公', `out1` int NULL DEFAULT 0 COMMENT '本日转出-母', `qualified_egg` int NULL DEFAULT 0 COMMENT '日合格蛋数量', `deformed_egg` int NULL DEFAULT 0 COMMENT '日畸形蛋数量', `break_egg` int NULL DEFAULT 0 COMMENT '日坏蛋数', `egg_production_rate` float NULL DEFAULT NULL COMMENT '日产蛋率', `egg_pass_rate` float NULL DEFAULT NULL COMMENT '种蛋合格率', `chicken0` int NOT NULL DEFAULT 0 COMMENT '公鸡数', `chicken1` int NOT NULL COMMENT '母鸡数', `life_rate` float NULL DEFAULT NULL COMMENT '存活率', `cull_rate` float NULL DEFAULT NULL COMMENT '淘汰率', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_coop_batch_report -- ---------------------------- -- ---------------------------- -- Table structure for f_coop_batch_report_detail -- ---------------------------- DROP TABLE IF EXISTS `f_coop_batch_report_detail`; CREATE TABLE `f_coop_batch_report_detail` ( `id` bigint NOT NULL AUTO_INCREMENT, `report_id` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '报表头id', `coop_id` bigint NOT NULL COMMENT '鸡舍ID', `batch_num` varchar(25) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '批次号', `last_save0` int NOT NULL DEFAULT 0 COMMENT '上日存栏-公', `last_save1` int NOT NULL DEFAULT 0 COMMENT '上日存栏-母', `save0` int NOT NULL DEFAULT 0 COMMENT '本日存栏-公', `save1` int NOT NULL DEFAULT 0 COMMENT '本日存栏-母', `cull0` int NOT NULL DEFAULT 0 COMMENT '本日淘汰数量-公', `cull1` int NOT NULL DEFAULT 0 COMMENT '本日淘汰数量-母', `in0` int NULL DEFAULT 0 COMMENT '本日转入-公', `in1` int NULL DEFAULT 0 COMMENT '本日转入-母', `out0` int NULL DEFAULT 0 COMMENT '本日转出-公', `out1` int NULL DEFAULT 0 COMMENT '本日转出-母', `qualified_egg` int NULL DEFAULT 0 COMMENT '日合格蛋数量', `deformed_egg` int NULL DEFAULT 0 COMMENT '日畸形蛋数量', `break_egg` int NULL DEFAULT 0 COMMENT '日坏蛋数', `egg_production_rate` float NULL DEFAULT NULL COMMENT '日产蛋率', `egg_pass_rate` float NULL DEFAULT NULL COMMENT '日产蛋合格率', `chicken0` int NOT NULL DEFAULT 0 COMMENT '公鸡数', `chicken1` int NOT NULL COMMENT '母鸡数', `cull_rate` float NULL DEFAULT NULL COMMENT '淘汰率', `life_rate` float NULL DEFAULT NULL COMMENT '存活率', `report_date` datetime NULL DEFAULT NULL COMMENT '报表日期', `report_cycle` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '统计周期 （年：Y 月：M 日：D 季：Q 周：W）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_coop_batch_report_detail -- ---------------------------- -- ---------------------------- -- Table structure for f_drug -- ---------------------------- DROP TABLE IF EXISTS `f_drug`; CREATE TABLE `f_drug` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '药品ID', `drug_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '药品名称', `factory` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '生产厂家', `production_date` date NULL DEFAULT NULL COMMENT '生产日期', `expiration_date` date NULL DEFAULT NULL COMMENT '有效期', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:可用, 1:缺货, 2:过期）', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_drug_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_drug_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '药品信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_drug -- ---------------------------- -- ---------------------------- -- Table structure for f_drug_sop -- ---------------------------- DROP TABLE IF EXISTS `f_drug_sop`; CREATE TABLE `f_drug_sop` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '药品SOPID', `sop_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'SOP名称', `gender` tinyint NOT NULL DEFAULT 0 COMMENT '性别', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:启用, 1:禁用, 2:维护中）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_drug_sop_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_drug_sop_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '药品SOP主表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_drug_sop -- ---------------------------- -- ---------------------------- -- Table structure for f_drug_sop_detail -- ---------------------------- DROP TABLE IF EXISTS `f_drug_sop_detail`; CREATE TABLE `f_drug_sop_detail` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '详情ID', `drug_sop_id` bigint NOT NULL COMMENT '药品SOPID（关联f_drug_sop）', `drug_id` bigint NOT NULL COMMENT '药品ID（关联f_drug）', `start_age` int NOT NULL COMMENT '开始日龄', `end_age` int NOT NULL COMMENT '结束日龄', `dosage` double NOT NULL DEFAULT 0 COMMENT '剂量（单位:g/ml）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `drug_sop_id`(`drug_sop_id` ASC) USING BTREE, INDEX `drug_id`(`drug_id` ASC) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_drug_sop_detail_ibfk_1` FOREIGN KEY (`drug_sop_id`) REFERENCES `f_drug_sop` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_drug_sop_detail_ibfk_2` FOREIGN KEY (`drug_id`) REFERENCES `f_drug` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_drug_sop_detail_ibfk_3` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_drug_sop_detail_ibfk_4` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '药品SOP详情表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_drug_sop_detail -- ---------------------------- -- ---------------------------- -- Table structure for f_family -- ---------------------------- DROP TABLE IF EXISTS `f_family`; CREATE TABLE `f_family` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '配种记录ID', `family_num` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '家系号', `male_chicken_id` bigint NOT NULL COMMENT '公鸡ID（关联f_chicken）', `female_chicken_id` bigint NOT NULL COMMENT '母鸡ID（关联f_chicken）', `breed_date` date NOT NULL COMMENT '配种日期', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:正常, 1:异常）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `male_chicken_id`(`male_chicken_id` ASC) USING BTREE, INDEX `female_chicken_id`(`female_chicken_id` ASC) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_family_ibfk_1` FOREIGN KEY (`male_chicken_id`) REFERENCES `f_chicken` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_family_ibfk_2` FOREIGN KEY (`female_chicken_id`) REFERENCES `f_chicken` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_family_ibfk_3` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_family_ibfk_4` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '家系配种管理表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_family -- ---------------------------- -- ---------------------------- -- Table structure for f_feed -- ---------------------------- DROP TABLE IF EXISTS `f_feed`; CREATE TABLE `f_feed` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '饲料ID', `feed_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '饲料名称', `composition_ratio` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '饲料成分及含量（配比）', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:可用, 1:缺货, 2:过期）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_feed_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_feed_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '饲料信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_feed -- ---------------------------- -- ---------------------------- -- Table structure for f_feed_sop -- ---------------------------- DROP TABLE IF EXISTS `f_feed_sop`; CREATE TABLE `f_feed_sop` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '饲养指标ID', `sop_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'SOP名称', `gender` tinyint NOT NULL DEFAULT 0 COMMENT '性别（0:公, 1:母）', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:启用, 1:禁用, 2:维护中）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_feed_sop_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_feed_sop_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '饲养指标主表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_feed_sop -- ---------------------------- -- ---------------------------- -- Table structure for f_feed_sop_detail -- ---------------------------- DROP TABLE IF EXISTS `f_feed_sop_detail`; CREATE TABLE `f_feed_sop_detail` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '详情ID', `feed_sop_id` bigint NOT NULL COMMENT '饲养指标ID（关联f_breed_sop）', `start_age` int NOT NULL COMMENT '起始日龄', `end_age` int NOT NULL COMMENT '停止日龄', `feed_id` bigint NOT NULL COMMENT '饲料ID（关联饲料表）', `feeding_standard` double NOT NULL DEFAULT 0 COMMENT '饲喂标准（单位:g）', `target_weight` double NOT NULL DEFAULT 0 COMMENT '目标体重（单位:g）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `breed_sop_id`(`feed_sop_id` ASC) USING BTREE, INDEX `feed_id`(`feed_id` ASC) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_feed_sop_detail_ibfk_1` FOREIGN KEY (`feed_sop_id`) REFERENCES `f_feed_sop` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_feed_sop_detail_ibfk_2` FOREIGN KEY (`feed_id`) REFERENCES `f_feed` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_feed_sop_detail_ibfk_3` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_feed_sop_detail_ibfk_4` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '饲养指标详情表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_feed_sop_detail -- ---------------------------- -- ---------------------------- -- Table structure for f_incubation -- ---------------------------- DROP TABLE IF EXISTS `f_incubation`; CREATE TABLE `f_incubation` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '入孵记录ID', `incubation_batch_num` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '孵化批次号（唯一标识）', `family_num` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '家系配种ID（关联f_family）', `female_chicken_id` bigint NOT NULL COMMENT '母系ID', `batch_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '批次名称', `variety_id` bigint NULL DEFAULT NULL COMMENT '品系ID（关联f_variety）', `variety_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '品种（复制字段，不随原表变动）', `lineage` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '系别（复制字段，不随原表变动）', `generation` int NOT NULL DEFAULT 0 COMMENT '代数（复制字段，不随原表变动）', `incubation_count` int NOT NULL DEFAULT 0 COMMENT '入孵数量', `light_egg_count` int NOT NULL DEFAULT 0 COMMENT '光蛋数量', `dead_sperm_egg_count` int NOT NULL DEFAULT 0 COMMENT '死精蛋数量', `dead_embryo_egg_count` int NOT NULL DEFAULT 0 COMMENT '死坯胎数量', `weak_chick_count` int NOT NULL DEFAULT 0 COMMENT '弱雏数量', `other_discard_count` int NOT NULL DEFAULT 0 COMMENT '其它淘汰数量', `upload_date` date NOT NULL COMMENT '入孵日期', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `breed_pair_id`(`family_num` ASC) USING BTREE, INDEX `breed_id`(`variety_id` ASC) USING BTREE, INDEX `female_id`(`female_chicken_id` ASC) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_incubation_ibfk_2` FOREIGN KEY (`variety_id`) REFERENCES `f_variety` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_incubation_ibfk_3` FOREIGN KEY (`female_chicken_id`) REFERENCES `f_chicken` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_incubation_ibfk_4` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_incubation_ibfk_5` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '入孵管理表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_incubation -- ---------------------------- -- ---------------------------- -- Table structure for f_measure -- ---------------------------- DROP TABLE IF EXISTS `f_measure`; CREATE TABLE `f_measure` ( `id` bigint NOT NULL AUTO_INCREMENT, `measure_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '测定批次名称', `batch_num` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '批次号', `status` tinyint NOT NULL, `start_time` datetime NOT NULL COMMENT '起始日期', `end_time` datetime NULL DEFAULT NULL COMMENT '结束日期', `start_age` int NOT NULL COMMENT '起始日龄', `end_age` int NULL DEFAULT NULL COMMENT '结束日龄', `feed_id` bigint NOT NULL COMMENT '饲料id', `feed_sop_id` bigint NOT NULL COMMENT '饲喂SOP', `leg_disease_count` int NOT NULL DEFAULT 0 COMMENT '腿病淘汰数', `ascites_count` int NOT NULL DEFAULT 0 COMMENT '腹水淘汰数', `bacterial_count` int NOT NULL DEFAULT 0 COMMENT '细菌感染淘汰数', `trauma_count` int NOT NULL DEFAULT 0 COMMENT '外伤淘汰数', `other_count` int NOT NULL DEFAULT 0 COMMENT '其它淘汰赛', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_measure -- ---------------------------- -- ---------------------------- -- Table structure for f_measure_detail -- ---------------------------- DROP TABLE IF EXISTS `f_measure_detail`; CREATE TABLE `f_measure_detail` ( `id` bigint NOT NULL AUTO_INCREMENT, `measure_id` bigint NOT NULL COMMENT '测定id', `chicken_id` bigint NOT NULL COMMENT '个体id', `status` tinyint NOT NULL COMMENT '测定中，结束，淘汰', `feed_count1` double NOT NULL COMMENT '饲料量1', `feed_count2` double NULL DEFAULT NULL COMMENT '饲料量2', `start_weight` double NOT NULL COMMENT '起始体重', `start_weight_time` datetime NOT NULL COMMENT '起始体重日期', `start_weight_age` int NOT NULL COMMENT '起始体重日龄', `end_weight` double NULL DEFAULT NULL COMMENT '结束体重', `end_weight_time` datetime NULL DEFAULT NULL COMMENT '结束体重日期', `end_weight_age` int NULL DEFAULT NULL COMMENT '结束体重日期', `middle_weight_info` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '中途体重信息', `cage_num` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '笼号', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_measure_detail -- ---------------------------- -- ---------------------------- -- Table structure for f_pull_out -- ---------------------------- DROP TABLE IF EXISTS `f_pull_out`; CREATE TABLE `f_pull_out` ( `id` bigint NOT NULL AUTO_INCREMENT, `coop_id` bigint NOT NULL COMMENT '鸡舍ID', `pull_out_type` tinyint NOT NULL COMMENT '外拉类型（0：祖代厂 1:食堂 2:实验室 3:菜蛋销售）', `pull_out_date` datetime NOT NULL COMMENT '外拉时间', `egg_count` int NOT NULL COMMENT '数量', `egg_type` tinyint NOT NULL COMMENT '蛋的类型（0:好种蛋, 1:好菜蛋, 2:畸形蛋, 3:破蛋）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_pull_out -- ---------------------------- -- ---------------------------- -- Table structure for f_vaccine -- ---------------------------- DROP TABLE IF EXISTS `f_vaccine`; CREATE TABLE `f_vaccine` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '疫苗ID', `vaccine_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '疫苗名称', `vaccine_type` tinyint NOT NULL DEFAULT 0 COMMENT '疫苗种类（0:灭活疫苗, 1:活疫苗, 2:重组蛋白疫苗）', `manufacturer` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '生产厂家', `production_date` date NULL DEFAULT NULL COMMENT '生产日期', `expiration_date` date NULL DEFAULT NULL COMMENT '有效期', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:可用, 1:缺货, 2:过期）', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_vaccine_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_vaccine_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '疫苗信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_vaccine -- ---------------------------- -- ---------------------------- -- Table structure for f_vaccine_drug_conflict -- ---------------------------- DROP TABLE IF EXISTS `f_vaccine_drug_conflict`; CREATE TABLE `f_vaccine_drug_conflict` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '冲突记录ID', `vaccine_id` bigint NOT NULL COMMENT '疫苗ID（关联f_vaccine）', `drug_id` bigint NOT NULL COMMENT '药品ID（关联f_drug）', `conflict_duration` int NOT NULL DEFAULT 0, `start_age` int NOT NULL DEFAULT 0 COMMENT '冲突开始日龄', `end_age` int NOT NULL DEFAULT 0 COMMENT '冲突结束日龄', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `vaccine_id`(`vaccine_id` ASC) USING BTREE, INDEX `drug_id`(`drug_id` ASC) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_vaccine_drug_conflict_ibfk_1` FOREIGN KEY (`vaccine_id`) REFERENCES `f_vaccine` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_vaccine_drug_conflict_ibfk_2` FOREIGN KEY (`drug_id`) REFERENCES `f_drug` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_vaccine_drug_conflict_ibfk_3` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_vaccine_drug_conflict_ibfk_4` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '疫苗与药品冲突记录表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_vaccine_drug_conflict -- ---------------------------- -- ---------------------------- -- Table structure for f_vaccine_sop -- ---------------------------- DROP TABLE IF EXISTS `f_vaccine_sop`; CREATE TABLE `f_vaccine_sop` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '免疫SOPID', `sop_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '免疫计划名称', `gender` tinyint NOT NULL DEFAULT 0 COMMENT '性别', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:启用, 1:禁用, 2:维护中）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_vaccine_sop_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_vaccine_sop_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '免疫SOP主表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_vaccine_sop -- ---------------------------- -- ---------------------------- -- Table structure for f_vaccine_sop_detail -- ---------------------------- DROP TABLE IF EXISTS `f_vaccine_sop_detail`; CREATE TABLE `f_vaccine_sop_detail` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '详情ID', `vaccine_sop_id` bigint NOT NULL COMMENT '免疫SOPID（关联f_vaccine_sop）', `start_age` int NOT NULL COMMENT '开始日龄', `end_age` int NOT NULL COMMENT '结束日龄', `vaccine_id` bigint NOT NULL COMMENT '疫苗id', `dosage` double NOT NULL DEFAULT 0 COMMENT '剂量（单位:g/ml）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `immune_sop_id`(`vaccine_sop_id` ASC) USING BTREE, INDEX `vaccine_id`(`vaccine_id` ASC) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_vaccine_sop_detail_ibfk_1` FOREIGN KEY (`vaccine_sop_id`) REFERENCES `f_vaccine_sop` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_vaccine_sop_detail_ibfk_2` FOREIGN KEY (`vaccine_id`) REFERENCES `f_vaccine` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_vaccine_sop_detail_ibfk_3` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_vaccine_sop_detail_ibfk_4` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '免疫SOP详情表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_vaccine_sop_detail -- ---------------------------- -- ---------------------------- -- Table structure for f_variety -- ---------------------------- DROP TABLE IF EXISTS `f_variety`; CREATE TABLE `f_variety` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '品系ID', `variety_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '品种名', `lineage` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '系别', `generation` int NOT NULL DEFAULT 0 COMMENT '世代（数字）', `purpose` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用途系别 用户单选“父系”或者“母系”', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:空闲, 1:使用中, 2:维护中）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, CONSTRAINT `f_variety_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_variety_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '品系信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_variety -- ---------------------------- -- ---------------------------- -- Table structure for f_wing_tag -- ---------------------------- DROP TABLE IF EXISTS `f_wing_tag`; CREATE TABLE `f_wing_tag` ( `wing_tag_num` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '鸡翅号（唯一标识）', `chicken_id` bigint NULL DEFAULT NULL COMMENT '鸡只ID（关联f_chicken）', `status` tinyint NOT NULL DEFAULT 0 COMMENT '状态（0:闲置, 1:正常）', `create_org` bigint NOT NULL COMMENT '创建组织', `create_by` bigint NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`wing_tag_num`) USING BTREE, INDEX `create_by`(`create_by` ASC) USING BTREE, INDEX `update_by`(`update_by` ASC) USING BTREE, INDEX `chicken_id`(`chicken_id` ASC) USING BTREE, INDEX `status`(`status` ASC) USING BTREE, CONSTRAINT `f_wing_tag_ibfk_1` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_wing_tag_ibfk_2` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '翅号管理表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of f_wing_tag -- ---------------------------- -- ---------------------------- -- Table structure for gen_table -- ---------------------------- DROP TABLE IF EXISTS `gen_table`; CREATE TABLE `gen_table` ( `table_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `data_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '数据源名称', `table_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '表名称', `table_comment` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '表描述', `sub_table_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '关联子表的表名', `sub_table_fk_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '子表关联的外键名', `class_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '实体类名称', `tpl_category` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）', `package_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '生成包路径', `module_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '生成模块名', `business_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '生成业务名', `function_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '生成功能名', `function_author` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '生成功能作者', `gen_type` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）', `gen_path` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '/' COMMENT '生成路径（不填默认项目路径）', `options` varchar(1000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '其它生成选项', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`table_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '代码生成业务表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of gen_table -- ---------------------------- -- ---------------------------- -- Table structure for gen_table_column -- ---------------------------- DROP TABLE IF EXISTS `gen_table_column`; CREATE TABLE `gen_table_column` ( `column_id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号', `table_id` bigint NULL DEFAULT NULL COMMENT '归属表编号', `column_name` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '列名称', `column_comment` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '列描述', `column_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '列类型', `java_type` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'JAVA类型', `java_field` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'JAVA字段名', `is_pk` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '是否主键（1是）', `is_increment` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '是否自增（1是）', `is_required` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '是否必填（1是）', `is_insert` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '是否为插入字段（1是）', `is_edit` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '是否编辑字段（1是）', `is_list` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '是否列表字段（1是）', `is_query` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '是否查询字段（1是）', `is_sort` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '是否排序字段（1是）', `query_type` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）', `html_type` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）', `dict_type` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '字典类型', `sort` int NULL DEFAULT NULL COMMENT '排序', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`column_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of gen_table_column -- ---------------------------- -- ---------------------------- -- Table structure for sys_client -- ---------------------------- DROP TABLE IF EXISTS `sys_client`; CREATE TABLE `sys_client` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', `client_id` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '客户端id', `client_key` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '客户端key', `client_secret` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '客户端秘钥', `grant_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '授权类型', `device_type` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '设备类型', `active_timeout` int NULL DEFAULT 1800 COMMENT 'token活跃超时时间', `timeout` int NULL DEFAULT 604800 COMMENT 'token固定超时', `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '系统授权表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_client -- ---------------------------- -- ---------------------------- -- Table structure for sys_config -- ---------------------------- DROP TABLE IF EXISTS `sys_config`; CREATE TABLE `sys_config` ( `config_id` bigint NOT NULL AUTO_INCREMENT COMMENT '参数主键', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `config_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '参数名称', `config_key` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '参数键名', `config_value` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '参数键值', `config_type` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'N' COMMENT '系统内置（Y是 N否）', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`config_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '参数配置表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_config -- ---------------------------- -- ---------------------------- -- Table structure for sys_dict_data -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_data`; CREATE TABLE `sys_dict_data` ( `dict_code` bigint NOT NULL AUTO_INCREMENT COMMENT '字典编码', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `dict_sort` int NULL DEFAULT 0 COMMENT '字典排序', `dict_label` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '字典标签', `dict_value` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '字典键值', `dict_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '字典类型', `css_class` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '样式属性（其他样式扩展）', `list_class` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '表格回显样式', `is_default` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'N' COMMENT '是否默认（Y是 N否）', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`dict_code`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1071 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '字典数据表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_dict_data -- ---------------------------- -- ---------------------------- -- Table structure for sys_dict_type -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_type`; CREATE TABLE `sys_dict_type` ( `dict_id` bigint NOT NULL AUTO_INCREMENT COMMENT '字典主键', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `dict_name` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '字典名称', `dict_type` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '字典类型', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`dict_id`) USING BTREE, UNIQUE INDEX `tenant_id`(`tenant_id` ASC, `dict_type` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1019 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '字典类型表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_dict_type -- ---------------------------- -- ---------------------------- -- Table structure for sys_login_log -- ---------------------------- DROP TABLE IF EXISTS `sys_login_log`; CREATE TABLE `sys_login_log` ( `info_id` bigint NOT NULL AUTO_INCREMENT COMMENT '访问ID', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `user_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '用户账号', `client_key` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '客户端', `device_type` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '设备类型', `ipaddr` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '登录IP地址', `login_location` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '登录地点', `browser` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '浏览器类型', `os` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '操作系统', `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '登录状态（0成功 1失败）', `msg` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '提示消息', `login_time` datetime NULL DEFAULT NULL COMMENT '访问时间', PRIMARY KEY (`info_id`) USING BTREE, INDEX `idx_sys_loginLog_s`(`status` ASC) USING BTREE, INDEX `idx_sys_loginLog_lt`(`login_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1238 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '系统访问记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `menu_id` bigint NOT NULL AUTO_INCREMENT COMMENT '菜单ID', `menu_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '菜单名称', `parent_id` bigint NULL DEFAULT 0 COMMENT '父菜单ID', `order_num` int NULL DEFAULT 0 COMMENT '显示顺序', `path` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '路由地址', `component` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '组件路径', `query_param` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '路由参数', `is_frame` int NULL DEFAULT 1 COMMENT '是否为外链（0是 1否）', `is_cache` int NULL DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）', `menu_type` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）', `visible` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '显示状态（0显示 1隐藏）', `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0正常 1停用）', `perms` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '权限标识', `icon` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '#' COMMENT '菜单图标', `btn_class` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '按钮样式', `btn_script` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '按钮脚本', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`menu_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10184 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '菜单权限表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_notice -- ---------------------------- DROP TABLE IF EXISTS `sys_notice`; CREATE TABLE `sys_notice` ( `notice_id` bigint NOT NULL AUTO_INCREMENT COMMENT '公告ID', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `notice_title` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '公告标题', `notice_type` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '公告类型（1通知 2公告）', `notice_content` longblob NULL COMMENT '公告内容', `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`notice_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '通知公告表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_notice -- ---------------------------- -- ---------------------------- -- Table structure for sys_notice_status -- ---------------------------- DROP TABLE IF EXISTS `sys_notice_status`; CREATE TABLE `sys_notice_status` ( `user_id` bigint NOT NULL COMMENT '用户ID', `message_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '消息ID', `message_type` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '消息类型', `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '阅读状态（0未读 1已读）', PRIMARY KEY (`user_id`, `message_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '消息阅读表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_notice_status -- ---------------------------- -- ---------------------------- -- Table structure for sys_oper_log -- ---------------------------- DROP TABLE IF EXISTS `sys_oper_log`; CREATE TABLE `sys_oper_log` ( `oper_id` bigint NOT NULL AUTO_INCREMENT COMMENT '日志主键', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `title` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '模块标题', `business_type` int NULL DEFAULT 0 COMMENT '业务类型（0其它 1新增 2修改 3删除）', `method` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '方法名称', `request_method` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '请求方式', `operator_type` int NULL DEFAULT 0 COMMENT '操作类别（0其它 1后台用户 2手机端用户）', `oper_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '操作人员', `org_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '组织机构名称', `oper_url` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '请求URL', `oper_ip` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '主机地址', `oper_location` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '操作地点', `oper_param` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '请求参数', `json_result` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '返回参数', `status` int NULL DEFAULT 0 COMMENT '操作状态（0正常 1异常）', `error_msg` varchar(4000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '错误消息', `oper_time` datetime NULL DEFAULT NULL COMMENT '操作时间', `cost_time` bigint NULL DEFAULT 0 COMMENT '消耗时间', PRIMARY KEY (`oper_id`) USING BTREE, INDEX `idx_sys_oper_log_bt`(`business_type` ASC) USING BTREE, INDEX `idx_sys_oper_log_s`(`status` ASC) USING BTREE, INDEX `idx_sys_oper_log_ot`(`oper_time` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2109 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '操作日志记录' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_oper_log -- ---------------------------- -- ---------------------------- -- Table structure for sys_org -- ---------------------------- DROP TABLE IF EXISTS `sys_org`; CREATE TABLE `sys_org` ( `org_id` bigint NOT NULL AUTO_INCREMENT COMMENT '组织机构id', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `parent_id` bigint NULL DEFAULT 0 COMMENT '父组织机构id', `ancestors` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '祖级列表', `org_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '组织机构名称', `org_category` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '组织机构类别编码', `order_num` int NULL DEFAULT 0 COMMENT '显示顺序', `leader` bigint NULL DEFAULT NULL COMMENT '负责人', `phone` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系电话', `email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '邮箱', `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '组织机构状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`org_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1001 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '组织机构表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_org -- ---------------------------- -- ---------------------------- -- Table structure for sys_oss -- ---------------------------- DROP TABLE IF EXISTS `sys_oss`; CREATE TABLE `sys_oss` ( `oss_id` bigint NOT NULL AUTO_INCREMENT COMMENT '对象存储主键', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `file_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '文件名', `original_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '原名', `file_suffix` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '文件后缀名', `url` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'URL地址', `ext1` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL COMMENT '扩展字段', `object_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '文件标识', `service` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'minio' COMMENT '服务商', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_by` bigint NULL DEFAULT NULL COMMENT '上传人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新人', PRIMARY KEY (`oss_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = 'OSS对象存储表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_oss -- ---------------------------- -- ---------------------------- -- Table structure for sys_oss_config -- ---------------------------- DROP TABLE IF EXISTS `sys_oss_config`; CREATE TABLE `sys_oss_config` ( `oss_config_id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `config_key` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '' COMMENT '配置key', `access_key` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT 'accessKey', `secret_key` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '秘钥', `bucket_name` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '桶名称', `prefix` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '前缀', `endpoint` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '访问站点', `domain` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '自定义域名', `is_https` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'N' COMMENT '是否https（Y=是,N=否）', `region` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '域', `access_policy` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT '1' COMMENT '桶权限类型(0=private 1=public 2=custom)', `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '1' COMMENT '是否默认（0=是,1=否）', `ext1` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '扩展字段', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`oss_config_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '对象存储配置表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_oss_config -- ---------------------------- -- ---------------------------- -- Table structure for sys_post -- ---------------------------- DROP TABLE IF EXISTS `sys_post`; CREATE TABLE `sys_post` ( `post_id` bigint NOT NULL AUTO_INCREMENT COMMENT '岗位ID', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `org_id` bigint NOT NULL COMMENT '组织机构id', `post_code` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '岗位编码', `post_category` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '岗位类别编码', `post_name` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '岗位名称', `post_sort` int NOT NULL COMMENT '显示顺序', `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '状态（0正常 1停用）', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`post_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '岗位信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_post -- ---------------------------- -- ---------------------------- -- Table structure for sys_role -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `role_id` bigint NOT NULL AUTO_INCREMENT COMMENT '角色ID', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `role_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '角色名称', `role_key` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '角色权限字符串', `role_sort` int NOT NULL COMMENT '显示顺序', `data_scope` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '1' COMMENT '数据范围（1：全部数据权限 2：自定数据权限 3：本组织机构数据权限 4：本组织机构及以下数据权限 ）', `menu_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '菜单树选择项是否关联显示', `org_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '组织机构树选择项是否关联显示', `is_static` tinyint(1) NULL DEFAULT 0 COMMENT '是否静态角色（0否 1是）', `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '角色状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`role_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1002 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '角色信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_role -- ---------------------------- -- ---------------------------- -- Table structure for sys_role_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `role_id` bigint NOT NULL COMMENT '角色ID', `menu_id` bigint NOT NULL COMMENT '菜单ID', PRIMARY KEY (`role_id`, `menu_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_role_menu -- ---------------------------- -- ---------------------------- -- Table structure for sys_role_org -- ---------------------------- DROP TABLE IF EXISTS `sys_role_org`; CREATE TABLE `sys_role_org` ( `role_id` bigint NOT NULL COMMENT '角色ID', `org_id` bigint NOT NULL COMMENT '组织机构ID', PRIMARY KEY (`role_id`, `org_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '角色和组织机构关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_role_org -- ---------------------------- -- ---------------------------- -- Table structure for sys_social -- ---------------------------- DROP TABLE IF EXISTS `sys_social`; CREATE TABLE `sys_social` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id` bigint NOT NULL COMMENT '用户ID', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户id', `auth_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '平台+平台唯一id', `source` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户来源', `open_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '平台编号唯一id', `user_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '登录账号', `nick_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '用户昵称', `email` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '用户邮箱', `avatar` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '头像地址', `access_token` varchar(2000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户的授权令牌', `expire_in` int NULL DEFAULT NULL COMMENT '用户的授权令牌的有效期，部分平台可能没有', `refresh_token` varchar(2000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '刷新令牌，部分平台可能没有', `access_code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '平台的授权信息，部分平台可能没有', `union_id` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户的 unionid', `scope` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '授予的权限，部分平台可能没有', `token_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '个别平台的授权信息，部分平台可能没有', `id_token` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'id token，部分平台可能没有', `mac_algorithm` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '小米平台用户的附带属性，部分平台可能没有', `mac_key` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '小米平台用户的附带属性，部分平台可能没有', `code` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '用户的授权code，部分平台可能没有', `oauth_token` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Twitter平台用户的附带属性，部分平台可能没有', `oauth_token_secret` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT 'Twitter平台用户的附带属性，部分平台可能没有', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '社会化关系表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_social -- ---------------------------- -- ---------------------------- -- Table structure for sys_tenant -- ---------------------------- DROP TABLE IF EXISTS `sys_tenant`; CREATE TABLE `sys_tenant` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '租户编号', `contact_user_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系人', `contact_phone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '联系电话', `company_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '企业名称', `license_number` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '统一社会信用代码', `address` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '地址', `intro` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '企业简介', `domain` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '域名', `remark` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', `package_id` bigint NULL DEFAULT NULL COMMENT '租户套餐编号', `expire_time` datetime NULL DEFAULT NULL COMMENT '过期时间', `account_count` int NULL DEFAULT -1 COMMENT '用户数量（-1不限制）', `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '租户状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '租户表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_tenant -- ---------------------------- -- ---------------------------- -- Table structure for sys_tenant_package -- ---------------------------- DROP TABLE IF EXISTS `sys_tenant_package`; CREATE TABLE `sys_tenant_package` ( `package_id` bigint NOT NULL AUTO_INCREMENT COMMENT '租户套餐id', `package_name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '套餐名称', `menu_ids` varchar(3000) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '关联菜单id', `remark` varchar(200) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', `menu_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '菜单树选择项是否关联显示', `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`package_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '租户套餐表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_tenant_package -- ---------------------------- -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `user_id` bigint NOT NULL AUTO_INCREMENT COMMENT '用户ID', `tenant_id` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `org_id` bigint NULL DEFAULT NULL COMMENT '组织机构ID', `user_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户账号', `nick_name` varchar(30) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '用户昵称', `user_type` varchar(10) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT 'sys_user' COMMENT '用户类型（sys_user系统用户）', `email` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '用户邮箱', `phonenumber` varchar(11) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '手机号码', `sex` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）', `avatar` bigint NULL DEFAULT NULL COMMENT '头像地址', `password` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '密码', `photo` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '照片', `birth` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '生日', `id_code` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '身份证', `hire_date` varchar(100) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '入职日期', `status` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `login_ip` varchar(128) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT '' COMMENT '最后登录IP', `login_date` datetime NULL DEFAULT NULL COMMENT '最后登录时间', `create_org` bigint NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1001 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户信息表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_user -- ---------------------------- -- ---------------------------- -- Table structure for sys_user_post -- ---------------------------- DROP TABLE IF EXISTS `sys_user_post`; CREATE TABLE `sys_user_post` ( `user_id` bigint NOT NULL COMMENT '用户ID', `post_id` bigint NOT NULL COMMENT '岗位ID', PRIMARY KEY (`user_id`, `post_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_user_post -- ---------------------------- -- ---------------------------- -- Table structure for sys_user_role -- ---------------------------- DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `user_id` bigint NOT NULL COMMENT '用户ID', `role_id` bigint NOT NULL COMMENT '角色ID', PRIMARY KEY (`user_id`, `role_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci COMMENT = '用户和角色关联表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of sys_user_role -- ---------------------------- -- ---------------------------- -- Table structure for xxl_job_group -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_group`; CREATE TABLE `xxl_job_group` ( `id` int NOT NULL AUTO_INCREMENT, `app_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行器AppName', `title` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行器名称', `address_type` tinyint NOT NULL DEFAULT 0 COMMENT '执行器地址类型：0=自动注册、1=手动录入', `address_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '执行器地址列表，多地址逗号分隔', `update_time` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of xxl_job_group -- ---------------------------- -- ---------------------------- -- Table structure for xxl_job_info -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_info`; CREATE TABLE `xxl_job_info` ( `id` int NOT NULL AUTO_INCREMENT, `job_group` int NOT NULL COMMENT '执行器主键ID', `job_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `add_time` datetime NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, `author` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '作者', `alarm_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '报警邮件', `schedule_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'NONE' COMMENT '调度类型', `schedule_conf` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '调度配置，值含义取决于调度类型', `misfire_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'DO_NOTHING' COMMENT '调度过期策略', `executor_route_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行器路由策略', `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行器任务handler', `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行器任务参数', `executor_block_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '阻塞处理策略', `executor_timeout` int NOT NULL DEFAULT 0 COMMENT '任务执行超时时间，单位秒', `executor_fail_retry_count` int NOT NULL DEFAULT 0 COMMENT '失败重试次数', `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'GLUE类型', `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'GLUE源代码', `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'GLUE备注', `glue_updatetime` datetime NULL DEFAULT NULL COMMENT 'GLUE更新时间', `child_jobid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子任务ID，多个逗号分隔', `trigger_status` tinyint NOT NULL DEFAULT 0 COMMENT '调度状态：0-停止，1-运行', `trigger_last_time` bigint NOT NULL DEFAULT 0 COMMENT '上次调度时间', `trigger_next_time` bigint NOT NULL DEFAULT 0 COMMENT '下次调度时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of xxl_job_info -- ---------------------------- -- ---------------------------- -- Table structure for xxl_job_lock -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_lock`; CREATE TABLE `xxl_job_lock` ( `lock_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '锁名称', PRIMARY KEY (`lock_name`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of xxl_job_lock -- ---------------------------- -- ---------------------------- -- Table structure for xxl_job_log -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_log`; CREATE TABLE `xxl_job_log` ( `id` bigint NOT NULL AUTO_INCREMENT, `job_group` int NOT NULL COMMENT '执行器主键ID', `job_id` int NOT NULL COMMENT '任务，主键ID', `executor_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行器地址，本次执行的地址', `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行器任务handler', `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行器任务参数', `executor_sharding_param` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '执行器任务分片参数，格式如 1/2', `executor_fail_retry_count` int NOT NULL DEFAULT 0 COMMENT '失败重试次数', `trigger_time` datetime NULL DEFAULT NULL COMMENT '调度-时间', `trigger_code` int NOT NULL COMMENT '调度-结果', `trigger_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '调度-日志', `handle_time` datetime NULL DEFAULT NULL COMMENT '执行-时间', `handle_code` int NOT NULL COMMENT '执行-状态', `handle_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '执行-日志', `alarm_status` tinyint NOT NULL DEFAULT 0 COMMENT '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败', PRIMARY KEY (`id`) USING BTREE, INDEX `I_trigger_time`(`trigger_time` ASC) USING BTREE, INDEX `I_handle_code`(`handle_code` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 45 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of xxl_job_log -- ---------------------------- -- ---------------------------- -- Table structure for xxl_job_log_report -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_log_report`; CREATE TABLE `xxl_job_log_report` ( `id` int NOT NULL AUTO_INCREMENT, `trigger_day` datetime NULL DEFAULT NULL COMMENT '调度-时间', `running_count` int NOT NULL DEFAULT 0 COMMENT '运行中-日志数量', `suc_count` int NOT NULL DEFAULT 0 COMMENT '执行成功-日志数量', `fail_count` int NOT NULL DEFAULT 0 COMMENT '执行失败-日志数量', `update_time` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `i_trigger_day`(`trigger_day` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of xxl_job_log_report -- ---------------------------- -- ---------------------------- -- Table structure for xxl_job_logglue -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_logglue`; CREATE TABLE `xxl_job_logglue` ( `id` int NOT NULL AUTO_INCREMENT, `job_id` int NOT NULL COMMENT '任务，主键ID', `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'GLUE类型', `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'GLUE源代码', `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'GLUE备注', `add_time` datetime NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of xxl_job_logglue -- ---------------------------- -- ---------------------------- -- Table structure for xxl_job_registry -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_registry`; CREATE TABLE `xxl_job_registry` ( `id` int NOT NULL AUTO_INCREMENT, `registry_group` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `registry_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `registry_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `update_time` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `i_g_k_v`(`registry_group` ASC, `registry_key` ASC, `registry_value` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 64 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of xxl_job_registry -- ---------------------------- -- ---------------------------- -- Table structure for xxl_job_user -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_user`; CREATE TABLE `xxl_job_user` ( `id` int NOT NULL AUTO_INCREMENT, `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号', `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码', `role` tinyint NOT NULL COMMENT '角色：0-普通用户、1-管理员', `permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限：执行器ID列表，多个逗号分割', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `i_username`(`username` ASC) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for f_qualification -- ---------------------------- DROP TABLE IF EXISTS `f_qualification`; CREATE TABLE `f_qualification` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资质名称，如：高压电工证', `type_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '资质类型编码（如：HOT_WORK-动火作业, HIGH_ALTITUDE-高空作业）', `certificate_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '证件照片路径（URL或相对路径）', `valid_from` date NOT NULL COMMENT '有效期开始时间', `valid_to` date NOT NULL COMMENT '有效期结束时间', `user_id` bigint(20) NOT NULL COMMENT '员工ID，关联 sys_user 表', `post_id` bigint(20) NULL DEFAULT NULL COMMENT '岗位ID，关联岗位管理表', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人', `update_time` datetime NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_user_id`(`user_id`) USING BTREE, INDEX `idx_post_id`(`post_id`) USING BTREE, INDEX `idx_valid_to`(`valid_to`) USING BTREE, INDEX `idx_type_code`(`type_code`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '员工资质证书表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_batch_coop -- ---------------------------- DROP TABLE IF EXISTS `f_batch_coop`; CREATE TABLE `f_batch_coop` ( `id` bigint(20) NOT NULL, `batch_num` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `coop_id` bigint(20) NOT NULL, `gender` tinyint(4) NOT NULL COMMENT '性别', `chicken_count` int(11) NOT NULL DEFAULT 0 COMMENT '实际数量', `create_org` bigint(20) NOT NULL COMMENT '创建组织', `create_by` bigint(20) NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint(20) NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_coop_change -- ---------------------------- DROP TABLE IF EXISTS `f_coop_change`; CREATE TABLE `f_coop_change` ( `id` bigint(20) NOT NULL, `source_coop_id` bigint(20) NULL DEFAULT NULL, `target_coop_id` bigint(20) NOT NULL, `batch_num` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `gender` tinyint(4) NOT NULL COMMENT '性别', `chicken_count` int(11) NOT NULL DEFAULT 0 COMMENT '鸡数量', `bind_time` datetime NOT NULL, `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:待处理, 1:已确认, 2:作废）', `create_org` bigint(20) NOT NULL COMMENT '创建组织', `create_by` bigint(20) NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint(20) NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_drug_record -- ---------------------------- DROP TABLE IF EXISTS `f_drug_record`; CREATE TABLE `f_drug_record` ( `id` bigint(20) NOT NULL, `batch_num` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `chicken_id` bigint(20) NULL DEFAULT NULL, `drug_id` bigint(20) NOT NULL COMMENT '药品ID', `count` float NOT NULL DEFAULT 0 COMMENT '投喂数量', `gender` tinyint(4) NOT NULL, `record_date` datetime NULL DEFAULT NULL COMMENT '记录时间', `create_org` bigint(20) NOT NULL COMMENT '创建组织', `create_by` bigint(20) NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint(20) NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_feed_record -- ---------------------------- DROP TABLE IF EXISTS `f_feed_record`; CREATE TABLE `f_feed_record` ( `id` bigint(20) NOT NULL, `batch_num` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `chicken_id` bigint(20) NULL DEFAULT NULL, `feed_id` bigint(20) NOT NULL, `count` float NOT NULL DEFAULT 0 COMMENT '投喂数量', `gender` tinyint(4) NOT NULL, `record_date` datetime NULL DEFAULT NULL COMMENT '记录时间', `create_org` bigint(20) NOT NULL COMMENT '创建组织', `create_by` bigint(20) NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint(20) NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_vaccine_record -- ---------------------------- DROP TABLE IF EXISTS `f_vaccine_record`; CREATE TABLE `f_vaccine_record` ( `id` bigint(20) NOT NULL, `batch_num` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `chicken_id` bigint(20) NULL DEFAULT NULL, `vaccine_id` bigint(20) NOT NULL COMMENT '疫苗ID', `count` float NOT NULL DEFAULT 0 COMMENT '投喂数量', `gender` tinyint(4) NOT NULL, `record_date` datetime NULL DEFAULT NULL COMMENT '记录时间', `create_org` bigint(20) NOT NULL COMMENT '创建组织', `create_by` bigint(20) NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_by` bigint(20) NOT NULL COMMENT '更新人', `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Procedure structure for generate_wing_tags_batched -- ---------------------------- DROP PROCEDURE IF EXISTS `generate_wing_tags_batched`; delimiter ;; CREATE PROCEDURE `generate_wing_tags_batched`() BEGIN DECLARE batch_start INT DEFAULT 1; DECLARE batch_end INT DEFAULT 999999; DECLARE tag_id VARCHAR(20); DECLARE i INT; WHILE batch_start <= 999999 DO SET i = batch_start; WHILE i <= batch_end AND i <= 999999 DO SET tag_id = LPAD(i, 6, '0'); INSERT INTO f_wing_tag VALUES ( tag_id, NULL, 0, 100, 1, NOW(), 1, NOW(), NULL, '0' ); SET i = i + 1; END WHILE; -- 输出进度 SELECT CONCAT('Inserted records from ', batch_start, ' to ', LEAST(batch_end, 999999)) as progress; SET batch_start = batch_end + 1; SET batch_end = batch_end + 100000; COMMIT; END WHILE; END ;; delimiter ; SET FOREIGN_KEY_CHECKS = 1;