/* Navicat Premium Dump SQL Source Server : 104-3316 Source Server Type : MySQL Source Server Version : 50744 (5.7.44) Source Host : 192.168.0.104:3316 Source Schema : ChickenFarmDB_DEV2 Target Server Type : MySQL Target Server Version : 50744 (5.7.44) File Encoding : 65001 Date: 11/11/2025 09:29:18 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for d_device -- ---------------------------- DROP TABLE IF EXISTS `d_device`; CREATE TABLE `d_device` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '设备ID', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备名称', `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '设备类型', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（ 0：正常工作中 1：维修中 2：带病运行 3：退役）', `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '位置', `manufacturer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '厂家', `installation_date` date NULL DEFAULT NULL COMMENT '安装日期', `responsible_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人', `responsible_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人电话', `manual` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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, INDEX `idx_device_name`(`name`) USING BTREE, INDEX `idx_device_status`(`status`) USING BTREE, INDEX `idx_device_location`(`location`) USING BTREE, INDEX `idx_device_manufacturer`(`manufacturer`) USING BTREE, INDEX `idx_device_create_by`(`create_by`) USING BTREE, INDEX `idx_device_update_by`(`update_by`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '设备资产台账表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for d_device_order -- ---------------------------- DROP TABLE IF EXISTS `d_device_order`; CREATE TABLE `d_device_order` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '工单ID', `task_id` bigint(20) NULL DEFAULT NULL COMMENT '任务ID', `order_no` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工单编号', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工单标题', `device_id` int(11) NOT NULL COMMENT '设备ID', `order_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '工单类型（1:故障报修 2:保养管理 3:清洁消毒）', `clean_type` tinyint(4) NULL DEFAULT NULL COMMENT '清洁消毒类型（1:清洁 2:消毒）', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '工单内容', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '工单状态（0:待处理 1:处理中 2:已暂缓 3:待验收 4:验收未通过 5:已完成）', `reporter_id` bigint(20) NOT NULL COMMENT '报修人ID', `report_time` datetime NOT NULL COMMENT '报修时间', `receiver_id` bigint(20) NULL DEFAULT NULL COMMENT '接收人ID', `receive_time` datetime NULL DEFAULT NULL COMMENT '接收时间', `petty_workers` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '小工', `complete_time` datetime NULL DEFAULT NULL COMMENT '完成时间', `suspend_reason` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '暂缓原因', `suspend_time` datetime NULL DEFAULT NULL COMMENT '暂缓时间', `resume_time` datetime NULL DEFAULT NULL COMMENT '恢复时间', `acceptance_time` datetime NULL DEFAULT NULL COMMENT '验收时间', `acceptance_result` tinyint(4) NULL DEFAULT NULL COMMENT '验收结果（1:通过 2:拒绝）', `acceptance_remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '验收备注', `acceptor_id` bigint(20) NULL DEFAULT NULL COMMENT '验收人ID', `fault_duration` float NULL DEFAULT 0 COMMENT '故障耗时（单位：小时）', `suspend_duration` float NULL DEFAULT 0 COMMENT '暂缓时长（单位：小时）', `attachment_urls` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '附件URL列表（JSON格式）', `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, UNIQUE INDEX `uk_order_no`(`order_no`) USING BTREE, INDEX `idx_device_id`(`device_id`) USING BTREE, INDEX `idx_order_type`(`order_type`) USING BTREE, INDEX `idx_status`(`status`) USING BTREE, INDEX `idx_reporter_id`(`reporter_id`) USING BTREE, INDEX `idx_receiver_id`(`receiver_id`) USING BTREE, INDEX `idx_create_time`(`create_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工单表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for d_device_order_assistant -- ---------------------------- DROP TABLE IF EXISTS `d_device_order_assistant`; CREATE TABLE `d_device_order_assistant` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `order_id` bigint(20) NOT NULL COMMENT '工单ID', `user_id` bigint(20) NOT NULL COMMENT '用户ID', `work_hours` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '工时', `work_content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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, INDEX `idx_order_id`(`order_id`) USING BTREE, INDEX `idx_user_id`(`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工单协助人关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for d_device_order_flow -- ---------------------------- DROP TABLE IF EXISTS `d_device_order_flow`; CREATE TABLE `d_device_order_flow` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流转记录ID', `order_id` bigint(20) NOT NULL COMMENT '工单ID', `flow_type` tinyint(4) NOT NULL COMMENT '流转类型（1:创建 2:接收 3:提交验收 4:验收通过 5:验收拒绝 6:关闭）', `operator_id` bigint(20) NOT NULL COMMENT '操作人ID', `operate_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '操作内容/说明', `attachment_urls` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '附件URL列表', `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, INDEX `idx_order_id`(`order_id`) USING BTREE, INDEX `idx_flow_type`(`flow_type`) USING BTREE, INDEX `idx_operator_id`(`operator_id`) USING BTREE, INDEX `idx_operate_time`(`operate_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '工单流转记录表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for d_device_task -- ---------------------------- DROP TABLE IF EXISTS `d_device_task`; CREATE TABLE `d_device_task` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务ID', `task_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '保养任务名称', `task_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保养任务描述', `task_type` tinyint(4) NOT NULL COMMENT '任务类型（1:设备保养 2:设备清洁）', `device_id` bigint(20) NOT NULL COMMENT '设备ID', `cycle` float NOT NULL DEFAULT 0 COMMENT '保养周期(小时)', `executor_id` bigint(20) NOT NULL COMMENT '执行责任人ID', `acceptor_id` bigint(20) NOT NULL COMMENT '验收责任人ID', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:启用 1:停用）', `startTime` datetime NULL DEFAULT NULL COMMENT '开始时间', `endTime` datetime NULL DEFAULT NULL COMMENT '结束时间', `lastCreateTime` datetime NULL DEFAULT NULL COMMENT '最后创建工单时间', `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` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_device_id`(`device_id`) USING BTREE, INDEX `idx_task_name`(`task_name`) USING BTREE, INDEX `idx_task_type`(`task_type`) USING BTREE, INDEX `idx_executor_id`(`executor_id`) USING BTREE, INDEX `idx_acceptor_id`(`acceptor_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '设备任务表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for d_inspection_checkin -- ---------------------------- DROP TABLE IF EXISTS `d_inspection_checkin`; CREATE TABLE `d_inspection_checkin` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '点检签到ID', `inspection_rule_id` bigint(20) NOT NULL COMMENT '点检任务ID', `inspector_id` bigint(20) NOT NULL COMMENT '点检人ID', `planned_sequence` int(11) NOT NULL COMMENT '点检计划次序', `execute_time` datetime NULL DEFAULT NULL COMMENT '执行时间', `plan_time` datetime NULL DEFAULT NULL COMMENT '计划时间', `image_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '签到图片', `checkin_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:正常 1:异常）', `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, INDEX `idx_inspection_rule_id`(`inspection_rule_id`) USING BTREE, INDEX `idx_inspector_id`(`inspector_id`) USING BTREE, INDEX `idx_execute_time`(`execute_time`) USING BTREE, INDEX `idx_status`(`checkin_status`) USING BTREE, INDEX `idx_create_by`(`create_by`) USING BTREE, INDEX `idx_update_by`(`update_by`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点检签到表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for d_inspection_rule -- ---------------------------- DROP TABLE IF EXISTS `d_inspection_rule`; CREATE TABLE `d_inspection_rule` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '点检规则ID', `task_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '点检任务名称', `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地点', `cycle_hours` float NOT NULL COMMENT '点检周期（小时）', `tolerance_hours` float NULL DEFAULT NULL COMMENT '允许误差范围（小时）', `start_time` datetime NULL DEFAULT NULL COMMENT '点检开始时间', `end_time` datetime NULL DEFAULT NULL COMMENT '点检结束时间', `required_count` int(11) NOT NULL COMMENT '需点检总次数', `actual_count` int(11) NOT NULL DEFAULT 0 COMMENT '实际点检次数', `missed_count` int(11) NOT NULL DEFAULT 0 COMMENT '漏检次数', `executor_id` bigint(20) NULL DEFAULT NULL COMMENT '执行人ID', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:正常 1:停用）', `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, INDEX `idx_task_name`(`task_name`) USING BTREE, INDEX `idx_executor_id`(`executor_id`) USING BTREE, INDEX `idx_status`(`status`) USING BTREE, INDEX `idx_create_by`(`create_by`) USING BTREE, INDEX `idx_update_by`(`update_by`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点检规则管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for d_statistics_device_failure -- ---------------------------- DROP TABLE IF EXISTS `d_statistics_device_failure`; CREATE TABLE `d_statistics_device_failure` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `device_id` bigint(20) NOT NULL COMMENT '设备ID', `stat_cycle` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '统计周期（例如：2025-W42表示2025年第42周）', `failure_duration` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '故障时长（小时）', `good_duration` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '完好时长（小时）', `sick_duration` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '带病运行时长（小时）', `failure_rate` decimal(5, 4) NOT NULL DEFAULT 0.0000 COMMENT '故障率（故障时长/完好时长）', `sick_rate` decimal(5, 4) NOT NULL DEFAULT 0.0000 COMMENT '带病运行率（带病时长/完好时长）', `stat_start_time` datetime NOT NULL COMMENT '统计开始时间', `stat_end_time` datetime NOT 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 utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_device_id`(`device_id`) USING BTREE, INDEX `idx_stat_cycle`(`stat_cycle`) USING BTREE, INDEX `idx_create_time`(`create_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '设备故障率统计表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for d_statistics_inspection_missed -- ---------------------------- DROP TABLE IF EXISTS `d_statistics_inspection_missed`; CREATE TABLE `d_statistics_inspection_missed` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `rule_id` bigint(20) NOT NULL COMMENT '点检规则ID', `rule_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '点检规则名称', `inspector_id` bigint(20) NOT NULL COMMENT '点检人ID', `stat_cycle` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '统计周期（例如：2025-W42表示2025年第42周）', `missed_count` int(11) NOT NULL DEFAULT 0 COMMENT '漏检次数', `missed_duration` decimal(10, 2) NULL DEFAULT NULL COMMENT '漏检时长（小时）', `stat_start_time` datetime NOT NULL COMMENT '统计开始时间', `stat_end_time` datetime NOT 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 utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_rule_id`(`rule_id`) USING BTREE, INDEX `idx_inspector_id`(`inspector_id`) USING BTREE, INDEX `idx_stat_cycle`(`stat_cycle`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '点检漏检情况统计表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for d_statistics_mechanic_repair_details -- ---------------------------- DROP TABLE IF EXISTS `d_statistics_mechanic_repair_details`; CREATE TABLE `d_statistics_mechanic_repair_details` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `stat_cycle` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '统计周期（例如：2025-W42表示2025年第42周）', `mechanic_id` bigint(20) NOT NULL COMMENT '机修工ID', `devices` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '设备列表', `repair_count` int(11) NOT NULL DEFAULT 0 COMMENT '维修次数', `stat_start_time` datetime NOT NULL COMMENT '统计开始时间', `stat_end_time` datetime NOT 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 utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_mechanic_id`(`mechanic_id`) USING BTREE, INDEX `idx_stat_cycle`(`stat_cycle`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '机修工维修明细统计表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for e_experiment -- ---------------------------- DROP TABLE IF EXISTS `e_experiment`; CREATE TABLE `e_experiment` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '实验ID', `experiment_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '实验名称', `experiment_type` tinyint(4) NOT NULL COMMENT '实验类型（1：平板凝集-沙门氏菌 2：ELISA-白血病P27抗原 3：ELISA-抗体 4：荧光定量PCR 5：HI-抗体）', `experiment_manager` bigint(20) NULL DEFAULT NULL COMMENT '实验负责人', `review_manager` bigint(20) NULL DEFAULT NULL COMMENT '审核负责人', `raw_data_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '实验原始数据URL（文件格式）', `report_url` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '实验报告URL（文件格式）', `experiment_status` tinyint(4) NULL DEFAULT 1 COMMENT '实验状态（1：未开始 2：进行中 3：审核中 4：发回报告 5：已结束）', `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '实验状态（1：未开始 2：进行中 3：审核中 4：发回报告 5：已结束）', `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 '更新时间', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_experiment_manager`(`experiment_manager`) USING BTREE, INDEX `idx_review_manager`(`review_manager`) USING BTREE, INDEX `idx_experiment_status`(`experiment_status`) USING BTREE, INDEX `idx_experiment_create_by`(`create_by`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '实验管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for e_experiment_sample -- ---------------------------- DROP TABLE IF EXISTS `e_experiment_sample`; CREATE TABLE `e_experiment_sample` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '关联ID', `sample_id` bigint(20) NOT NULL COMMENT '样本ID', `experiment_id` bigint(20) NOT NULL COMMENT '实验ID', `create_by` bigint(20) NOT NULL COMMENT '创建人', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `uk_sample_experiment`(`sample_id`, `experiment_id`) USING BTREE, INDEX `idx_sample_experiment_sample`(`sample_id`) USING BTREE, INDEX `idx_sample_experiment_experiment`(`experiment_id`) USING BTREE, INDEX `idx_sample_experiment_create_by`(`create_by`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '样本-实验关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for e_sample -- ---------------------------- DROP TABLE IF EXISTS `e_sample`; CREATE TABLE `e_sample` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '样本ID', `sample_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '样本名称', `batch_num` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '取样的批次', `chicken_id` bigint(20) NULL DEFAULT NULL COMMENT '取样的个体id', `sample_time` datetime NULL DEFAULT NULL COMMENT '取样时间', `description` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '样本描述', `sample_type` tinyint(4) NULL DEFAULT NULL COMMENT '样品类型（1：血液 2：粪便）', `sample_status` tinyint(4) NULL DEFAULT 1 COMMENT '样品状态（1：已创建 2：已采样 3：实验中 4：已销毁）', `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 '更新时间', `del_flag` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sample_batch`(`batch_num`) USING BTREE, INDEX `idx_sample_chicken_id`(`chicken_id`) USING BTREE, INDEX `idx_sample_status`(`sample_status`) USING BTREE, INDEX `idx_sample_create_by`(`create_by`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '样本表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for e_sample_flow -- ---------------------------- DROP TABLE IF EXISTS `e_sample_flow`; CREATE TABLE `e_sample_flow` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '流转记录ID', `sample_id` bigint(20) NOT NULL COMMENT '样品ID', `handler` bigint(20) NOT NULL COMMENT '经手人', `handle_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '处理时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_sample_flow_sample`(`sample_id`) USING BTREE, INDEX `idx_sample_flow_handler`(`handler`) USING BTREE, INDEX `idx_sample_flow_time`(`handle_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '样本流转表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_bom -- ---------------------------- DROP TABLE IF EXISTS `erp_bom`; CREATE TABLE `erp_bom` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `bom_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'BOM父件编码', `item_id` bigint(20) NOT NULL COMMENT '物品信息', `version` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '版本号', `unit_id` bigint(20) NOT NULL COMMENT '计量单位(kg)', `min_quantity` float NOT NULL DEFAULT 0 COMMENT '单批次最少数量', `production_rate` float NOT NULL DEFAULT 0 COMMENT '成品率', `default_flag` tinyint(4) NOT NULL COMMENT '0:不是默认1：默认', `status` tinyint(4) NOT NULL COMMENT '0:可用 1：停用', `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 AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_bom_item -- ---------------------------- DROP TABLE IF EXISTS `erp_bom_item`; CREATE TABLE `erp_bom_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `bom_id` bigint(20) NOT NULL COMMENT '父bom_id', `bom_item_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子bom编码', `item_id` bigint(20) NOT NULL, `quantity` float NOT 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 AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_customer -- ---------------------------- DROP TABLE IF EXISTS `erp_customer`; CREATE TABLE `erp_customer` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `customer_num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户编码', `customer_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户名称', `customer_type` tinyint(4) NOT NULL COMMENT '客户类型', `level` tinyint(4) NOT NULL COMMENT '等级', `link_man` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '联系人', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '客户地址', `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'email', `link_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系号码', `status` tinyint(4) NOT 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 AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_customer_sales_person -- ---------------------------- DROP TABLE IF EXISTS `erp_customer_sales_person`; CREATE TABLE `erp_customer_sales_person` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `customer_id` bigint(20) NOT NULL, `user_id` bigint(20) NOT NULL, `status` tinyint(4) NULL DEFAULT NULL COMMENT '状态（1：绑定中 2：已解绑）', `un_bind_time` 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 AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_expected_production -- ---------------------------- DROP TABLE IF EXISTS `erp_expected_production`; CREATE TABLE `erp_expected_production` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `variety` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '品系', `plan_date` datetime NOT NULL COMMENT '计划日期', `production_quantity` float NOT NULL DEFAULT 0 COMMENT '预期产能', `occupied_quantity` float 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 AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_feedback -- ---------------------------- DROP TABLE IF EXISTS `erp_feedback`; CREATE TABLE `erp_feedback` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `order_id` bigint(20) NOT NULL, `feedback` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '回访内容', `record_date` datetime NOT 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 AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_initial_store -- ---------------------------- DROP TABLE IF EXISTS `erp_initial_store`; CREATE TABLE `erp_initial_store` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `item_id` bigint(20) NOT NULL, `store_house_id` bigint(20) NOT NULL, `quantity` float NOT NULL DEFAULT 0, `sta_cycle` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_initial_store_history -- ---------------------------- DROP TABLE IF EXISTS `erp_initial_store_history`; CREATE TABLE `erp_initial_store_history` ( `id` bigint(20) NOT NULL, `item_id` bigint(20) NOT NULL, `store_house_id` bigint(20) NOT NULL, `quantity` float NOT NULL DEFAULT 0, `sta_cycle` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 erp_item_info -- ---------------------------- DROP TABLE IF EXISTS `erp_item_info`; CREATE TABLE `erp_item_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '物品ID（主键）', `item_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '物品编码', `item_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称', `spec_model` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '规格型号', `unit_id` bigint(50) NOT NULL COMMENT '计量单位（全系统统一）', `easy_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '易记编码（自动生成）', `item_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '物品类型（1：实体，2：虚拟等，便于分类）', `pic` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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, UNIQUE INDEX `uk_easy_code`(`easy_code`) USING BTREE, UNIQUE INDEX `uk_name_spec_unit`(`item_name`, `spec_model`, `unit_id`) USING BTREE COMMENT '名称+规格+单位唯一', INDEX `idx_item_type`(`item_type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = 'ERP物品主数据表（管理各类物品基础信息）' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_order -- ---------------------------- DROP TABLE IF EXISTS `erp_order`; CREATE TABLE `erp_order` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `order_num` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单编号', `customer_id` bigint(20) NOT NULL COMMENT '客户', `delivery_date` datetime NOT NULL COMMENT '交付日期', `price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '价格', `status` tinyint(4) NOT NULL COMMENT '状态', `audit_date` datetime NULL DEFAULT NULL COMMENT '审核时间', `cancel_date` datetime NULL DEFAULT NULL COMMENT '退订时间', `cancel_audit_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 AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_order_item -- ---------------------------- DROP TABLE IF EXISTS `erp_order_item`; CREATE TABLE `erp_order_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `order_id` bigint(20) NOT NULL, `expected_production_id` bigint(20) NOT NULL COMMENT '预期产能', `variety` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '冗余字段', `quantity` float NOT NULL DEFAULT 0 COMMENT '订单数量', `send_date` datetime NULL DEFAULT NULL COMMENT '发货日期', `send_quantity` float NOT NULL DEFAULT 0 COMMENT '实际发货量', `delivery_date` datetime NULL DEFAULT NULL COMMENT '实际交付日期', `car_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车牌号', `signed_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '签收照片', `status` tinyint(4) NOT NULL DEFAULT 0, `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 AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_order_send -- ---------------------------- DROP TABLE IF EXISTS `erp_order_send`; CREATE TABLE `erp_order_send` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `order_item_id` bigint(20) NOT NULL COMMENT '订单明细', `send_quantity` float NOT NULL DEFAULT 0, `send_date` datetime NOT NULL, `car_num` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '车牌号', `delivery_date` datetime NULL DEFAULT NULL COMMENT '实际交付日期', `signed_photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci 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 AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_pay_record -- ---------------------------- DROP TABLE IF EXISTS `erp_pay_record`; CREATE TABLE `erp_pay_record` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `order_id` bigint(20) NOT NULL, `price` decimal(10, 2) NOT NULL DEFAULT 0.00, `pay_date` datetime NOT NULL, `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 AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_production -- ---------------------------- DROP TABLE IF EXISTS `erp_production`; CREATE TABLE `erp_production` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `receipt_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '单据编号', `receipt_date` datetime NOT NULL COMMENT '单据日期', `production_type` tinyint(4) NOT NULL COMMENT '加工类型（自制加工）', `out_store_house_id` bigint(20) NOT NULL COMMENT '原料仓库(取原料仓库)', `in_store_house_id` bigint(20) NOT NULL COMMENT '成品仓库', `bom_id` bigint(20) NOT NULL, `quantity` float NOT NULL DEFAULT 0 COMMENT '生产数量', `car` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生产车间', `dept` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门', `prepared_user` bigint(20) NULL DEFAULT NULL COMMENT '制单人', `audit_user` bigint(20) NULL DEFAULT NULL COMMENT '审核人', `audit_date` datetime NULL DEFAULT NULL COMMENT '审核日期', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1：待审核 2：通过 3：未通过', `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 AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_products -- ---------------------------- DROP TABLE IF EXISTS `erp_products`; CREATE TABLE `erp_products` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `product_num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编码', `product_name` varchar(55) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '产品名称', `status` tinyint(4) NOT 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 AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_project -- ---------------------------- DROP TABLE IF EXISTS `erp_project`; CREATE TABLE `erp_project` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键', `project_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '项目名称（如：XX型新品种研发）', `project_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '项目编码', `registration_date` date NOT NULL COMMENT '建档时间', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否停用（0：未停用，1：已停用）', `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, UNIQUE INDEX `uk_project_code`(`project_code`) USING BTREE COMMENT '项目编码唯一' ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '特殊统计项目表（如XX型新品种研发）' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_statement_bill -- ---------------------------- DROP TABLE IF EXISTS `erp_statement_bill`; CREATE TABLE `erp_statement_bill` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `order_id` bigint(20) NOT NULL, `price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '应收', `actual_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '实收', `bill_status` tinyint(4) NOT NULL COMMENT '是否开票', `bill_date` datetime NULL DEFAULT NULL COMMENT '开票日期', `bill_price` decimal(10, 2) NOT NULL DEFAULT 0.00 COMMENT '发票金额', `bill_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发票pdf文件', `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 AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_store_house -- ---------------------------- DROP TABLE IF EXISTS `erp_store_house`; CREATE TABLE `erp_store_house` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `store_house_num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '仓库编号', `store_house_type` tinyint(4) NOT NULL COMMENT '仓库类型', `store_house_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '仓库名称', `manger` bigint(255) NOT 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 AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_store_in -- ---------------------------- DROP TABLE IF EXISTS `erp_store_in`; CREATE TABLE `erp_store_in` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `receipt_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '单据编号', `receipt_date` datetime NOT NULL COMMENT '单据日期', `business_type` tinyint(4) NOT NULL COMMENT '业务类型:（直接领料，生产补料等，允许用户自定义字典）', `store_house_id` bigint(20) NOT NULL, `store_type` tinyint(4) NOT NULL COMMENT '采购等，允许用户自定义字典', `supplier_id` bigint(20) NULL DEFAULT NULL COMMENT '供应商', `dept` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门', `prepared_user` bigint(20) NULL DEFAULT NULL COMMENT '制单人', `audit_user` bigint(20) NULL DEFAULT NULL COMMENT '审核人', `audit_date` datetime NULL DEFAULT NULL COMMENT '审核日期', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0：待审核 1：通过 2：未通过', `production_id` bigint(20) NULL DEFAULT NULL COMMENT '生产ID（用于关联生产记录）', `settlement_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0:未结算 1：已结算', `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 AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_store_in_item -- ---------------------------- DROP TABLE IF EXISTS `erp_store_in_item`; CREATE TABLE `erp_store_in_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `in_id` bigint(20) NOT NULL COMMENT '入库头表ID', `item_id` bigint(20) NOT NULL COMMENT '物品ID', `store_house_id` bigint(20) NOT NULL COMMENT '仓库id', `quantity` float NOT NULL DEFAULT 0 COMMENT '数量', `tax_rate` float NULL DEFAULT 0 COMMENT '税率', `tax_inclusive_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '含税单价', `tax_inclusive_amount` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '含税金额', `status` tinyint(4) NOT NULL DEFAULT 0, `audit_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 AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_store_in_item_history -- ---------------------------- DROP TABLE IF EXISTS `erp_store_in_item_history`; CREATE TABLE `erp_store_in_item_history` ( `id` bigint(20) NOT NULL, `in_id` bigint(20) NOT NULL COMMENT '入库头表ID', `item_id` bigint(20) NOT NULL COMMENT '物品ID', `store_house_id` bigint(20) NOT NULL COMMENT '仓库id', `quantity` float NOT NULL DEFAULT 0 COMMENT '数量', `tax_rate` float NULL DEFAULT 0 COMMENT '税率', `tax_inclusive_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '含税单价', `tax_inclusive_amount` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '含税金额', `status` tinyint(4) NOT NULL DEFAULT 0, `audit_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 erp_store_out -- ---------------------------- DROP TABLE IF EXISTS `erp_store_out`; CREATE TABLE `erp_store_out` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `receipt_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '单据编号', `receipt_date` datetime NOT NULL COMMENT '单据日期', `business_type` tinyint(4) NOT NULL COMMENT '业务类型:（直接领料，生产补料等，允许用户自定义字典）', `store_house_id` bigint(20) NOT NULL, `store_type` tinyint(4) NOT NULL COMMENT '出库类别，采购等，允许用户自定义字典', `project_id` bigint(20) NULL DEFAULT NULL COMMENT '项目ID', `store_user_id` bigint(255) NULL DEFAULT NULL COMMENT '出库对象（外键到用户管理）', `dept` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门', `prepared_user` bigint(20) NULL DEFAULT NULL COMMENT '制单人', `audit_user` bigint(20) NULL DEFAULT NULL COMMENT '审核人', `audit_date` datetime NULL DEFAULT NULL COMMENT '审核日期', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0：待审核 1：通过 2：未通过', `production_id` bigint(20) NULL DEFAULT NULL COMMENT '生产ID（用于关联生产记录）', `settlement_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0:未结算 1：已结算', `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 AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_store_out_item -- ---------------------------- DROP TABLE IF EXISTS `erp_store_out_item`; CREATE TABLE `erp_store_out_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `out_id` bigint(20) NOT NULL COMMENT '出库头表ID', `item_id` bigint(20) NOT NULL COMMENT '物品ID', `store_house_id` bigint(20) NOT NULL COMMENT '仓库id', `quantity` float NOT NULL DEFAULT 0 COMMENT '出库数量', `tax_rate` float NULL DEFAULT 0 COMMENT '税率', `tax_inclusive_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '含税单价', `tax_inclusive_amount` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '含税金额', `status` tinyint(4) NOT NULL, `audit_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 AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_store_out_item_history -- ---------------------------- DROP TABLE IF EXISTS `erp_store_out_item_history`; CREATE TABLE `erp_store_out_item_history` ( `id` bigint(20) NOT NULL, `out_id` bigint(20) NOT NULL COMMENT '出库头表ID', `item_id` bigint(20) NOT NULL COMMENT '物品ID', `store_house_id` bigint(20) NOT NULL COMMENT '仓库id', `quantity` float NOT NULL DEFAULT 0 COMMENT '出库数量', `tax_rate` float NULL DEFAULT 0 COMMENT '税率', `tax_inclusive_price` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '含税单价', `tax_inclusive_amount` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '含税金额', `status` tinyint(4) NOT NULL, `audit_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 erp_store_user -- ---------------------------- DROP TABLE IF EXISTS `erp_store_user`; CREATE TABLE `erp_store_user` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `store_user_num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户编码', `store_user_name` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户名称', `registration_date` datetime NOT NULL COMMENT '建档时间', `status` tinyint(1) NOT NULL COMMENT '是否停用(0:未停用1：停用)', `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 AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_supplier -- ---------------------------- DROP TABLE IF EXISTS `erp_supplier`; CREATE TABLE `erp_supplier` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `supplier_num` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '供应商编码', `supplier_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '供应商名称', `settlement` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '结算客户', `level` tinyint(4) NOT NULL COMMENT '供应商等级', `deparment` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分管部门', `assigned_staff` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '分管人员', `registration_date` datetime NOT NULL COMMENT '建档日期', `status` tinyint(1) NULL DEFAULT NULL COMMENT '停用标志（0:未停用, 1:已停用）', `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 AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for erp_unit_info -- ---------------------------- DROP TABLE IF EXISTS `erp_unit_info`; CREATE TABLE `erp_unit_info` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '单位名称', `unit_symbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '符号', `golbal_flag` tinyint(4) NOT NULL COMMENT '是否国际标准（0：否 1：是）', `conversion_ratio` float(255, 2) NULL DEFAULT NULL COMMENT '与国际标准的转换率', `unit_type` tinyint(4) NOT 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 AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_batch -- ---------------------------- DROP TABLE IF EXISTS `f_batch`; CREATE TABLE `f_batch` ( `batch_num` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批次号（唯一标识）', `batch_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批次名称', `chicken_count` int(11) NOT NULL DEFAULT 0 COMMENT '鸡只数量', `hatch_date` date NOT NULL COMMENT '出生日期', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:新建, 1:育成中, 2:完成）', `batch_type` tinyint(1) NOT NULL COMMENT '批次类型（0:育种 1:祖代）', `variety_id` bigint(20) NOT NULL COMMENT '品系ID（复制字段，不随原表变动）', `variety_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '品种（复制字段，不随原表变动）', `lineage` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '系别（复制字段，不随原表变动）', `generation` 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 (`batch_num`) USING BTREE, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) USING BTREE, INDEX `batch_number`(`batch_num`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_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 AUTO_INCREMENT, `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 AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_batch_cull -- ---------------------------- DROP TABLE IF EXISTS `f_batch_cull`; CREATE TABLE `f_batch_cull` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `coop_id` bigint(20) NOT NULL, `batch_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `gender` tinyint(4) NOT NULL, `chicken_count` int(11) NOT NULL DEFAULT 0, `cull_time` datetime NOT NULL, `cull_reason` tinyint(4) NOT NULL, `disposal_method` tinyint(4) NOT NULL, `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 AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_breeding_egg_in -- ---------------------------- DROP TABLE IF EXISTS `f_breeding_egg_in`; CREATE TABLE `f_breeding_egg_in` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '种蛋入库ID', `coop_id` bigint(20) NOT NULL COMMENT '鸡舍ID（关联f_chicken_coop）', `batch_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '批次号', `family_num` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '家系配种ID（关联f_family）', `egg_count` int(11) NOT NULL DEFAULT 0 COMMENT '产蛋入库数', `egg_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '蛋分类（1:纯系种蛋,2:祖代厂代蛋3:父母代蛋 4:菜蛋, 5:畸形蛋, 6:破蛋）', `lay_date` date NOT NULL COMMENT '产蛋日期', `out_count` int(11) NOT NULL DEFAULT 0 COMMENT '已出库数量', `status` tinyint(4) NULL DEFAULT 0 COMMENT '状态', `audit_user_id` bigint(20) NULL DEFAULT NULL COMMENT '审核人', `factory` tinyint(4) NOT NULL COMMENT '育种场：0 /祖代厂：1', `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, INDEX `f_breeding_egg_in_ibfk_4`(`create_by`) USING BTREE, INDEX `f_breeding_egg_in_ibfk_5`(`update_by`) USING BTREE, CONSTRAINT `f_breeding_egg_in_ibfk_4` FOREIGN KEY (`create_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `f_breeding_egg_in_ibfk_5` FOREIGN KEY (`update_by`) REFERENCES `sys_user` (`user_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_breeding_egg_out -- ---------------------------- DROP TABLE IF EXISTS `f_breeding_egg_out`; CREATE TABLE `f_breeding_egg_out` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '出库id', `out_num` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '出库编号', `out_type` tinyint(4) NOT NULL COMMENT '外拉类型', `out_date` datetime NOT NULL COMMENT '外拉时间', `egg_count` int(11) NOT NULL DEFAULT 0 COMMENT '外拉蛋总数', `status` tinyint(4) NULL DEFAULT NULL COMMENT '状态', `audit_user_id` bigint(20) NULL DEFAULT NULL COMMENT '审核人', `factory` tinyint(4) NOT NULL COMMENT '育种场：0 /祖代厂：1', `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 AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_breeding_egg_out_item -- ---------------------------- DROP TABLE IF EXISTS `f_breeding_egg_out_item`; CREATE TABLE `f_breeding_egg_out_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `out_id` bigint(20) NOT NULL COMMENT 'out头表id', `in_id` bigint(20) NOT NULL COMMENT '入库记录ID', `coop_id` bigint(20) NOT NULL COMMENT '鸡舍ID（关联f_chicken_coop）', `batch_num` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '批次号', `family_num` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '入库家系号', `egg_type` tinyint(4) NOT NULL COMMENT '蛋类型', `out_count` int(11) NOT NULL DEFAULT 0 COMMENT '出库数量', `factory` tinyint(4) NOT NULL COMMENT '育种场：0 /祖代厂：1', `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 AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_cage_change -- ---------------------------- DROP TABLE IF EXISTS `f_cage_change`; CREATE TABLE `f_cage_change` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '换笼记录ID', `source_cage_id` bigint(20) NULL DEFAULT NULL COMMENT '源鸡笼ID（关联f_chicken_cage）', `target_cage_id` bigint(20) NOT NULL COMMENT '目标鸡笼ID（关联f_chicken_cage）', `chicken_id` bigint(20) NOT NULL COMMENT '鸡只ID（关联f_chicken）', `source_gender` tinyint(4) NULL DEFAULT NULL COMMENT '转出的性别', `target_gender` tinyint(4) NOT NULL COMMENT '转入的性别', `bind_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '换笼绑定时间', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:待处理, 1:已确认, 2:作废）', `cross_coop` tinyint(4) NOT NULL COMMENT '是否跨鸡舍（0:不跨鸡舍, 1:跨鸡舍）', `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, INDEX `source_cage_id`(`source_cage_id`) USING BTREE, INDEX `target_cage_id`(`target_cage_id`) USING BTREE, INDEX `chicken_id`(`chicken_id`) USING BTREE, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 64 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '换笼管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_chicken -- ---------------------------- DROP TABLE IF EXISTS `f_chicken`; CREATE TABLE `f_chicken` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '鸡只ID', `batch_num` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批次号（关联f_batch）', `gender` tinyint(4) NOT NULL DEFAULT 0 COMMENT '性别（0:公, 1:母）', `hatch_date` date NOT NULL COMMENT '出生日期', `wing_tag_num` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '翅号Num（关联f_wing_tag）', `electronic_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电子编号（RFID或唯一标识）', `leg_tag` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '脚号', `family_id` bigint(20) NULL DEFAULT NULL COMMENT '家系ID（可为空）', `cage_id` bigint(20) NULL DEFAULT NULL COMMENT '笼ID（关联f_chicken_cage）', `cull_time` datetime NULL DEFAULT NULL COMMENT '淘汰时间', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:在养, 1:已淘汰, 2:死亡）', `cull_reason` tinyint(4) NULL DEFAULT NULL COMMENT '淘汰原因（“病鸡”、“弱鸡”、“实验”、“老化\r\n（性能下降）”）', `disposal_method` tinyint(255) 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, INDEX `wing_tag_num`(`wing_tag_num`) USING BTREE, INDEX `cage_id`(`cage_id`) USING BTREE, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) USING BTREE, INDEX `f_chicken_ibfk_1`(`batch_num`) 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 = 55 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鸡只个体信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_chicken_cage -- ---------------------------- DROP TABLE IF EXISTS `f_chicken_cage`; CREATE TABLE `f_chicken_cage` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '鸡笼ID', `cage_num` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鸡笼编号', `chicken_coop_id` int(11) NOT NULL COMMENT '鸡舍ID（关联鸡舍表）', `manager` bigint(20) NULL DEFAULT NULL COMMENT '管理员（关联用户ID）', `status` tinyint(1) NOT NULL DEFAULT 0 COMMENT '状态（0:正常 1:异常）', `max_capacity` int(11) NOT NULL DEFAULT 0 COMMENT '最大容量', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 1代表删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `manager`(`manager`) USING BTREE, INDEX `f_chicken_cage_ibfk_1`(`chicken_coop_id`) 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 = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鸡笼信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_chicken_coop -- ---------------------------- DROP TABLE IF EXISTS `f_chicken_coop`; CREATE TABLE `f_chicken_coop` ( `id` int(11) NOT NULL AUTO_INCREMENT, `coop_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鸡舍编号', `coop_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鸡舍名称', `standard_cage_num` int(11) NULL DEFAULT 0 COMMENT '标准笼子数量', `status` tinyint(1) NOT NULL COMMENT '状态(0:正常 1:异常)', `coop_type` tinyint(4) NOT NULL COMMENT '鸡舍类型（1：育成舍 2： 产蛋舍）', `factory` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '厂区', `manager` bigint(20) NULL DEFAULT NULL COMMENT '管理员', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_chicken_metatarsal -- ---------------------------- DROP TABLE IF EXISTS `f_chicken_metatarsal`; CREATE TABLE `f_chicken_metatarsal` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `chicken_id` bigint(20) NOT NULL, `record_date` datetime NOT NULL, `metatarsal_length` double NOT NULL COMMENT '跖骨长(mm)', `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 AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_chicken_tibia -- ---------------------------- DROP TABLE IF EXISTS `f_chicken_tibia`; CREATE TABLE `f_chicken_tibia` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `chicken_id` bigint(20) NOT NULL, `record_date` datetime NOT NULL, `tibia_length` double NOT NULL, `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 AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_chicken_weight -- ---------------------------- DROP TABLE IF EXISTS `f_chicken_weight`; CREATE TABLE `f_chicken_weight` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `chicken_id` bigint(20) 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(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, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '鸡体重信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NOT NULL, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `report_cycle` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '统计周期 （年：Y 月：M 日：D 季：Q 周：W）', `coop_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'coop|egg (统计育成舍或产蛋舍)', `year` int(4) NOT NULL COMMENT '年', `month` tinyint(4) NULL DEFAULT NULL COMMENT '月', `day` tinyint(4) NULL DEFAULT NULL COMMENT '日', `week` tinyint(4) NULL DEFAULT NULL COMMENT '周', `quarter` tinyint(4) NULL DEFAULT NULL COMMENT '季度', `last_save0` int(11) NOT NULL DEFAULT 0 COMMENT '上日存栏-公', `last_save1` int(11) NOT NULL DEFAULT 0 COMMENT '上日存栏-母', `save0` int(11) NOT NULL DEFAULT 0 COMMENT '本日存栏-公', `save1` int(11) NOT NULL DEFAULT 0 COMMENT '本日存栏-母', `cull0` int(11) NOT NULL DEFAULT 0 COMMENT '本日淘汰数量-公', `cull1` int(11) NOT NULL DEFAULT 0 COMMENT '本日淘汰数量-母', `in0` int(11) NULL DEFAULT 0 COMMENT '本日转入-公', `in1` int(11) NULL DEFAULT 0 COMMENT '本日转入-母', `out0` int(11) NULL DEFAULT 0 COMMENT '本日转出-公', `out1` int(11) NULL DEFAULT 0 COMMENT '本日转出-母', `qualified_egg` int(11) NULL DEFAULT 0 COMMENT '日合格蛋数量', `deformed_egg` int(11) NULL DEFAULT 0 COMMENT '日畸形蛋数量', `break_egg` int(11) NULL DEFAULT 0 COMMENT '日坏蛋数', `egg_production_rate` float NULL DEFAULT NULL COMMENT '日产蛋率', `egg_pass_rate` float NULL DEFAULT NULL COMMENT '种蛋合格率', `chicken0` int(11) NOT NULL DEFAULT 0 COMMENT '公鸡数', `chicken1` int(11) NOT NULL COMMENT '母鸡数', `life_rate` float NULL DEFAULT NULL COMMENT '存活率', `cull_rate` float 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 = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- 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(20) NOT NULL AUTO_INCREMENT, `report_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '报表头id', `coop_id` bigint(20) NOT NULL COMMENT '鸡舍ID', `batch_num` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批次号', `last_save0` int(11) NOT NULL DEFAULT 0 COMMENT '上日存栏-公', `last_save1` int(11) NOT NULL DEFAULT 0 COMMENT '上日存栏-母', `save0` int(11) NOT NULL DEFAULT 0 COMMENT '本日存栏-公', `save1` int(11) NOT NULL DEFAULT 0 COMMENT '本日存栏-母', `cull0` int(11) NOT NULL DEFAULT 0 COMMENT '本日淘汰数量-公', `cull1` int(11) NOT NULL DEFAULT 0 COMMENT '本日淘汰数量-母', `in0` int(11) NULL DEFAULT 0 COMMENT '本日转入-公', `in1` int(11) NULL DEFAULT 0 COMMENT '本日转入-母', `out0` int(11) NULL DEFAULT 0 COMMENT '本日转出-公', `out1` int(11) NULL DEFAULT 0 COMMENT '本日转出-母', `qualified_egg` int(11) NULL DEFAULT 0 COMMENT '日合格蛋数量', `deformed_egg` int(11) NULL DEFAULT 0 COMMENT '日畸形蛋数量', `break_egg` int(11) NULL DEFAULT 0 COMMENT '日坏蛋数', `egg_production_rate` float NULL DEFAULT NULL COMMENT '日产蛋率', `egg_pass_rate` float NULL DEFAULT NULL COMMENT '日产蛋合格率', `chicken0` int(11) NOT NULL DEFAULT 0 COMMENT '公鸡数', `chicken1` int(11) 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 utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '统计周期 （年：Y 月：M 日：D 季：Q 周：W）', `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 AUTO_INCREMENT = 347 CHARACTER SET = utf8 COLLATE = utf8_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 AUTO_INCREMENT, `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, `source_gender` tinyint(4) NULL DEFAULT NULL, `target_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 AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_drug -- ---------------------------- DROP TABLE IF EXISTS `f_drug`; CREATE TABLE `f_drug` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '药品ID', `drug_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '药品名称', `factory` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '生产厂家', `production_date` date NULL DEFAULT NULL COMMENT '生产日期', `expiration_date` date NULL DEFAULT NULL COMMENT '有效期', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:可用, 1:缺货, 2:过期）', `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci 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 '更新时间', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '药品信息表' 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 AUTO_INCREMENT, `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 AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_drug_sop -- ---------------------------- DROP TABLE IF EXISTS `f_drug_sop`; CREATE TABLE `f_drug_sop` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '药品SOPID', `sop_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'SOP名称', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:启用, 1:禁用, 2:维护中）', `gender` tinyint(4) NOT NULL 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, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '药品SOP主表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_drug_sop_detail -- ---------------------------- DROP TABLE IF EXISTS `f_drug_sop_detail`; CREATE TABLE `f_drug_sop_detail` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '详情ID', `drug_sop_id` bigint(20) NOT NULL COMMENT '药品SOPID（关联f_drug_sop）', `drug_id` bigint(20) NOT NULL COMMENT '药品ID（关联f_drug）', `start_age` int(11) NOT NULL COMMENT '开始日龄', `end_age` int(11) NOT NULL COMMENT '结束日龄', `dosage` double NOT NULL DEFAULT 0 COMMENT '剂量（单位:g/ml）', `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, INDEX `drug_sop_id`(`drug_sop_id`) USING BTREE, INDEX `drug_id`(`drug_id`) USING BTREE, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '药品SOP详情表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_family -- ---------------------------- DROP TABLE IF EXISTS `f_family`; CREATE TABLE `f_family` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '配种记录ID', `family_num` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '家系号', `male_chicken_id` bigint(20) NOT NULL COMMENT '公鸡ID（关联f_chicken）', `male_batch_num` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '公鸡批次号', `female_chicken_id` bigint(20) NOT NULL COMMENT '母鸡ID（关联f_chicken）', `female_batch_num` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '母鸡批次号', `breed_date` date NOT NULL COMMENT '配种日期', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:正常, 1:异常）', `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, INDEX `male_chicken_id`(`male_chicken_id`) USING BTREE, INDEX `female_chicken_id`(`female_chicken_id`) USING BTREE, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '家系配种管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_feed -- ---------------------------- DROP TABLE IF EXISTS `f_feed`; CREATE TABLE `f_feed` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '饲料ID', `feed_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '饲料名称', `composition_ratio` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '饲料成分及含量（配比）', `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, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '饲料信息表' 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 AUTO_INCREMENT, `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 AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_feed_sop -- ---------------------------- DROP TABLE IF EXISTS `f_feed_sop`; CREATE TABLE `f_feed_sop` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '饲养指标ID', `sop_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'SOP名称', `gender` tinyint(4) NOT NULL DEFAULT 0 COMMENT '性别（0:公, 1:母）', `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, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '饲养指标主表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_feed_sop_detail -- ---------------------------- DROP TABLE IF EXISTS `f_feed_sop_detail`; CREATE TABLE `f_feed_sop_detail` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '详情ID', `feed_sop_id` bigint(20) NOT NULL COMMENT '饲养指标ID（关联f_breed_sop）', `start_age` int(11) NOT NULL COMMENT '起始日龄', `end_age` int(11) NOT NULL COMMENT '停止日龄', `feed_id` bigint(20) 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(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, INDEX `breed_sop_id`(`feed_sop_id`) USING BTREE, INDEX `feed_id`(`feed_id`) USING BTREE, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '饲养指标详情表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_incubation -- ---------------------------- DROP TABLE IF EXISTS `f_incubation`; CREATE TABLE `f_incubation` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '入孵记录ID', `incubation_batch_num` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '孵化批次号（唯一标识）', `batch_num` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批次号', `family_num` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '家系配种ID（关联f_family）', `female_chicken_id` bigint(20) NULL DEFAULT NULL COMMENT '母系ID', `batch_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '批次名称', `variety_id` bigint(20) NULL DEFAULT NULL COMMENT '品系ID（关联f_variety）', `variety_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '品种（复制字段，不随原表变动）', `lineage` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '系别（复制字段，不随原表变动）', `generation` int(11) NOT NULL DEFAULT 0 COMMENT '代数（复制字段，不随原表变动）', `incubation_count` int(11) NOT NULL DEFAULT 0 COMMENT '入孵数量', `light_egg_count` int(11) NOT NULL DEFAULT 0 COMMENT '光蛋数量', `dead_sperm_egg_count` int(11) NOT NULL DEFAULT 0 COMMENT '死精蛋数量', `dead_embryo_egg_count` int(11) NOT NULL DEFAULT 0 COMMENT '死坯胎数量', `weak_chick_count` int(11) NOT NULL DEFAULT 0 COMMENT '弱雏数量', `other_discard_count` int(11) NOT NULL DEFAULT 0 COMMENT '其它淘汰数量', `upload_date` date NOT NULL COMMENT '入孵日期', `out_item_id` bigint(20) NULL DEFAULT NULL COMMENT '出库明细id(可为空)', `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, INDEX `breed_pair_id`(`family_num`) USING BTREE, INDEX `breed_id`(`variety_id`) USING BTREE, INDEX `female_id`(`female_chicken_id`) USING BTREE, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '入孵管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_measure -- ---------------------------- DROP TABLE IF EXISTS `f_measure`; CREATE TABLE `f_measure` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `measure_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '测定批次名称', `batch_num` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批次号', `status` tinyint(4) NOT NULL, `start_time` datetime NOT NULL COMMENT '起始日期', `end_time` datetime NULL DEFAULT NULL COMMENT '结束日期', `start_age` int(11) NOT NULL COMMENT '起始日龄', `end_age` int(11) NULL DEFAULT NULL COMMENT '结束日龄', `feed_id` bigint(20) NOT NULL COMMENT '饲料id', `feed_sop_id` bigint(20) NOT NULL COMMENT '饲喂SOP', `leg_disease_count` int(11) NOT NULL DEFAULT 0 COMMENT '腿病淘汰数', `ascites_count` int(11) NOT NULL DEFAULT 0 COMMENT '腹水淘汰数', `bacterial_count` int(11) NOT NULL DEFAULT 0 COMMENT '细菌感染淘汰数', `trauma_count` int(11) NOT NULL DEFAULT 0 COMMENT '外伤淘汰数', `other_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 AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_measure_detail -- ---------------------------- DROP TABLE IF EXISTS `f_measure_detail`; CREATE TABLE `f_measure_detail` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `measure_id` bigint(20) NOT NULL COMMENT '测定id', `chicken_id` bigint(20) NOT NULL COMMENT '个体id', `status` tinyint(4) 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(11) NOT NULL COMMENT '起始体重日龄', `end_weight` double NULL DEFAULT NULL COMMENT '结束体重', `end_weight_time` datetime NULL DEFAULT NULL COMMENT '结束体重日期', `end_weight_age` int(11) NULL DEFAULT NULL COMMENT '结束体重日期', `middle_weight_info` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '中途体重信息', `cage_num` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT 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 AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_pull_out -- ---------------------------- DROP TABLE IF EXISTS `f_pull_out`; CREATE TABLE `f_pull_out` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `coop_id` bigint(20) NOT NULL COMMENT '鸡舍ID', `pull_out_type` tinyint(4) NOT NULL COMMENT '外拉类型（0：祖代厂 1:食堂 2:实验室 3:菜蛋销售）', `pull_out_date` datetime NOT NULL COMMENT '外拉时间', `egg_count` int(11) NOT NULL COMMENT '数量', `egg_type` tinyint(4) NOT NULL COMMENT '蛋的类型（0:好种蛋, 1:好菜蛋, 2:畸形蛋, 3:破蛋）', `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 AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_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_sop_bind -- ---------------------------- DROP TABLE IF EXISTS `f_sop_bind`; CREATE TABLE `f_sop_bind` ( `id` bigint(11) NOT NULL AUTO_INCREMENT, `batch_num` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '批次号（唯一标识）', `chicken_id` bigint(20) NULL DEFAULT NULL COMMENT '个体ID', `sop_id` bigint(20) NOT NULL COMMENT 'SOPID（关联f_sop）', `sop_type` tinyint(4) NOT NULL COMMENT '1:饲喂2：药物3：疫苗', `status` tinyint(1) NOT NULL COMMENT '绑定状态（0:已绑定, 1:已解绑）', `gender` 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 AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_vaccine -- ---------------------------- DROP TABLE IF EXISTS `f_vaccine`; CREATE TABLE `f_vaccine` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '疫苗ID', `vaccine_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '疫苗名称', `vaccine_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '疫苗种类（0:灭活疫苗, 1:活疫苗, 2:重组蛋白疫苗）', `manufacturer` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '生产厂家', `production_date` date NULL DEFAULT NULL COMMENT '生产日期', `expiration_date` date NULL DEFAULT NULL COMMENT '有效期', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:可用, 1:缺货, 2:过期）', `remark` text CHARACTER SET utf8 COLLATE utf8_general_ci 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 '更新时间', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' COMMENT '删除标志（0:未删除, 1:已删除）', PRIMARY KEY (`id`) USING BTREE, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '疫苗信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_vaccine_drug_conflict -- ---------------------------- DROP TABLE IF EXISTS `f_vaccine_drug_conflict`; CREATE TABLE `f_vaccine_drug_conflict` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '冲突记录ID', `vaccine_id` bigint(20) NOT NULL COMMENT '疫苗ID（关联f_vaccine）', `drug_id` bigint(20) NOT NULL COMMENT '药品ID（关联f_drug）', `conflict_duration` int(11) NOT NULL DEFAULT 0, `start_age` int(11) NOT NULL DEFAULT 0 COMMENT '冲突开始日龄', `end_age` 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, INDEX `vaccine_id`(`vaccine_id`) USING BTREE, INDEX `drug_id`(`drug_id`) USING BTREE, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '疫苗与药品冲突记录表' 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 AUTO_INCREMENT, `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 AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_vaccine_sop -- ---------------------------- DROP TABLE IF EXISTS `f_vaccine_sop`; CREATE TABLE `f_vaccine_sop` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '免疫SOPID', `sop_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '免疫计划名称', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:启用, 1:禁用, 2:维护中）', `gender` tinyint(4) NULL DEFAULT NULL 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, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '免疫SOP主表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_vaccine_sop_detail -- ---------------------------- DROP TABLE IF EXISTS `f_vaccine_sop_detail`; CREATE TABLE `f_vaccine_sop_detail` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '详情ID', `vaccine_sop_id` bigint(20) NOT NULL COMMENT '免疫SOPID（关联f_vaccine_sop）', `start_age` int(11) NOT NULL COMMENT '开始日龄', `end_age` int(11) NOT NULL COMMENT '结束日龄', `vaccine_id` bigint(20) NOT NULL COMMENT '疫苗id', `dosage` double NOT NULL DEFAULT 0 COMMENT '剂量（单位:g/ml）', `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, INDEX `immune_sop_id`(`vaccine_sop_id`) USING BTREE, INDEX `vaccine_id`(`vaccine_id`) USING BTREE, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '免疫SOP详情表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for f_variety -- ---------------------------- DROP TABLE IF EXISTS `f_variety`; CREATE TABLE `f_variety` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '品系ID', `variety_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '品种名', `lineage` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '系别', `generation` int(11) NOT NULL DEFAULT 0 COMMENT '世代（数字）', `purpose` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用途系别 用户单选“父系”或者“母系”', `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, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) 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 = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '品系信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- 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 utf8 COLLATE utf8_general_ci NOT NULL COMMENT '鸡翅号（唯一标识）', `chicken_id` bigint(20) NULL DEFAULT NULL COMMENT '鸡只ID（关联f_chicken）', `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0:闲置, 1:正常）', `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 (`wing_tag_num`) USING BTREE, INDEX `create_by`(`create_by`) USING BTREE, INDEX `update_by`(`update_by`) USING BTREE, INDEX `chicken_id`(`chicken_id`) USING BTREE, INDEX `status`(`status`) 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 = utf8 COLLATE = utf8_general_ci COMMENT = '翅号管理表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for gen_table -- ---------------------------- DROP TABLE IF EXISTS `gen_table`; CREATE TABLE `gen_table` ( `table_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号', `data_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '数据源名称', `table_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '表名称', `table_comment` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '表描述', `sub_table_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联子表的表名', `sub_table_fk_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '子表关联的外键名', `class_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '实体类名称', `tpl_category` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作）', `package_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成包路径', `module_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成模块名', `business_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成业务名', `function_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成功能名', `function_author` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成功能作者', `gen_type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）', `gen_path` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '/' COMMENT '生成路径（不填默认项目路径）', `options` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '其它生成选项', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`table_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1075 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代码生成业务表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for gen_table_column -- ---------------------------- DROP TABLE IF EXISTS `gen_table_column`; CREATE TABLE `gen_table_column` ( `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号', `table_id` bigint(20) NULL DEFAULT NULL COMMENT '归属表编号', `column_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列名称', `column_comment` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列描述', `column_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列类型', `java_type` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JAVA类型', `java_field` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JAVA字段名', `is_pk` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否主键（1是）', `is_increment` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否自增（1是）', `is_required` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否必填（1是）', `is_insert` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否为插入字段（1是）', `is_edit` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否编辑字段（1是）', `is_list` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否列表字段（1是）', `is_query` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否查询字段（1是）', `is_sort` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否排序字段（1是）', `query_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）', `html_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）', `dict_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典类型', `sort` int(11) NULL DEFAULT NULL COMMENT '排序', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`column_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2088 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_client -- ---------------------------- DROP TABLE IF EXISTS `sys_client`; CREATE TABLE `sys_client` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `client_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端id', `client_key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端key', `client_secret` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户端秘钥', `grant_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权类型', `device_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '设备类型', `active_timeout` int(11) NULL DEFAULT 1800 COMMENT 'token活跃超时时间', `timeout` int(11) NULL DEFAULT 604800 COMMENT 'token固定超时', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统授权表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_config -- ---------------------------- DROP TABLE IF EXISTS `sys_config`; CREATE TABLE `sys_config` ( `config_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '参数主键', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `config_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '参数名称', `config_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '参数键名', `config_value` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '参数键值', `config_type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '系统内置（Y是 N否）', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`config_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '参数配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_dict_data -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_data`; CREATE TABLE `sys_dict_data` ( `dict_code` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典编码', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `dict_sort` int(4) NULL DEFAULT 0 COMMENT '字典排序', `dict_label` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典标签', `dict_value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典键值', `dict_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典类型', `css_class` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '样式属性（其他样式扩展）', `list_class` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表格回显样式', `is_default` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '是否默认（Y是 N否）', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`dict_code`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1077 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典数据表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_dict_type -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_type`; CREATE TABLE `sys_dict_type` ( `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `dict_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典名称', `dict_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '字典类型', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`dict_id`) USING BTREE, UNIQUE INDEX `tenant_id`(`tenant_id`, `dict_type`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1020 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_login_log -- ---------------------------- DROP TABLE IF EXISTS `sys_login_log`; CREATE TABLE `sys_login_log` ( `info_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '访问ID', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户账号', `client_key` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '客户端', `device_type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '设备类型', `ipaddr` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '登录IP地址', `login_location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '登录地点', `browser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '浏览器类型', `os` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '操作系统', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '登录状态（0成功 1失败）', `msg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '提示消息', `login_time` datetime NULL DEFAULT NULL COMMENT '访问时间', PRIMARY KEY (`info_id`) USING BTREE, INDEX `idx_sys_loginLog_s`(`status`) USING BTREE, INDEX `idx_sys_loginLog_lt`(`login_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1358 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统访问记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID', `menu_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称', `parent_id` bigint(20) NULL DEFAULT 0 COMMENT '父菜单ID', `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序', `path` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '路由地址', `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组件路径', `query_param` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由参数', `is_frame` int(1) NULL DEFAULT 1 COMMENT '是否为外链（0是 1否）', `is_cache` int(1) NULL DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）', `menu_type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）', `visible` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '显示状态（0显示 1隐藏）', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0正常 1停用）', `perms` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识', `icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '#' COMMENT '菜单图标', `btn_class` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮样式', `btn_script` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮脚本', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`menu_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2702 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_menu_copy1 -- ---------------------------- DROP TABLE IF EXISTS `sys_menu_copy1`; CREATE TABLE `sys_menu_copy1` ( `menu_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜单ID', `menu_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '菜单名称', `parent_id` bigint(20) NULL DEFAULT 0 COMMENT '父菜单ID', `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序', `path` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '路由地址', `component` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组件路径', `query_param` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '路由参数', `is_frame` int(1) NULL DEFAULT 1 COMMENT '是否为外链（0是 1否）', `is_cache` int(1) NULL DEFAULT 0 COMMENT '是否缓存（0缓存 1不缓存）', `menu_type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '菜单类型（M目录 C菜单 F按钮）', `visible` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '显示状态（0显示 1隐藏）', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '菜单状态（0正常 1停用）', `perms` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限标识', `icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '#' COMMENT '菜单图标', `btn_class` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮样式', `btn_script` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮脚本', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`menu_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10184 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单权限表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_notice -- ---------------------------- DROP TABLE IF EXISTS `sys_notice`; CREATE TABLE `sys_notice` ( `notice_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '公告ID', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `notice_title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '公告标题', `notice_type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '公告类型（1通知 2公告）', `notice_content` longblob NULL COMMENT '公告内容', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '公告状态（0正常 1关闭）', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`notice_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '通知公告表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_notice_status -- ---------------------------- DROP TABLE IF EXISTS `sys_notice_status`; CREATE TABLE `sys_notice_status` ( `user_id` bigint(20) NOT NULL COMMENT '用户ID', `message_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消息ID', `message_type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '消息类型', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '阅读状态（0未读 1已读）', PRIMARY KEY (`user_id`, `message_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '消息阅读表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_oper_log -- ---------------------------- DROP TABLE IF EXISTS `sys_oper_log`; CREATE TABLE `sys_oper_log` ( `oper_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '日志主键', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '模块标题', `business_type` int(2) NULL DEFAULT 0 COMMENT '业务类型（0其它 1新增 2修改 3删除）', `method` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '方法名称', `request_method` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '请求方式', `operator_type` int(1) NULL DEFAULT 0 COMMENT '操作类别（0其它 1后台用户 2手机端用户）', `oper_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '操作人员', `org_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '组织机构名称', `oper_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '请求URL', `oper_ip` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '主机地址', `oper_location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '操作地点', `oper_param` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '请求参数', `json_result` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '返回参数', `status` int(1) NULL DEFAULT 0 COMMENT '操作状态（0正常 1异常）', `error_msg` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '错误消息', `oper_time` datetime NULL DEFAULT NULL COMMENT '操作时间', `cost_time` bigint(20) NULL DEFAULT 0 COMMENT '消耗时间', PRIMARY KEY (`oper_id`) USING BTREE, INDEX `idx_sys_oper_log_bt`(`business_type`) USING BTREE, INDEX `idx_sys_oper_log_s`(`status`) USING BTREE, INDEX `idx_sys_oper_log_ot`(`oper_time`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2326 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志记录' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_org -- ---------------------------- DROP TABLE IF EXISTS `sys_org`; CREATE TABLE `sys_org` ( `org_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '组织机构id', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `parent_id` bigint(20) NULL DEFAULT 0 COMMENT '父组织机构id', `ancestors` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '祖级列表', `org_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '组织机构名称', `org_category` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '组织机构类别编码', `order_num` int(4) NULL DEFAULT 0 COMMENT '显示顺序', `leader` bigint(20) NULL DEFAULT NULL COMMENT '负责人', `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话', `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '组织机构状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`org_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1002 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '组织机构表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_oss -- ---------------------------- DROP TABLE IF EXISTS `sys_oss`; CREATE TABLE `sys_oss` ( `oss_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '对象存储主键', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件名', `original_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '原名', `file_suffix` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '文件后缀名', `url` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'URL地址', `ext1` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '扩展字段', `object_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件标识', `service` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'minio' COMMENT '服务商', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '上传人', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新人', PRIMARY KEY (`oss_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'OSS对象存储表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_oss_config -- ---------------------------- DROP TABLE IF EXISTS `sys_oss_config`; CREATE TABLE `sys_oss_config` ( `oss_config_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `config_key` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '配置key', `access_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT 'accessKey', `secret_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '秘钥', `bucket_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '桶名称', `prefix` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '前缀', `endpoint` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '访问站点', `domain` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '自定义域名', `is_https` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'N' COMMENT '是否https（Y=是,N=否）', `region` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '域', `access_policy` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '桶权限类型(0=private 1=public 2=custom)', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1' COMMENT '是否默认（0=是,1=否）', `ext1` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '扩展字段', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`oss_config_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '对象存储配置表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_post -- ---------------------------- DROP TABLE IF EXISTS `sys_post`; CREATE TABLE `sys_post` ( `post_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '岗位ID', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `org_id` bigint(20) NOT NULL COMMENT '组织机构id', `post_code` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '岗位编码', `post_category` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '岗位类别编码', `post_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '岗位名称', `post_sort` int(4) NOT NULL COMMENT '显示顺序', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '状态（0正常 1停用）', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`post_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '岗位信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_role -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `role_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `role_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色名称', `role_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色权限字符串', `role_sort` int(4) NOT NULL COMMENT '显示顺序', `data_scope` char(1) CHARACTER SET utf8 COLLATE utf8_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 utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`role_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1003 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_role_menu -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `role_id` bigint(20) NOT NULL COMMENT '角色ID', `menu_id` bigint(20) NOT NULL COMMENT '菜单ID', PRIMARY KEY (`role_id`, `menu_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色和菜单关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_role_org -- ---------------------------- DROP TABLE IF EXISTS `sys_role_org`; CREATE TABLE `sys_role_org` ( `role_id` bigint(20) NOT NULL COMMENT '角色ID', `org_id` bigint(20) NOT NULL COMMENT '组织机构ID', PRIMARY KEY (`role_id`, `org_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色和组织机构关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_social -- ---------------------------- DROP TABLE IF EXISTS `sys_social`; CREATE TABLE `sys_social` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `user_id` bigint(20) NOT NULL COMMENT '用户ID', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户id', `auth_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '平台+平台唯一id', `source` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户来源', `open_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '平台编号唯一id', `user_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录账号', `nick_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户昵称', `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户邮箱', `avatar` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '头像地址', `access_token` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户的授权令牌', `expire_in` int(11) NULL DEFAULT NULL COMMENT '用户的授权令牌的有效期，部分平台可能没有', `refresh_token` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '刷新令牌，部分平台可能没有', `access_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '平台的授权信息，部分平台可能没有', `union_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户的 unionid', `scope` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授予的权限，部分平台可能没有', `token_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '个别平台的授权信息，部分平台可能没有', `id_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'id token，部分平台可能没有', `mac_algorithm` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小米平台用户的附带属性，部分平台可能没有', `mac_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小米平台用户的附带属性，部分平台可能没有', `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户的授权code，部分平台可能没有', `oauth_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Twitter平台用户的附带属性，部分平台可能没有', `oauth_token_secret` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'Twitter平台用户的附带属性，部分平台可能没有', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '社会化关系表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_tenant -- ---------------------------- DROP TABLE IF EXISTS `sys_tenant`; CREATE TABLE `sys_tenant` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '租户编号', `contact_user_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人', `contact_phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话', `company_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业名称', `license_number` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '统一社会信用代码', `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址', `intro` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '企业简介', `domain` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '域名', `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `package_id` bigint(20) NULL DEFAULT NULL COMMENT '租户套餐编号', `expire_time` datetime NULL DEFAULT NULL COMMENT '过期时间', `account_count` int(11) NULL DEFAULT -1 COMMENT '用户数量（-1不限制）', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '租户状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '租户表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_tenant_package -- ---------------------------- DROP TABLE IF EXISTS `sys_tenant_package`; CREATE TABLE `sys_tenant_package` ( `package_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '租户套餐id', `package_name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '套餐名称', `menu_ids` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联菜单id', `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `menu_check_strictly` tinyint(1) NULL DEFAULT 1 COMMENT '菜单树选择项是否关联显示', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`package_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '租户套餐表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `user_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户ID', `tenant_id` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '000000' COMMENT '租户编号', `org_id` bigint(20) NULL DEFAULT NULL COMMENT '组织机构ID', `user_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账号', `nick_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户昵称', `user_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'sys_user' COMMENT '用户类型（sys_user系统用户）', `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '用户邮箱', `phonenumber` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '手机号码', `sex` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '用户性别（0男 1女 2未知）', `avatar` bigint(20) NULL DEFAULT NULL COMMENT '头像地址', `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '密码', `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '个人照片', `birth` date NULL DEFAULT NULL COMMENT '出生日期', `id_code` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号', `hire_date` date NULL DEFAULT NULL COMMENT '入职日期', `status` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '帐号状态（0正常 1停用）', `del_flag` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '删除标志（0代表存在 2代表删除）', `login_ip` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '最后登录IP', `login_date` datetime NULL DEFAULT NULL COMMENT '最后登录时间', `create_org` bigint(20) NULL DEFAULT NULL COMMENT '创建组织机构', `create_by` bigint(20) NULL DEFAULT NULL COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` bigint(20) NULL DEFAULT NULL COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_user_post -- ---------------------------- DROP TABLE IF EXISTS `sys_user_post`; CREATE TABLE `sys_user_post` ( `user_id` bigint(20) NOT NULL COMMENT '用户ID', `post_id` bigint(20) NOT NULL COMMENT '岗位ID', PRIMARY KEY (`user_id`, `post_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户与岗位关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for sys_user_role -- ---------------------------- DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `user_id` bigint(20) NOT NULL COMMENT '用户ID', `role_id` bigint(20) NOT NULL COMMENT '角色ID', PRIMARY KEY (`user_id`, `role_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户和角色关联表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxl_job_group -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_group`; CREATE TABLE `xxl_job_group` ( `id` int(11) 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(4) 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; -- ---------------------------- -- Table structure for xxl_job_info -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_info`; CREATE TABLE `xxl_job_info` ( `id` int(11) NOT NULL AUTO_INCREMENT, `job_group` int(11) 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(11) NOT NULL DEFAULT 0 COMMENT '任务执行超时时间，单位秒', `executor_fail_retry_count` int(11) 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(4) NOT NULL DEFAULT 0 COMMENT '调度状态：0-停止，1-运行', `trigger_last_time` bigint(13) NOT NULL DEFAULT 0 COMMENT '上次调度时间', `trigger_next_time` bigint(13) 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; -- ---------------------------- -- 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; -- ---------------------------- -- Table structure for xxl_job_log -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_log`; CREATE TABLE `xxl_job_log` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `job_group` int(11) NOT NULL COMMENT '执行器主键ID', `job_id` int(11) 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(11) NOT NULL DEFAULT 0 COMMENT '失败重试次数', `trigger_time` datetime NULL DEFAULT NULL COMMENT '调度-时间', `trigger_code` int(11) 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(11) NOT NULL COMMENT '执行-状态', `handle_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '执行-日志', `alarm_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败', PRIMARY KEY (`id`) USING BTREE, INDEX `I_trigger_time`(`trigger_time`) USING BTREE, INDEX `I_handle_code`(`handle_code`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxl_job_log_report -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_log_report`; CREATE TABLE `xxl_job_log_report` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trigger_day` datetime NULL DEFAULT NULL COMMENT '调度-时间', `running_count` int(11) NOT NULL DEFAULT 0 COMMENT '运行中-日志数量', `suc_count` int(11) NOT NULL DEFAULT 0 COMMENT '执行成功-日志数量', `fail_count` int(11) NOT NULL DEFAULT 0 COMMENT '执行失败-日志数量', `update_time` datetime NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `i_trigger_day`(`trigger_day`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxl_job_logglue -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_logglue`; CREATE TABLE `xxl_job_logglue` ( `id` int(11) NOT NULL AUTO_INCREMENT, `job_id` int(11) 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 AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxl_job_registry -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_registry`; CREATE TABLE `xxl_job_registry` ( `id` int(11) 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`, `registry_key`, `registry_value`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 62 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for xxl_job_user -- ---------------------------- DROP TABLE IF EXISTS `xxl_job_user`; CREATE TABLE `xxl_job_user` ( `id` int(11) 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(4) 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`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 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 21; 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; /* 基础 数据信息 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; -- ---------------------------- -- Records of sys_config -- ---------------------------- INSERT INTO `sys_config` VALUES (1, '000000', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '初始化密码 123456'); INSERT INTO `sys_config` VALUES (2, '000000', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '是否开启注册用户功能（true开启，false关闭）'); INSERT INTO `sys_config` VALUES (3, '000000', 'OSS预览列表资源开关', 'sys.oss.previewListResource', 'true', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, 'true:开启, false:关闭'); INSERT INTO `sys_config` VALUES (11, '000000', '维修人员USER_ID', 'sys.repair.userIds', '5,6', 'Y', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修人员ID'); INSERT INTO `sys_config` VALUES (12, '000000', '可入孵出库的蛋类型', 'breeding:eggStore:incubation:eggType', '1,2,3', 'Y', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修人员ID'); INSERT INTO `sys_config` VALUES (13, '000000', '仓库管理人员Ids', 'erp:Store:userIds', '1,2,3', 'Y', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修人员ID'); INSERT INTO `sys_config` VALUES (14, '000000', '实验审核人员USER_ID', 'sys.experiment.review.userIds', '8,9', 'Y', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '实验审核人员ID'); INSERT INTO `sys_config` VALUES (15, '000000', '销售组织结构ID', 'erp:sale:org:id', '1001', 'Y', 100, 1, '2025-10-28 16:36:05', 1, '2025-10-28 16:36:33', NULL); -- ---------------------------- -- Records of sys_dict_data -- ---------------------------- INSERT INTO `sys_dict_data` VALUES (1, '000000', 1, '男', '0', 'sys_user_sex', '', 'primary', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '性别男'); INSERT INTO `sys_dict_data` VALUES (2, '000000', 2, '女', '1', 'sys_user_sex', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '性别女'); INSERT INTO `sys_dict_data` VALUES (3, '000000', 3, '未知', '2', 'sys_user_sex', '', 'warning', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '性别未知'); INSERT INTO `sys_dict_data` VALUES (4, '000000', 1, '显示', '0', 'sys_show_hide', '', 'primary', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '显示菜单'); INSERT INTO `sys_dict_data` VALUES (5, '000000', 2, '隐藏', '1', 'sys_show_hide', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '隐藏菜单'); INSERT INTO `sys_dict_data` VALUES (6, '000000', 1, '正常', '0', 'sys_normal_disable', '', 'primary', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '正常状态'); INSERT INTO `sys_dict_data` VALUES (7, '000000', 2, '停用', '1', 'sys_normal_disable', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '停用状态'); INSERT INTO `sys_dict_data` VALUES (12, '000000', 1, '是', 'Y', 'sys_yes_no', '', 'primary', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '系统默认是'); INSERT INTO `sys_dict_data` VALUES (13, '000000', 2, '否', 'N', 'sys_yes_no', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '系统默认否'); INSERT INTO `sys_dict_data` VALUES (14, '000000', 1, '通知', '1', 'sys_notice_type', '', 'warning', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '通知'); INSERT INTO `sys_dict_data` VALUES (15, '000000', 2, '公告', '2', 'sys_notice_type', '', 'success', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '公告'); INSERT INTO `sys_dict_data` VALUES (16, '000000', 1, '正常', '0', 'sys_notice_status', '', 'primary', 'Y', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '正常状态'); INSERT INTO `sys_dict_data` VALUES (17, '000000', 2, '关闭', '1', 'sys_notice_status', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '关闭状态'); INSERT INTO `sys_dict_data` VALUES (18, '000000', 1, '新增', '1', 'sys_oper_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '新增操作'); INSERT INTO `sys_dict_data` VALUES (19, '000000', 2, '修改', '2', 'sys_oper_type', '', 'success', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '修改操作'); INSERT INTO `sys_dict_data` VALUES (20, '000000', 3, '删除', '3', 'sys_oper_type', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '删除操作'); INSERT INTO `sys_dict_data` VALUES (21, '000000', 4, '授权', '4', 'sys_oper_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '授权操作'); INSERT INTO `sys_dict_data` VALUES (22, '000000', 5, '导出', '5', 'sys_oper_type', '', 'warning', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '导出操作'); INSERT INTO `sys_dict_data` VALUES (23, '000000', 6, '导入', '6', 'sys_oper_type', '', 'warning', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '导入操作'); INSERT INTO `sys_dict_data` VALUES (24, '000000', 7, '强退', '7', 'sys_oper_type', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '强退操作'); INSERT INTO `sys_dict_data` VALUES (25, '000000', 8, '生成代码', '8', 'sys_oper_type', '', 'warning', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '生成操作'); INSERT INTO `sys_dict_data` VALUES (26, '000000', 9, '清空数据', '9', 'sys_oper_type', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '清空操作'); INSERT INTO `sys_dict_data` VALUES (27, '000000', 1, '成功', '0', 'sys_common_status', '', 'success', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '正常状态'); INSERT INTO `sys_dict_data` VALUES (28, '000000', 2, '失败', '1', 'sys_common_status', '', 'danger', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '停用状态'); INSERT INTO `sys_dict_data` VALUES (29, '000000', 99, '其他', '0', 'sys_oper_type', '', 'info', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '其他操作'); INSERT INTO `sys_dict_data` VALUES (30, '000000', 0, '密码认证', 'password', 'sys_grant_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '密码认证'); INSERT INTO `sys_dict_data` VALUES (31, '000000', 0, '短信认证', 'sms', 'sys_grant_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '短信认证'); INSERT INTO `sys_dict_data` VALUES (32, '000000', 0, '邮件认证', 'email', 'sys_grant_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '邮件认证'); INSERT INTO `sys_dict_data` VALUES (33, '000000', 0, '小程序认证', 'xcx', 'sys_grant_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '小程序认证'); INSERT INTO `sys_dict_data` VALUES (34, '000000', 0, '三方登录认证', 'social', 'sys_grant_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '三方登录认证'); INSERT INTO `sys_dict_data` VALUES (35, '000000', 0, 'PC', 'pc', 'sys_device_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, 'PC'); INSERT INTO `sys_dict_data` VALUES (36, '000000', 0, '安卓', 'android', 'sys_device_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '安卓'); INSERT INTO `sys_dict_data` VALUES (37, '000000', 0, 'iOS', 'ios', 'sys_device_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, 'iOS'); INSERT INTO `sys_dict_data` VALUES (38, '000000', 0, '小程序', 'xcx', 'sys_device_type', '', 'primary', 'N', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '小程序'); INSERT INTO `sys_dict_data` VALUES (41, '000000', 0, '未读', '0', 'sys_notice_read_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '未读'); INSERT INTO `sys_dict_data` VALUES (42, '000000', 0, '已读', '1', 'sys_notice_read_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已读'); INSERT INTO `sys_dict_data` VALUES (100, '000000', 1, '灭活疫苗', '0', 'vaccine_type', NULL, NULL, 'Y', 100, 1, '2025-07-14 17:27:06', 1, '2025-07-14 17:27:06', NULL); INSERT INTO `sys_dict_data` VALUES (101, '000000', 1, '活疫苗', '1', 'vaccine_type', NULL, NULL, 'N', 100, 1, '2025-07-14 17:27:23', 1, '2025-07-14 17:27:28', NULL); INSERT INTO `sys_dict_data` VALUES (102, '000000', 2, '重组蛋白疫苗', '2', 'vaccine_type', NULL, NULL, 'Y', 100, 1, '2025-07-14 17:27:54', 1, '2025-07-14 17:27:54', NULL); INSERT INTO `sys_dict_data` VALUES (103, '000000', 1, '可用', '0', 'vaccine_status', NULL, NULL, 'Y', 100, 1, '2025-07-14 17:29:10', 1, '2025-07-14 17:29:10', NULL); INSERT INTO `sys_dict_data` VALUES (104, '000000', 2, '缺货', '1', 'vaccine_status', NULL, 'warning', 'N', 100, 1, '2025-07-14 17:30:14', 1, '2025-07-14 17:30:14', NULL); INSERT INTO `sys_dict_data` VALUES (105, '000000', 3, '过期', '2', 'vaccine_status', NULL, 'danger', 'N', 100, 1, '2025-07-14 21:27:55', 1, '2025-07-14 21:27:55', NULL); INSERT INTO `sys_dict_data` VALUES (106, '000000', 1, '公', '0', 'chicken_gender', NULL, 'primary', 'N', 100, 1, '2025-07-15 10:25:10', 1, '2025-07-15 10:25:10', NULL); INSERT INTO `sys_dict_data` VALUES (107, '000000', 2, '母', '1', 'chicken_gender', NULL, 'success', 'N', 100, 1, '2025-07-15 10:25:33', 1, '2025-07-15 10:25:43', NULL); INSERT INTO `sys_dict_data` VALUES (108, '000000', 1, '启用', '0', 'sop_status', NULL, 'primary', 'N', 100, 1, '2025-07-15 10:26:57', 1, '2025-07-15 10:27:08', NULL); INSERT INTO `sys_dict_data` VALUES (109, '000000', 2, '禁用', '1', 'sop_status', NULL, 'danger', 'N', 100, 1, '2025-07-15 10:27:48', 1, '2025-07-15 10:28:21', NULL); INSERT INTO `sys_dict_data` VALUES (111, '000000', 1, '闲置', '0', 'wing_tag_status', NULL, 'primary', 'Y', 100, 1, '2025-07-16 16:00:34', 1, '2025-07-16 16:00:34', NULL); INSERT INTO `sys_dict_data` VALUES (112, '000000', 2, '绑定中', '1', 'wing_tag_status', NULL, 'success', 'Y', 100, 1, '2025-07-16 16:00:59', 1, '2025-07-24 11:02:37', NULL); INSERT INTO `sys_dict_data` VALUES (114, '000000', 1, '正常', '0', 'chicken_coop_status', NULL, 'success', 'Y', 100, 1, '2025-07-16 17:11:30', 1, '2025-07-16 17:11:30', NULL); INSERT INTO `sys_dict_data` VALUES (115, '000000', 2, '异常', '1', 'chicken_coop_status', NULL, 'warning', 'N', 100, 1, '2025-07-16 17:11:43', 1, '2025-07-16 17:11:43', NULL); INSERT INTO `sys_dict_data` VALUES (116, '000000', 1, '正常', '0', 'chicken_cage_status', NULL, 'primary', 'Y', 100, 1, '2025-07-16 20:17:02', 1, '2025-07-24 11:04:48', NULL); INSERT INTO `sys_dict_data` VALUES (117, '000000', 2, '异常', '1', 'chicken_cage_status', NULL, 'info', 'N', 100, 1, '2025-07-16 20:17:29', 1, '2025-07-24 11:04:37', NULL); INSERT INTO `sys_dict_data` VALUES (119, '000000', 1, 'A系', 'A', 'variety_lineage', NULL, 'primary', 'Y', 100, 1, '2025-07-17 11:57:39', 1, '2025-07-17 11:57:39', NULL); INSERT INTO `sys_dict_data` VALUES (120, '000000', 2, 'B系', 'B', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:20', 1, '2025-07-17 13:20:20', NULL); INSERT INTO `sys_dict_data` VALUES (121, '000000', 3, 'C系', 'C', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:26', 1, '2025-07-17 13:20:26', NULL); INSERT INTO `sys_dict_data` VALUES (122, '000000', 4, 'D系', 'D', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL); INSERT INTO `sys_dict_data` VALUES (123, '000000', 5, 'E系', 'E', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL); INSERT INTO `sys_dict_data` VALUES (124, '000000', 6, 'F系', 'F', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL); INSERT INTO `sys_dict_data` VALUES (125, '000000', 7, 'G系', 'G', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL); INSERT INTO `sys_dict_data` VALUES (126, '000000', 8, 'H系', 'H', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL); INSERT INTO `sys_dict_data` VALUES (127, '000000', 9, 'I系', 'I', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL); INSERT INTO `sys_dict_data` VALUES (128, '000000', 10, 'J系', 'J', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL); INSERT INTO `sys_dict_data` VALUES (129, '000000', 11, 'K系', 'K', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:27', 1, '2025-07-17 13:20:27', NULL); INSERT INTO `sys_dict_data` VALUES (130, '000000', 12, 'L系', 'L', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:28', 1, '2025-07-17 13:20:28', NULL); INSERT INTO `sys_dict_data` VALUES (131, '000000', 13, 'M系', 'M', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:28', 1, '2025-07-17 13:20:28', NULL); INSERT INTO `sys_dict_data` VALUES (132, '000000', 14, 'N系', 'N', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:28', 1, '2025-07-17 13:20:28', NULL); INSERT INTO `sys_dict_data` VALUES (133, '000000', 15, 'O系', 'O', 'variety_lineage', NULL, 'primary', 'N', 100, 1, '2025-07-17 13:20:28', 1, '2025-07-17 13:20:28', NULL); INSERT INTO `sys_dict_data` VALUES (134, '000000', 1, '新建', '0', 'batch_status', NULL, 'primary', 'Y', 100, 1, '2025-07-17 14:23:50', 1, '2025-07-17 14:23:50', NULL); INSERT INTO `sys_dict_data` VALUES (135, '000000', 2, '育成中', '1', 'batch_status', NULL, 'success', 'Y', 100, 1, '2025-07-17 14:24:08', 1, '2025-07-17 14:24:19', NULL); INSERT INTO `sys_dict_data` VALUES (136, '000000', 3, '完成', '2', 'batch_status', NULL, 'info', 'N', 100, 1, '2025-07-17 15:05:34', 1, '2025-07-17 15:05:34', NULL); INSERT INTO `sys_dict_data` VALUES (137, '000000', 1, '在养', '0', 'chicken_status', NULL, 'success', 'Y', 100, 1, '2025-07-17 18:35:51', 1, '2025-07-17 18:35:51', NULL); INSERT INTO `sys_dict_data` VALUES (138, '000000', 2, '已淘汰', '1', 'chicken_status', NULL, 'warning', 'N', 100, 1, '2025-07-17 18:36:20', 1, '2025-07-17 18:36:20', NULL); INSERT INTO `sys_dict_data` VALUES (140, '000000', 1, '腿病', '1', 'chicken_cull_reason', NULL, 'primary', 'Y', 100, 1, '2025-07-17 18:56:40', 1, '2025-08-11 15:52:20', NULL); INSERT INTO `sys_dict_data` VALUES (141, '000000', 2, '腹水', '2', 'chicken_cull_reason', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:57:03', 1, '2025-08-11 15:52:27', NULL); INSERT INTO `sys_dict_data` VALUES (142, '000000', 3, '细菌感染', '3', 'chicken_cull_reason', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:57:15', 1, '2025-07-17 18:57:15', NULL); INSERT INTO `sys_dict_data` VALUES (143, '000000', 4, '外伤', '4', 'chicken_cull_reason', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:57:39', 1, '2025-07-17 18:57:39', NULL); INSERT INTO `sys_dict_data` VALUES (172, '000000', 9, '转群', '5', 'chicken_cull_reason', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:57:39', 1, '2025-07-17 18:57:39', NULL); INSERT INTO `sys_dict_data` VALUES (144, '000000', 1, '无害化', '0', 'chicken_disposal_method', NULL, 'primary', 'Y', 100, 1, '2025-07-17 18:58:01', 1, '2025-07-17 18:58:01', NULL); INSERT INTO `sys_dict_data` VALUES (145, '000000', 2, '食堂', '1', 'chicken_disposal_method', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:58:19', 1, '2025-07-17 18:58:19', NULL); INSERT INTO `sys_dict_data` VALUES (146, '000000', 3, '屠宰场', '2', 'chicken_disposal_method', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:58:31', 1, '2025-07-17 18:58:31', NULL); INSERT INTO `sys_dict_data` VALUES (171, '000000', 9, '转群', '3', 'chicken_disposal_method', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:58:31', 1, '2025-07-17 18:58:31', NULL); INSERT INTO `sys_dict_data` VALUES (147, '000000', 1, '正常', '0', 'family_status', NULL, 'primary', 'Y', 100, 1, '2025-07-18 10:26:25', 1, '2025-07-24 11:00:55', NULL); INSERT INTO `sys_dict_data` VALUES (148, '000000', 2, '异常', '1', 'family_status', NULL, 'info', 'N', 100, 1, '2025-07-18 10:26:48', 1, '2025-07-24 11:07:07', NULL); #INSERT INTO `sys_dict_data` VALUES (150, '000000', 1, '好种蛋', '0', 'breeding_egg_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); #INSERT INTO `sys_dict_data` VALUES (151, '000000', 2, '好菜蛋', '1', 'breeding_egg_type', NULL, 'primary', 'N', 100, 1, '2025-07-21 09:53:44', 1, '2025-07-21 09:54:30', NULL); #INSERT INTO `sys_dict_data` VALUES (152, '000000', 3, '畸形蛋', '2', 'breeding_egg_type', NULL, 'info', 'N', 100, 1, '2025-07-21 09:54:03', 1, '2025-07-31 13:16:00', NULL); #INSERT INTO `sys_dict_data` VALUES (153, '000000', 4, '破蛋', '3', 'breeding_egg_type', NULL, 'warning', 'N', 100, 1, '2025-07-21 09:54:21', 1, '2025-07-31 13:16:09', NULL); INSERT INTO `sys_dict_data` VALUES (154, '000000', 1, '待确认', '0', 'cage_change_status', NULL, 'primary', 'Y', 100, 1, '2025-07-28 13:53:25', 1, '2025-07-28 16:45:12', NULL); INSERT INTO `sys_dict_data` VALUES (155, '000000', 2, '审核通过', '1', 'cage_change_status', NULL, 'success', 'N', 100, 1, '2025-07-28 13:54:07', 1, '2025-07-28 13:54:07', NULL); INSERT INTO `sys_dict_data` VALUES (156, '000000', 3, '作废', '2', 'cage_change_status', NULL, 'info', 'N', 100, 1, '2025-07-28 13:54:31', 1, '2025-07-28 13:54:31', NULL); INSERT INTO `sys_dict_data` VALUES (157, '000000', 1, '祖代厂孵化', '1', 'pull_out_type', NULL, 'primary', 'Y', 100, 1, '2025-07-30 12:35:30', 1, '2025-07-30 12:35:30', NULL); INSERT INTO `sys_dict_data` VALUES (158, '000000', 2, '食堂', '2', 'pull_out_type', NULL, 'primary', 'N', 100, 1, '2025-07-30 12:35:45', 1, '2025-07-30 12:35:45', NULL); INSERT INTO `sys_dict_data` VALUES (159, '000000', 3, '实验室', '3', 'pull_out_type', NULL, 'primary', 'N', 100, 1, '2025-07-30 12:35:54', 1, '2025-07-30 12:35:54', NULL); INSERT INTO `sys_dict_data` VALUES (160, '000000', 4, '菜蛋销售', '4', 'pull_out_type', NULL, 'primary', 'N', 100, 1, '2025-07-30 12:36:09', 1, '2025-07-30 12:36:09', NULL); INSERT INTO `sys_dict_data` VALUES (161, '000000', 5, '其它', '5', 'chicken_cull_reason', NULL, 'primary', 'N', 100, 1, '2025-07-17 18:57:39', 1, '2025-07-17 18:57:39', NULL); INSERT INTO `sys_dict_data` VALUES (162, '000000', 0, '测定中', '0', 'measure_detail_status', NULL, 'primary', 'Y', 100, 1, '2025-08-12 09:34:50', 1, '2025-08-12 09:34:58', NULL); INSERT INTO `sys_dict_data` VALUES (163, '000000', 1, '结束', '1', 'measure_detail_status', NULL, 'info', 'N', 100, 1, '2025-08-12 09:35:16', 1, '2025-08-12 09:35:16', NULL); INSERT INTO `sys_dict_data` VALUES (164, '000000', 2, '淘汰', '2', 'measure_detail_status', NULL, 'warning', 'N', 100, 1, '2025-08-12 09:35:35', 1, '2025-08-12 09:35:35', NULL); INSERT INTO `sys_dict_data` VALUES (165, '000000', 1, '育成舍', '1', 'chicken_coop_type', NULL, 'primary', 'Y', 100, 1, '2025-08-18 11:55:32', 1, '2025-08-18 11:55:32', NULL); INSERT INTO `sys_dict_data` VALUES (166, '000000', 2, '产蛋舍', '2', 'chicken_coop_type', NULL, 'primary', 'N', 100, 1, '2025-08-18 11:55:44', 1, '2025-08-18 11:55:44', NULL); INSERT INTO `sys_dict_data` VALUES (167, '000000', 1, '育种厂', '0', 'factory_info', NULL, 'primary', 'Y', 100, 1, '2025-08-18 11:58:30', 1, '2025-08-18 11:58:30', NULL); INSERT INTO `sys_dict_data` VALUES (173, '000000', 2, '祖代厂', '1', 'factory_info', NULL, 'primary', 'Y', 100, 1, '2025-08-18 11:58:30', 1, '2025-08-18 11:58:30', NULL); INSERT INTO `sys_dict_data` VALUES (168, '000000', 3, '育雏舍', '3', 'chicken_coop_type', NULL, 'primary', 'N', 100, 1, '2025-08-18 11:55:44', 1, '2025-08-18 11:55:44', NULL); INSERT INTO `sys_dict_data` VALUES (169, '000000', 4, '测定舍', '4', 'chicken_coop_type', NULL, 'primary', 'N', 100, 1, '2025-08-18 11:55:44', 1, '2025-08-18 11:55:44', NULL); INSERT INTO `sys_dict_data` VALUES (170, '000000', 3, '未知', '2', 'chicken_gender', NULL, NULL, 'N', 100, 1, '2025-09-08 09:06:34', 1, '2025-09-08 09:06:34', NULL); INSERT INTO `sys_dict_data` VALUES (174, '000000', 1, '育种厂', '0', 'batch_type', NULL, NULL, 'N', 100, 1, '2025-09-08 09:06:34', 1, '2025-09-08 09:06:34', NULL); INSERT INTO `sys_dict_data` VALUES (175, '000000', 2, '祖代厂', '1', 'batch_type', NULL, NULL, 'N', 100, 1, '2025-09-08 09:06:34', 1, '2025-09-08 09:06:34', NULL); INSERT INTO `sys_dict_data` VALUES (176, '000000', 3, '育种转祖代', '2', 'batch_type', NULL, NULL, 'N', 100, 1, '2025-09-08 09:06:34', 1, '2025-09-08 09:06:34', NULL); -- ---------------------------- -- Records of sys_dict_type -- ---------------------------- INSERT INTO `sys_dict_type` VALUES (1, '000000', '用户性别', 'sys_user_sex', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '用户性别列表'); INSERT INTO `sys_dict_type` VALUES (2, '000000', '隐藏状态', 'sys_show_hide', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '菜单隐藏状态列表(1隐藏0显示)'); INSERT INTO `sys_dict_type` VALUES (3, '000000', '启用状态', 'sys_normal_disable', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '系统启用状态列表'); INSERT INTO `sys_dict_type` VALUES (6, '000000', '系统是否', 'sys_yes_no', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '系统是否列表'); INSERT INTO `sys_dict_type` VALUES (7, '000000', '通知类型', 'sys_notice_type', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '通知类型列表'); INSERT INTO `sys_dict_type` VALUES (8, '000000', '通知状态', 'sys_notice_status', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '通知状态列表'); INSERT INTO `sys_dict_type` VALUES (9, '000000', '操作类型', 'sys_oper_type', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '操作类型列表'); INSERT INTO `sys_dict_type` VALUES (10, '000000', '操作状态', 'sys_common_status', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '操作状态列表'); INSERT INTO `sys_dict_type` VALUES (11, '000000', '授权类型', 'sys_grant_type', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '认证授权类型'); INSERT INTO `sys_dict_type` VALUES (12, '000000', '设备类型', 'sys_device_type', 100, 1, '2025-07-10 14:59:14', NULL, NULL, '客户端设备类型'); INSERT INTO `sys_dict_type` VALUES (13, '000000', '消息阅读状态', 'sys_notice_read_status', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '0：未读 1：已读'); INSERT INTO `sys_dict_type` VALUES (100, '000000', '疫苗种类', 'vaccine_type', 100, 1, '2025-07-14 17:26:23', 1, '2025-07-14 17:26:23', '疫苗种类（0:灭活疫苗, 1:活疫苗, 2:重组蛋白疫苗）'); INSERT INTO `sys_dict_type` VALUES (101, '000000', '疫苗状态', 'vaccine_status', 100, 1, '2025-07-14 17:28:35', 1, '2025-07-14 17:28:35', '状态（0:可用, 1:缺货, 2:过期）'); INSERT INTO `sys_dict_type` VALUES (102, '000000', '家禽性别', 'chicken_gender', 100, 1, '2025-07-15 10:24:17', 1, '2025-09-08 09:06:14', '家禽性别（0：公 1：母 2：未知）'); INSERT INTO `sys_dict_type` VALUES (103, '000000', 'sop状态', 'sop_status', 100, 1, '2025-07-15 10:26:34', 1, '2025-07-24 11:01:54', '状态（0:启用, 1:禁用）'); INSERT INTO `sys_dict_type` VALUES (104, '000000', '翅号状态', 'wing_tag_status', 100, 1, '2025-07-16 15:58:49', 1, '2025-07-24 11:02:21', '状态（0:闲置, 1:已绑定）'); INSERT INTO `sys_dict_type` VALUES (105, '000000', '鸡舍状态', 'chicken_coop_status', 100, 1, '2025-07-16 17:11:05', 1, '2025-07-16 17:11:05', '状态(0:正常 1:异常)'); INSERT INTO `sys_dict_type` VALUES (106, '000000', '鸡笼状态', 'chicken_cage_status', 100, 1, '2025-07-16 20:16:21', 1, '2025-07-24 11:04:15', '状态（0:正常, 1:异常）'); INSERT INTO `sys_dict_type` VALUES (107, '000000', '品系系别', 'variety_lineage', 100, 1, '2025-07-17 11:56:03', 1, '2025-07-17 11:56:33', 'A~O系,例：A系，B系。。。。O系'); INSERT INTO `sys_dict_type` VALUES (108, '000000', '批次状态', 'batch_status', 100, 1, '2025-07-17 14:22:12', 1, '2025-07-17 14:22:12', '状态（0:新建, 1:育成中, 2:完成）'); INSERT INTO `sys_dict_type` VALUES (109, '000000', '鸡个体状态', 'chicken_status', 100, 1, '2025-07-17 18:21:26', 1, '2025-07-24 09:38:54', '状态（0:在养, 1:已淘汰）'); INSERT INTO `sys_dict_type` VALUES (110, '000000', '鸡个体淘汰原因', 'chicken_cull_reason', 100, 1, '2025-07-17 18:54:19', 1, '2025-08-11 15:55:42', '“腿病”、“腹水”、“细菌感染”、“外伤”，其他'); INSERT INTO `sys_dict_type` VALUES (111, '000000', '鸡个体处置方式', 'chicken_disposal_method', 100, 1, '2025-07-17 18:55:31', 1, '2025-07-17 18:55:31', '“无害化”，“食堂”，“屠宰场”'); INSERT INTO `sys_dict_type` VALUES (112, '000000', '家系配种状态', 'family_status', 100, 1, '2025-07-18 10:25:34', 1, '2025-07-24 11:06:51', '状态（0:正常, 1:异常）'); INSERT INTO `sys_dict_type` VALUES (114, '000000', '换笼状态', 'cage_change_status', 100, 1, '2025-07-28 13:52:49', 1, '2025-07-28 13:52:49', '换笼状态'); INSERT INTO `sys_dict_type` VALUES (115, '000000', '外拉类型', 'pull_out_type', 100, 1, '2025-07-30 12:34:45', 1, '2025-07-30 12:34:59', '外拉类型（0：祖代厂 1:食堂 2:实验室 3:菜蛋销售）'); INSERT INTO `sys_dict_type` VALUES (116, '000000', '测定记录详情状态', 'measure_detail_status', 100, 1, '2025-08-12 09:34:11', 1, '2025-08-12 09:34:11', '测定中，结束，淘汰'); INSERT INTO `sys_dict_type` VALUES (117, '000000', '鸡舍类型', 'chicken_coop_type', 100, 1, '2025-08-18 11:53:36', 1, '2025-08-18 11:55:00', '1:育成舍 2：产蛋舍'); INSERT INTO `sys_dict_type` VALUES (118, '000000', '厂区信息', 'factory_info', 100, 1, '2025-08-18 11:57:49', 1, '2025-08-18 11:57:49', '厂区信息'); INSERT INTO `sys_dict_type` VALUES (119, '000000', '批次类型', 'batch_type', 100, 1, '2025-07-17 14:22:12', 1, '2025-07-17 14:22:12', '状态（0:新建, 1:育成中, 2:完成）'); INSERT INTO `sys_dict_type` VALUES (301, '000000', '设备状态', 'device_status', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '0：正常运行 1：维修中 2：带病运行 3：退役'); INSERT INTO `sys_dict_data` VALUES (301, '000000', 0, '正常运行', '0', 'device_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修中'); INSERT INTO `sys_dict_data` VALUES (302, '000000', 0, '维修中', '1', 'device_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '维修中'); INSERT INTO `sys_dict_data` VALUES (303, '000000', 0, '带病运行', '2', 'device_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '带病运行'); INSERT INTO `sys_dict_data` VALUES (304, '000000', 0, '退役', '3', 'device_status', '', 'info', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '退役'); INSERT INTO `sys_dict_type` VALUES (302, '000000', '设备工单类型', 'device_order_type', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '1:故障报修 2:设备保养 3:清洁 4:消毒'); INSERT INTO `sys_dict_data` VALUES (307, '000000', 0, '故障报修', '1', 'device_order_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '故障报修'); INSERT INTO `sys_dict_data` VALUES (308, '000000', 0, '设备保养', '2', 'device_order_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '设备保养'); INSERT INTO `sys_dict_data` VALUES (309, '000000', 0, '清洁', '3', 'device_order_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '清洁'); INSERT INTO `sys_dict_data` VALUES (310, '000000', 0, '消毒', '4', 'device_order_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '消毒'); INSERT INTO `sys_dict_type` VALUES (303, '000000', '设备工单状态', 'device_order_status', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '0:待处理 1:处理中 2:已暂缓 3:待验收 4:验收未通过 5:已完成'); INSERT INTO `sys_dict_data` VALUES (311, '000000', 0, '待处理', '0', 'device_order_status', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '待处理'); INSERT INTO `sys_dict_data` VALUES (312, '000000', 0, '处理中', '1', 'device_order_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '处理中'); INSERT INTO `sys_dict_data` VALUES (313, '000000', 0, '已暂缓', '2', 'device_order_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已暂缓'); INSERT INTO `sys_dict_data` VALUES (314, '000000', 0, '待验收', '3', 'device_order_status', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '待验收'); INSERT INTO `sys_dict_data` VALUES (315, '000000', 0, '验收未通过', '4', 'device_order_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '验收未通过'); INSERT INTO `sys_dict_data` VALUES (316, '000000', 0, '已完成', '5', 'device_order_status', '', 'default', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已完成'); INSERT INTO `sys_dict_type` VALUES (304, '000000', '工单流转类型', 'device_order_flow_type', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '1:创建工单 2:修改工单 3:变更协助人 4:接收工单 5:暂缓工单 6:恢复工单 7:提交验收 8:验收通过 9:验收拒绝'); INSERT INTO `sys_dict_data` VALUES (319, '000000', 0, '创建工单', '1', 'device_order_flow_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '创建工单'); INSERT INTO `sys_dict_data` VALUES (320, '000000', 0, '修改工单', '2', 'device_order_flow_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '修改工单'); INSERT INTO `sys_dict_data` VALUES (321, '000000', 0, '变更协助人', '3', 'device_order_flow_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '变更协助人'); INSERT INTO `sys_dict_data` VALUES (322, '000000', 0, '接收工单', '4', 'device_order_flow_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '接收工单'); INSERT INTO `sys_dict_data` VALUES (323, '000000', 0, '暂缓工单', '5', 'device_order_flow_type', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '暂缓工单'); INSERT INTO `sys_dict_data` VALUES (324, '000000', 0, '恢复工单', '6', 'device_order_flow_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '恢复工单'); INSERT INTO `sys_dict_data` VALUES (325, '000000', 0, '提交验收', '7', 'device_order_flow_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '提交验收'); INSERT INTO `sys_dict_data` VALUES (326, '000000', 0, '验收通过', '8', 'device_order_flow_type', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '验收通过'); INSERT INTO `sys_dict_data` VALUES (327, '000000', 0, '验收拒绝', '9', 'device_order_flow_type', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '验收拒绝'); INSERT INTO `sys_dict_type` VALUES (305, '000000', '任务类型', 'device_task_type', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '1:设备保养 2:设备清洁'); INSERT INTO `sys_dict_data` VALUES (331, '000000', 0, '设备保养', '1', 'device_task_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '设备保养'); INSERT INTO `sys_dict_data` VALUES (332, '000000', 0, '设备清洁', '2', 'device_task_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '设备清洁'); INSERT INTO `sys_dict_data` VALUES (333, '000000', 0, '设备消毒', '3', 'device_task_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '设备消毒'); INSERT INTO `sys_dict_type` VALUES (306, '000000', '清洁类型', 'device_clean_type', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '1:清洁 2:消毒'); INSERT INTO `sys_dict_data` VALUES (335, '000000', 0, '清洁', '1', 'device_clean_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '清洁'); INSERT INTO `sys_dict_data` VALUES (336, '000000', 0, '消毒', '2', 'device_clean_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '消毒'); INSERT INTO `sys_dict_type` VALUES (307, '000000', '点检签到类型', 'device_inspection_type', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '0:未签到 1:签到'); INSERT INTO `sys_dict_data` VALUES (341, '000000', 0, '未签到', '0', 'device_inspection_type', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '未签到'); INSERT INTO `sys_dict_data` VALUES (342, '000000', 0, '签到', '1', 'device_inspection_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '签到'); INSERT INTO `sys_dict_type` VALUES (311, '000000', '实验样品类型', 'experiment_sample_type', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '1：血液 2：粪便'); INSERT INTO `sys_dict_data` VALUES (351, '000000', 0, '血液', '1', 'experiment_sample_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '血液'); INSERT INTO `sys_dict_data` VALUES (352, '000000', 0, '粪便', '2', 'experiment_sample_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '粪便'); INSERT INTO `sys_dict_type` VALUES (312, '000000', '实验样品状态', 'experiment_sample_status', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '1：新建 2：已采样 3：实验中 4：已销毁'); INSERT INTO `sys_dict_data` VALUES (355, '000000', 0, '已创建', '1', 'experiment_sample_status', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '新建'); INSERT INTO `sys_dict_data` VALUES (356, '000000', 0, '已采样', '2', 'experiment_sample_status', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已采样'); INSERT INTO `sys_dict_data` VALUES (357, '000000', 0, '实验中', '3', 'experiment_sample_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '实验中'); INSERT INTO `sys_dict_data` VALUES (358, '000000', 0, '已销毁', '4', 'experiment_sample_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已销毁'); INSERT INTO `sys_dict_type` VALUES (313, '000000', '实验类型', 'experiment_type', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '1：平板凝集-沙门氏菌 2：ELISA-白血病P27抗原 3：ELISA-抗体 4：荧光定量PCR 5：HI-抗体'); INSERT INTO `sys_dict_data` VALUES (361, '000000', 0, '平板凝集-沙门氏菌', '1', 'experiment_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '平板凝集-沙门氏菌'); INSERT INTO `sys_dict_data` VALUES (362, '000000', 0, 'ELISA-白血病P27抗原', '2', 'experiment_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, 'ELISA-白血病P27抗原'); INSERT INTO `sys_dict_data` VALUES (363, '000000', 0, 'ELISA-抗体', '3', 'experiment_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, 'ELISA-抗体'); INSERT INTO `sys_dict_data` VALUES (364, '000000', 0, '荧光定量PCR', '4', 'experiment_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '荧光定量PCR'); INSERT INTO `sys_dict_data` VALUES (365, '000000', 0, 'HI-抗体', '5', 'experiment_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, 'HI-抗体'); INSERT INTO `sys_dict_type` VALUES (314, '000000', '实验状态', 'experiment_status', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '1：新建 2：进行中 3：审核中 4：发回报告 5：已结束'); INSERT INTO `sys_dict_data` VALUES (371, '000000', 0, '未开始', '1', 'experiment_status', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '新建'); INSERT INTO `sys_dict_data` VALUES (372, '000000', 0, '进行中', '2', 'experiment_status', '', 'success', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '进行中'); INSERT INTO `sys_dict_data` VALUES (373, '000000', 0, '审核中', '3', 'experiment_status', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '审核中'); INSERT INTO `sys_dict_data` VALUES (374, '000000', 0, '发回报告', '4', 'experiment_status', '', 'danger', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '发回报告'); INSERT INTO `sys_dict_data` VALUES (375, '000000', 0, '已结束', '5', 'experiment_status', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '已结束'); INSERT INTO `sys_dict_type` VALUES (501, '000000', '仓库类型', 'store_house_type', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '1:故障报修 2:保养管理'); INSERT INTO `sys_dict_data` VALUES (501, '000000', 1, '饲料场原料仓库', '1', 'store_house_type', '', 'primary', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '故障报修'); INSERT INTO `sys_dict_data` VALUES (502, '000000', 2, '饲料场半成品仓库', '2', 'store_house_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '保养管理'); INSERT INTO `sys_dict_data` VALUES (503, '000000', 3, '五金仓库', '3', 'store_house_type', '', 'warning', 'N', 100, 1, '2025-10-15 12:00:00', NULL, NULL, '保养管理'); INSERT INTO `sys_dict_type` VALUES (510, '000000', '种蛋类型', 'egg_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '蛋分类（1:纯系种蛋, 2:祖代蛋, 3:父母代蛋, 4:菜蛋, 3:畸形蛋, 4:破蛋）'); INSERT INTO `sys_dict_data` VALUES (511, '000000', 1, '纯系种蛋', '1', 'egg_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (512, '000000', 2, '祖代蛋', '2', 'egg_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (513, '000000', 3, '父母代蛋', '3', 'egg_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (514, '000000', 3, '菜蛋', '3', 'egg_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (515, '000000', 3, '畸形蛋', '3', 'egg_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (516, '000000', 3, '破蛋', '3', 'egg_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (520, '000000', '供应商等级', 'supplier_level', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '供应商等级分类（1:一级, 2:二级, 3:三级）'); INSERT INTO `sys_dict_data` VALUES (521, '000000', 1, '一级', '1', 'supplier_level', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (522, '000000', 2, '二级', '2', 'supplier_level', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (523, '000000', 3, '三级', '2', 'supplier_level', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (530, '000000', '物品类型', 'item_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '供应商等级分类（1:一级, 2:二级, 3:三级）'); INSERT INTO `sys_dict_data` VALUES (531, '000000', 1, '实体物品', '1', 'item_type', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (532, '000000', 2, '虚拟物品', '2', 'item_type', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (533, '000000', 9, '其它', '3', 'item_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (540, '000000', '单位类型', 'unit_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '供应商等级分类（1:一级, 2:二级, 3:三级）'); INSERT INTO `sys_dict_data` VALUES (541, '000000', 1, '长度', '1', 'unit_type', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (542, '000000', 2, '重量', '2', 'unit_type', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (543, '000000', 3, '体积', '3', 'unit_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (544, '000000', 4, '通用数量', '4', 'unit_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (550, '000000', '入库业务类型', 'in_business_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '入库业务类型 普通采购、定期采购等'); INSERT INTO `sys_dict_data` VALUES (551, '000000', 1, '普通采购', '1', 'in_business_type', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (552, '000000', 2, '定期采购', '2', 'in_business_type', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (553, '000000', 3, '加工生产', '3', 'in_business_type', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (560, '000000', '入库种类', 'in_store_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '入库种类:（采购等）'); INSERT INTO `sys_dict_data` VALUES (561, '000000', 1, '采购', '1', 'in_store_type', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (562, '000000', 2, '半成品生产', '2', 'in_store_type', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (570, '000000', '出库业务类型', 'out_business_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '出库业务类型 直接领料，生产补料等'); INSERT INTO `sys_dict_data` VALUES (571, '000000', 1, '直接领料', '1', 'out_business_type', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (572, '000000', 2, '生产补料', '2', 'out_business_type', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (580, '000000', '出库种类', 'out_store_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '入库类别:（材料出库等）'); INSERT INTO `sys_dict_data` VALUES (581, '000000', 1, '材料出库', '1', 'out_store_type', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (582, '000000', 2, '半成品生产', '2', 'out_store_type', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (590, '000000', '仓库出入库状态', 'store_in_out_status', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '出入库状态:（0：待审核 1：通过 2：未通过）'); INSERT INTO `sys_dict_data` VALUES (591, '000000', 1, '待审核', '1', 'store_in_out_status', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (592, '000000', 2, '通过', '2', 'store_in_out_status', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (593, '000000', 3, '未通过', '3', 'store_in_out_status', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (594, '000000', 4, '作废', '4', 'store_in_out_status', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (600, '000000', '生产业务类型', 'production_business_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '出入库状态:（0：待审核 1：通过 2：未通过）'); INSERT INTO `sys_dict_data` VALUES (601, '000000', 1, '自制加工', '1', 'production_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (610, '000000', '生产单状态', 'production_status', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '生产单状态:（0：待审核 1：通过 2：未通过）'); INSERT INTO `sys_dict_data` VALUES (611, '000000', 1, '待审核', '1', 'production_status', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (612, '000000', 2, '通过', '2', 'production_status', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (613, '000000', 3, '未通过', '3', 'production_status', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (614, '000000', 4, '作废', '4', 'production_status', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (620, '000000', '客户类型', 'customer_type', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '生产单状态:（0：待审核 1：通过 2：未通过）'); INSERT INTO `sys_dict_data` VALUES (621, '000000', 1, '客户', '1', 'customer_type', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (622, '000000', 2, '供应商', '2', 'customer_type', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (630, '000000', '客户等级', 'customer_level', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '生产单状态:（0：待审核 1：通过 2：未通过）'); INSERT INTO `sys_dict_data` VALUES (631, '000000', 1, '一级', '1', 'customer_level', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (632, '000000', 2, '二级', '2', 'customer_level', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (633, '000000', 2, '三级', '3', 'customer_level', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (640, '000000', '客户销售绑定状态', 'customer_sale_bind_status', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '客户销售绑定状态:（ 1：绑定 2：已解绑）'); INSERT INTO `sys_dict_data` VALUES (641, '000000', 1, '绑定', '1', 'customer_sale_bind_status', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (642, '000000', 2, '已解绑', '2', 'customer_sale_bind_status', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (650, '000000', '订单状态', 'order_status', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '订单状态:（ 1：待审核 2：已审核 3:结清 4：退订中 5：已退订）'); INSERT INTO `sys_dict_data` VALUES (651, '000000', 1, '待审核', '1', 'order_status', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (652, '000000', 2, '已审核', '2', 'order_status', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (653, '000000', 3, '已结清', '3', 'order_status', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (654, '000000', 4, '退订中', '4', 'order_status', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (655, '000000', 5, '已退订', '5', 'order_status', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_type` VALUES (660, '000000', '订单明细状态', 'order_item_status', 100, 1, '2025-07-21 09:53:04', 1, '2025-07-21 09:53:04', '订单明细状态:（ 1：待审核 2：已审核 3:已发货 4：退订中 5：已退订）'); INSERT INTO `sys_dict_data` VALUES (661, '000000', 1, '待审核', '1', 'order_item_status', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (662, '000000', 2, '已审核', '2', 'order_item_status', NULL, 'success', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (663, '000000', 3, '已发货', '3', 'order_item_status', NULL, 'primary', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (664, '000000', 4, '退订中', '4', 'order_item_status', NULL, 'warning', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); INSERT INTO `sys_dict_data` VALUES (665, '000000', 5, '已退订', '5', 'order_item_status', NULL, 'info', 'Y', 100, 1, '2025-07-21 09:53:31', 1, '2025-07-21 09:53:31', NULL); -- ---------------------------- -- Records of sys_client -- ---------------------------- INSERT INTO `sys_client` VALUES (1, '9579f8780cf24ae2959d03d11482b18a', 'pc', 'iwb123', 'password,social', 'pc', 1800, 604800, '0', '0', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14'); INSERT INTO `sys_client` VALUES (2, '35aee70ae7224eb9a48bc527955ddedc', 'app', 'iwb123', 'password,sms,social', 'android', 1800, 604800, '0', '0', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14'); -- ---------------------------- -- Records of sys_org -- ---------------------------- INSERT INTO `sys_org` VALUES (100, '000000', 0, '0', '系统管理', NULL, 0, 1, '15888888888', 'vber@iwbnet.com', '0', '0', 100, 1, '2025-07-10 14:59:13', NULL, NULL); INSERT INTO `sys_org` VALUES (101, '000000', 100, '0,100', '弥勒养殖场', NULL, 0, 1, '15888888888', 'vber@iwbnet.com', '0', '0', 100, 1, '2025-07-10 14:59:13', NULL, NULL); INSERT INTO `sys_org` VALUES (201, '000000', 101, '0,100,101', '弥勒育种场', NULL, 0, NULL, NULL, NULL, '0', '0', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_org` VALUES (1000, '000000', 201, '0,100,101,201', '鸡舍管理员', '', 1, NULL, NULL, NULL, '0', '0', 100, 1, '2025-08-21 10:16:33', 1, '2025-08-21 10:16:33'); -- ---------------------------- -- Records of sys_oss -- ---------------------------- -- ---------------------------- -- Records of sys_oss_config -- ---------------------------- INSERT INTO `sys_oss_config` VALUES (1, '000000', 'local', '', '', '/preview/', '', '', '', 'N', '', '1', '0', '', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14', NULL); INSERT INTO `sys_oss_config` VALUES (2, '000000', 'qiniu', 'x', 'x', 'vber', '', 's3-cn-north-1.qiniucs.com', '', 'N', '', '1', '1', '', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14', NULL); INSERT INTO `sys_oss_config` VALUES (3, '000000', 'aliyun', 'x', 'x', 'vber', '', 'oss-cn-beijing.aliyuncs.com', '', 'N', '', '1', '1', '', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14', NULL); INSERT INTO `sys_oss_config` VALUES (4, '000000', 'qcloud', 'x', 'x', 'vber-1250000000', '', 'cos.ap-beijing.myqcloud.com', '', 'N', 'ap-beijing', '1', '1', '', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14', NULL); INSERT INTO `sys_oss_config` VALUES (5, '000000', 'minio', 'vber', 'vber123', 'vber', 'image', '127.0.0.1:9000', '', 'N', '', '1', '1', '', 100, 1, '2025-07-10 14:59:14', 1, '2025-07-10 14:59:14', NULL); -- ---------------------------- -- Records of sys_post -- ---------------------------- INSERT INTO `sys_post` VALUES (1, '000000', 100, 'default', NULL, '默认岗位', 1, '0', 100, 1, '2025-07-10 14:59:13', NULL, NULL, ''); -- ---------------------------- -- Records of sys_role -- ---------------------------- INSERT INTO `sys_role` VALUES (1, '000000', '超级管理员', 'super_admin', 1, '1', 1, 1, 1, '0', '0', 100, 1, '2025-07-10 14:59:13', NULL, NULL, '超级管理员'); INSERT INTO `sys_role` VALUES (2, '000000', '默认角色', 'default', 2, '3', 1, 1, 1, '0', '0', 100, 1, '2025-07-10 14:59:13', NULL, NULL, '默认角色'); INSERT INTO `sys_role` VALUES (1000, '000000', '鸡舍管理员', 'js_manager', 3, '5', 1, 1, 0, '0', '0', 100, 1, '2025-08-21 10:19:57', 1, '2025-08-21 15:16:04', NULL); INSERT INTO `sys_role` VALUES (1001, '000000', '育种厂厂长', 'yzc', 4, '1', 1, 1, 0, '0', '0', 100, 1, '2025-09-05 16:36:54', 1, '2025-09-05 16:37:00', NULL); -- ---------------------------- -- Records of sys_role_org -- ---------------------------- INSERT INTO `sys_role_org` VALUES (2, 100); INSERT INTO `sys_role_org` VALUES (2, 101); INSERT INTO `sys_role_org` VALUES (2, 102); -- ---------------------------- -- Records of sys_social -- ---------------------------- -- ---------------------------- -- Records of sys_tenant -- ---------------------------- INSERT INTO `sys_tenant` VALUES (1, '000000', '管理组', '15888888888', 'XXX有限公司', NULL, NULL, '多租户通用后台管理管理系统', NULL, NULL, NULL, NULL, -1, '0', '0', 100, 1, '2025-07-10 14:59:14', NULL, NULL); -- ---------------------------- -- Records of sys_tenant_package -- ---------------------------- -- ---------------------------- -- Records of sys_user -- ---------------------------- INSERT INTO `sys_user` VALUES (1, '000000', 100, 'admin', 'Admin', 'sys_user', 'admin@iwbnet.com', '13812340010', '1', NULL, '$2a$10$2M15Bggh98qOy7aWrGUc2OHL4yvvNij/NtbnLfkASmCN/Xwco3rq.',NULL,NULL,NULL,NULL, '0', '0', '172.27.0.1', '2025-09-22 13:00:07', 100, 1, '2025-07-10 14:59:13', -1, '2025-09-22 13:00:07', '超级管理员'); INSERT INTO `sys_user` VALUES (2, '000000', 100, 'system', 'System', 'sys_user', 'system@iwbnet.com', '13812340011', '1', NULL, '$2a$10$rCiWvcYYyEIb.PTM940FweoU.qKwErcJFmFyQdopQ1ZT37q6UcaOm',NULL,NULL,NULL,NULL, '0', '0', '127.0.0.1', '2025-07-10 14:59:13', 100, 1, '2025-07-10 14:59:13', NULL, NULL, '系统管理员'); INSERT INTO `sys_user` VALUES (3, '000000', 1000, 'demo01', 'Demo01', 'sys_user', 'demo01@iwbnet.com', '13812340021', '1', NULL, '$2a$10$T2u3eqjhLe04ZUTGCPcYrONPpLEt03eDbdJdCD5JW.2PQhT/LixcO',NULL,NULL,NULL,NULL, '0', '0', '0:0:0:0:0:0:0:1', '2025-08-21 15:42:24', 100, 1, '2025-07-10 14:59:13', -1, '2025-08-21 15:42:24', '系统管理员'); INSERT INTO `sys_user` VALUES (4, '000000', 1000, 'demo02', 'Demo02', 'sys_user', 'demo02@iwbnet.com', '13812340022', '1', NULL, '$2a$10$YpB6Bww0qTHZu31uDAlmg.MhDYTNKuOzN3KhaBEPM.PDVrJxHHuhW',NULL,NULL,NULL,NULL, '0', '0', '127.0.0.1', '2025-07-10 14:59:13', 100, 1, '2025-07-10 14:59:13', 1, '2025-08-21 10:22:17', '系统管理员'); INSERT INTO `sys_user` VALUES (1000, '000000', 100, 'yf', 'fy', 'sys_user', '123@123.com', '13900000000', '0', NULL, '$2a$10$ZCieMrSd4YmzX5iUPnam9O9FDGex2G/qpFcmFYTGY17KhBdLL67ui',NULL,NULL,NULL,NULL, '0', '0', '', NULL, 100, 1, '2025-09-05 16:35:58', 1, '2025-09-07 09:36:22', NULL); -- ---------------------------- -- Records of sys_user_post -- ---------------------------- INSERT INTO `sys_user_post` VALUES (1, 1); INSERT INTO `sys_user_post` VALUES (2, 1); -- ---------------------------- -- Records of sys_user_role -- ---------------------------- INSERT INTO `sys_user_role` VALUES (1, 1); INSERT INTO `sys_user_role` VALUES (2, 1); INSERT INTO `sys_user_role` VALUES (3, 1000); INSERT INTO `sys_user_role` VALUES (4, 1000); INSERT INTO `sys_user_role` VALUES (1000, 1001); -- ---------------------------- -- Records of xxl_job_group -- ---------------------------- INSERT INTO `xxl_job_group` VALUES (1, 'cf-job-executor', 'vber执行器', 0, 'http://172.27.0.5:6080/', '2025-09-22 13:28:56'); -- ---------------------------- -- Records of xxl_job_info -- ---------------------------- INSERT INTO `xxl_job_info` VALUES (1, 1, '演示任务01', '2025-08-20 11:03:11', '2025-08-20 11:03:11', 'XXL', '', 'CRON', '0 0 0 * * ? *', 'DO_NOTHING', 'FIRST', 'demoJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-08-20 11:03:11', '', 0, 0, 0); INSERT INTO `xxl_job_info` VALUES (2, 1, '日统计鸡舍批次信息', '2025-08-20 11:09:12', '2025-08-20 11:59:01', 'admin', '', 'CRON', '0 5 23 * * ?', 'DO_NOTHING', 'FIRST', 'staDayJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-08-20 11:09:12', '', 1, 1758467100000, 1758553500000); INSERT INTO `xxl_job_info` VALUES (3, 1, '月统计鸡舍批次信息', '2025-08-20 11:17:16', '2025-08-20 11:17:16', 'admin', '', 'CRON', '0 10 23 L * ?', 'DO_NOTHING', 'FIRST', 'staMonthJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-08-20 11:17:16', '', 0, 0, 0); INSERT INTO `xxl_job_info` VALUES (4, 1, '季度统计鸡舍批次信息', '2025-08-20 11:26:37', '2025-08-20 11:26:37', 'admin', '', 'CRON', '0 15 23 L 3,6,9,12 ?', 'DO_NOTHING', 'FIRST', 'staQuarterJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-08-20 11:26:37', '', 0, 0, 0); INSERT INTO `xxl_job_info` VALUES (5, 1, '年统计鸡舍批次信息', '2025-08-20 11:28:08', '2025-08-20 11:28:08', 'admin', '', 'CRON', '0 20 23 L 12 ? *', 'DO_NOTHING', 'FIRST', 'staYearJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-08-20 11:28:08', '', 0, 0, 0); -- ---------------------------- -- Records of xxl_job_registry -- ---------------------------- INSERT INTO `xxl_job_registry` VALUES (63, 'EXECUTOR', 'cf-job-executor', 'http://172.27.0.5:6080/', '2025-09-22 13:28:55'); -- ---------------------------- -- Records of xxl_job_user -- ---------------------------- INSERT INTO `xxl_job_user` VALUES (1, 'admin', '17c5381f3f2036518b1d464ca1237fe9', 1, NULL); INSERT INTO `xxl_job_user` VALUES (2, 'system', '6b7754cc771284da49d560729e73a9fd', 1, ''); -- 一期带来的业务初始数据 -------------------------------- INSERT INTO `f_chicken_coop` VALUES (11, '02-001', '测定3舍', 1440, 0, 1, '0', NULL, 100, '1', 1, '2025-09-06 11:25:17', 1, '2025-09-07 08:37:41', NULL); INSERT INTO `f_chicken_coop` VALUES (12, '02-002', ' 测定4舍', 1440, 0, 1, '0', NULL, 100, '1', 1, '2025-09-06 11:25:43', 1, '2025-09-07 08:38:03', NULL); INSERT INTO `f_chicken_coop` VALUES (13, '03-001', '测定1舍', 1920, 0, 1, '0', NULL, 100, '1', 1, '2025-09-06 11:26:00', 1, '2025-09-07 08:38:55', NULL); INSERT INTO `f_chicken_coop` VALUES (14, '2-003', '育成3舍', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:31:39', 1, '2025-09-07 08:52:56', NULL); INSERT INTO `f_chicken_coop` VALUES (15, '2-004', '育成4舍', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:32:00', 1, '2025-09-07 08:52:59', NULL); INSERT INTO `f_chicken_coop` VALUES (16, '2-005', '育成5舍', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:32:16', 1, '2025-09-07 08:53:02', NULL); INSERT INTO `f_chicken_coop` VALUES (17, '2-006', '育成6舍', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:32:31', 1, '2025-09-07 08:53:05', NULL); INSERT INTO `f_chicken_coop` VALUES (18, '2-006', '育成7舍', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:32:39', 1, '2025-09-07 08:33:38', NULL); INSERT INTO `f_chicken_coop` VALUES (19, '2-007', '育成7舍', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:33:58', 1, '2025-09-07 08:53:07', NULL); INSERT INTO `f_chicken_coop` VALUES (20, '2-008', '育成8', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:34:19', 1, '2025-09-07 08:53:09', NULL); INSERT INTO `f_chicken_coop` VALUES (21, '2-009', '育成9', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:34:28', 1, '2025-09-07 08:53:11', NULL); INSERT INTO `f_chicken_coop` VALUES (22, '2-010', '育成10', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:34:45', 1, '2025-09-07 08:53:13', NULL); INSERT INTO `f_chicken_coop` VALUES (23, '2-011', '育成11', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:35:10', 1, '2025-09-07 08:53:15', NULL); INSERT INTO `f_chicken_coop` VALUES (24, '2-012', '育成12', 810, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:35:18', 1, '2025-09-07 08:53:17', NULL); INSERT INTO `f_chicken_coop` VALUES (25, '03-002', '测定2舍', 1920, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:38:37', 1, '2025-09-07 08:39:30', NULL); INSERT INTO `f_chicken_coop` VALUES (26, '03-001', '测定1舍', 1920, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:39:12', 1, '2025-09-07 08:53:19', NULL); INSERT INTO `f_chicken_coop` VALUES (27, '03-002', '测定2舍', 1920, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:39:44', 1, '2025-09-07 08:53:21', NULL); INSERT INTO `f_chicken_coop` VALUES (28, '03-003', '测定3舍', 1440, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:39:58', 1, '2025-09-07 08:53:23', NULL); INSERT INTO `f_chicken_coop` VALUES (29, '03-004', '测定4舍', 1440, 0, 1, '0', NULL, 100, '1', 1, '2025-09-07 08:40:10', 1, '2025-09-07 08:53:25', NULL); INSERT INTO `f_chicken_coop` VALUES (30, '02-003', '育成3舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:02:00', 1, '2025-09-07 09:02:00', NULL); INSERT INTO `f_chicken_coop` VALUES (31, '02-004', '育成4舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:02:44', 1, '2025-09-07 09:02:44', NULL); INSERT INTO `f_chicken_coop` VALUES (32, '02-005', '育成5舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:01', 1, '2025-09-07 09:08:01', NULL); INSERT INTO `f_chicken_coop` VALUES (33, '02-006', '育成6舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:12', 1, '2025-09-07 09:08:12', NULL); INSERT INTO `f_chicken_coop` VALUES (34, '02-007', '育成7舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:21', 1, '2025-09-07 09:08:21', NULL); INSERT INTO `f_chicken_coop` VALUES (35, '02-008', '育成8舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:31', 1, '2025-09-07 09:08:31', NULL); INSERT INTO `f_chicken_coop` VALUES (36, '02-009', '育成9舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:39', 1, '2025-09-07 09:08:39', NULL); INSERT INTO `f_chicken_coop` VALUES (37, '02-010', '育成10舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:50', 1, '2025-09-07 09:08:50', NULL); INSERT INTO `f_chicken_coop` VALUES (38, '02-011', '育成11舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:08:56', 1, '2025-09-07 09:09:08', NULL); INSERT INTO `f_chicken_coop` VALUES (39, '02-012', '育成12舍', 810, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:09:18', 1, '2025-09-07 09:09:18', NULL); INSERT INTO `f_chicken_coop` VALUES (40, '03-001', '测定1舍', 1920, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:10:11', 1, '2025-09-07 09:10:11', NULL); INSERT INTO `f_chicken_coop` VALUES (41, '03-002', '测定2舍', 1920, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:12:08', 1, '2025-09-07 09:12:08', NULL); INSERT INTO `f_chicken_coop` VALUES (42, '03-003', '测定3舍', 1440, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:12:24', 1, '2025-09-07 09:12:24', NULL); INSERT INTO `f_chicken_coop` VALUES (43, '03-004', '测定4舍', 1440, 0, 1, '0', NULL, 100, '0', 1, '2025-09-07 09:12:44', 1, '2025-09-07 09:12:44', NULL); INSERT INTO `f_chicken_cage` VALUES (24, '02-001-1-810', 11, NULL, 0, 8, 100, 1, '2025-09-06 11:26:37', 1, '2025-09-07 08:37:22', NULL, '1'); INSERT INTO `f_chicken_cage` VALUES (25, '02-002-1-810', 12, NULL, 0, 8, 100, 1, '2025-09-06 11:26:47', 1, '2025-09-07 08:37:57', NULL, '1'); INSERT INTO `f_chicken_cage` VALUES (26, '2-003-810', 14, NULL, 0, 8, 100, 1, '2025-09-07 08:42:29', 1, '2025-09-07 08:51:55', NULL, '1'); INSERT INTO `f_chicken_cage` VALUES (27, '2-004-2-004-810', 15, NULL, 0, 810, 100, 1, '2025-09-07 08:50:53', 1, '2025-09-07 08:51:02', NULL, '1'); INSERT INTO `f_chicken_cage` VALUES (28, '02-003-810', 30, NULL, 0, 8, 100, 1, '2025-09-07 09:03:26', 1, '2025-09-07 09:04:05', NULL, '1'); INSERT INTO `f_chicken_cage` VALUES (29, '02-003-1-810', 30, NULL, 0, 8, 100, 1, '2025-09-07 15:10:24', 1, '2025-09-07 15:10:24', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (30, '02-004-1-810', 31, NULL, 0, 8, 100, 1, '2025-09-07 15:10:48', 1, '2025-09-07 15:10:48', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (31, '02-005-1-810', 32, NULL, 0, 8, 100, 1, '2025-09-07 15:11:00', 1, '2025-09-07 15:11:00', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (32, '02-006-1-810', 33, NULL, 0, 8, 100, 1, '2025-09-07 15:11:23', 1, '2025-09-07 15:11:23', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (33, '02-007-1-810', 34, NULL, 0, 8, 100, 1, '2025-09-07 15:11:30', 1, '2025-09-07 15:11:30', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (34, '02-008-1-810', 35, NULL, 0, 8, 100, 1, '2025-09-07 15:11:42', 1, '2025-09-07 15:11:42', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (35, '02-009-1-810', 36, NULL, 0, 8, 100, 1, '2025-09-07 15:11:51', 1, '2025-09-07 15:11:51', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (36, '02-010-1-810', 37, NULL, 0, 8, 100, 1, '2025-09-07 15:11:57', 1, '2025-09-07 15:11:57', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (37, '02-011-1-810', 38, NULL, 0, 8, 100, 1, '2025-09-07 15:12:04', 1, '2025-09-07 15:12:04', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (38, '02-012-1-810', 39, NULL, 0, 8, 100, 1, '2025-09-07 15:12:09', 1, '2025-09-07 15:12:09', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (39, '03-001-1-1920', 40, NULL, 0, 1, 100, 1, '2025-09-07 15:12:31', 1, '2025-09-07 15:12:31', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (40, '03-002-1-1920', 41, NULL, 0, 1, 100, 1, '2025-09-07 15:12:45', 1, '2025-09-07 15:12:45', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (41, '03-003-1-1440', 42, NULL, 0, 1, 100, 1, '2025-09-07 15:12:59', 1, '2025-09-07 15:12:59', NULL, '0'); INSERT INTO `f_chicken_cage` VALUES (42, '03-004-1-1440', 43, NULL, 0, 1, 100, 1, '2025-09-07 15:13:06', 1, '2025-09-07 15:13:06', NULL, '0'); INSERT INTO `f_feed` VALUES (12, '育雏前期料', NULL, 0, 100, 1, '2025-09-17 11:30:03', 1, '2025-09-17 11:30:03', NULL, '0'); INSERT INTO `f_feed` VALUES (13, '育雏后期料', NULL, 0, 100, 1, '2025-09-17 11:30:28', 1, '2025-09-17 11:30:28', NULL, '0'); INSERT INTO `f_feed` VALUES (14, '育成料', NULL, 0, 100, 1, '2025-09-17 11:30:36', 1, '2025-09-17 11:30:36', NULL, '0'); INSERT INTO `f_feed` VALUES (15, '低能肉鸡料（三段料）', NULL, 0, 100, 1, '2025-09-17 11:31:11', 1, '2025-09-17 11:31:11', NULL, '0'); INSERT INTO `f_feed` VALUES (16, '预产料', NULL, 0, 100, 1, '2025-09-17 11:31:27', 1, '2025-09-17 11:31:27', NULL, '0'); INSERT INTO `f_feed` VALUES (17, '产蛋前期料', NULL, 0, 100, 1, '2025-09-17 11:31:40', 1, '2025-09-17 11:31:40', NULL, '0'); INSERT INTO `f_feed` VALUES (18, '产蛋中期料', NULL, 0, 100, 1, '2025-09-17 11:31:52', 1, '2025-09-17 11:31:52', NULL, '0'); INSERT INTO `f_feed` VALUES (19, '产蛋后期料', NULL, 0, 100, 1, '2025-09-17 11:31:59', 1, '2025-09-17 11:31:59', NULL, '0'); INSERT INTO `f_feed` VALUES (20, '种公鸡料', NULL, 0, 100, 1, '2025-09-17 11:32:10', 1, '2025-09-17 11:32:10', NULL, '0'); INSERT INTO `f_vaccine` VALUES (10, '威支灵', 1, '勃林格', '2025-04-29', '2026-04-28', 0, NULL, 100, 1, '2025-09-17 10:29:20', 1, '2025-09-17 10:29:20', '0'); INSERT INTO `f_vaccine` VALUES (11, 'IB4-91', 1, '勃林格', '2024-10-01', '2026-09-01', 0, NULL, 100, 1, '2025-09-17 10:30:59', 1, '2025-09-17 10:30:59', '0'); INSERT INTO `f_vaccine` VALUES (12, 'IB4-91', 1, '勃林格', '2024-10-01', '2026-09-01', 0, NULL, 100, 1, '2025-09-17 10:35:06', 1, '2025-09-17 10:35:06', '0'); INSERT INTO `f_vaccine` VALUES (13, 'REO1133', 1, '默沙东', '2024-05-01', '2026-04-01', 0, NULL, 100, 1, '2025-09-17 10:37:17', 1, '2025-09-17 10:37:17', '0'); INSERT INTO `f_vaccine` VALUES (14, 'ND+IB二联油', 1, '默沙东', '2024-10-01', '2026-09-01', 0, NULL, 100, 1, '2025-09-17 11:02:43', 1, '2025-09-17 11:02:43', '0'); INSERT INTO `f_vaccine` VALUES (15, 'ND+IB二联油', 0, '默沙东', '2024-10-01', '2026-09-01', 0, NULL, 100, 1, '2025-09-17 11:04:54', 1, '2025-09-17 11:04:54', '0'); INSERT INTO `f_vaccine` VALUES (16, '喉痘', 1, '法国诗华', '2024-02-28', '2026-02-28', 0, NULL, 100, 1, '2025-09-17 11:09:31', 1, '2025-09-17 11:09:31', '0'); INSERT INTO `f_vaccine` VALUES (17, '沙门氏活苗SE', 1, '美国礼蓝', '2024-09-01', '2026-08-01', 0, NULL, 100, 1, '2025-09-17 11:12:18', 1, '2025-09-17 11:12:18', '0'); INSERT INTO `f_vaccine` VALUES (18, 'ND+IB+H9三联油苗', 0, '青岛易邦', '2025-06-17', '2026-06-16', 0, NULL, 100, 1, '2025-09-17 11:13:49', 1, '2025-09-17 11:13:49', '0'); INSERT INTO `f_vaccine` VALUES (19, 'Ma5clone30', 1, '默沙东', '2024-09-01', '2026-09-01', 0, NULL, 100, 1, '2025-09-17 11:15:31', 1, '2025-09-17 11:15:31', '0'); INSERT INTO `f_vaccine` VALUES (20, '青岛H5+H7', 0, '青岛易邦', '2025-04-20', '2026-04-19', 0, NULL, 100, 1, '2025-09-17 11:16:33', 1, '2025-09-17 11:16:33', '0'); INSERT INTO `f_vaccine` VALUES (21, 'MG活苗（6/85株）', 1, '默沙东', '2024-01-01', '2026-03-01', 0, NULL, 100, 1, '2025-09-17 11:17:45', 1, '2025-09-17 11:17:45', '0'); INSERT INTO `f_vaccine` VALUES (22, 'IC铝胶苗', 0, '日本北里', '2025-02-01', '2027-02-06', 0, NULL, 100, 1, '2025-09-17 11:18:37', 1, '2025-09-17 11:18:37', '0'); INSERT INTO `f_vaccine` VALUES (23, 'ND+H9+FADV三联油苗', 0, '瑞普', '2025-01-02', '2026-07-04', 0, NULL, 100, 1, '2025-09-17 11:19:34', 1, '2025-09-17 11:19:34', '0'); INSERT INTO `f_vaccine` VALUES (24, 'H5+H7二联油苗', 0, '华南生物', '2025-04-02', '2026-04-01', 0, NULL, 100, 1, '2025-09-17 11:20:25', 1, '2025-09-17 11:20:25', '0'); INSERT INTO `f_vaccine` VALUES (25, 'CAV', 1, '默沙东', '2024-04-01', '2026-03-01', 0, NULL, 100, 1, '2025-09-17 11:21:17', 1, '2025-09-17 11:21:17', '0'); INSERT INTO `f_vaccine` VALUES (26, 'REO油苗', 0, '美国礼蓝', '2024-09-01', '2026-02-01', 0, NULL, 100, 1, '2025-09-17 11:22:07', 1, '2025-09-17 11:22:07', '0'); INSERT INTO `f_vaccine` VALUES (27, 'ILT（爱乐啼）', 0, '默沙东', '2024-01-09', '2027-01-08', 0, NULL, 100, 1, '2025-09-17 11:22:52', 1, '2025-09-17 11:22:52', '0'); INSERT INTO `f_vaccine` VALUES (28, 'AE+POX', 1, '默沙东', '2024-02-01', '2027-01-01', 0, NULL, 100, 1, '2025-09-17 11:23:46', 1, '2025-09-17 11:23:46', '0'); INSERT INTO `f_vaccine` VALUES (29, 'ILT（爱乐啼）', 1, '默沙东', '2024-01-09', '2027-01-08', 0, NULL, 100, 1, '2025-09-17 11:24:29', 1, '2025-09-17 11:24:29', '0'); INSERT INTO `f_vaccine` VALUES (30, 'ND+IB+H9+EDS', 0, '瑞普', '2024-04-01', '2027-04-07', 0, NULL, 100, 1, '2025-09-17 11:25:48', 1, '2025-09-17 11:25:48', '0'); INSERT INTO `f_vaccine` VALUES (31, 'MG油苗', 0, '瑞普', '2025-01-03', '2026-01-06', 0, NULL, 100, 1, '2025-09-17 11:26:37', 1, '2025-09-17 11:26:37', '0'); INSERT INTO `f_vaccine` VALUES (32, 'ND+IB+IBD+REO', 0, '默沙东', '2024-12-01', '2026-05-01', 0, NULL, 100, 1, '2025-09-17 11:27:28', 1, '2025-09-17 11:27:28', '0'); INSERT INTO `f_vaccine` VALUES (33, '沙门氏菌灭活疫苗', 0, '默沙东', '2025-05-01', '2027-11-01', 0, NULL, 100, 1, '2025-09-17 11:28:53', 1, '2025-09-17 11:28:53', '0'); INSERT INTO `f_drug` VALUES (9, '林可大观霉素', '北京康牧生物科技有限公司', '2024-11-07', '2026-11-06', 0, NULL, 100, 1, '2025-09-17 09:25:25', 1, '2025-09-17 09:25:25', '0'); INSERT INTO `f_drug` VALUES (10, '萜木真', '南京惠环生物科技有限公司', '2024-10-31', '2026-04-30', 0, NULL, 100, 1, '2025-09-17 09:27:01', 1, '2025-09-17 09:27:01', '0'); INSERT INTO `f_drug` VALUES (11, '枝原净', '礼蓝（上海）动物保健有限公司', '2025-01-01', '2027-12-01', 0, NULL, 100, 1, '2025-09-17 09:29:12', 1, '2025-09-17 09:29:12', '0'); INSERT INTO `f_drug` VALUES (12, '佳益多', '荷兰鹰凯动物保健集团', '2024-11-19', '2026-11-19', 0, NULL, 100, 1, '2025-09-17 09:30:30', 1, '2025-09-17 09:30:30', '0'); INSERT INTO `f_drug` VALUES (13, '维金100', '瑞普高科（天津）生物科技有限公司', '2025-03-14', '2027-03-13', 0, NULL, 100, 1, '2025-09-17 09:31:37', 1, '2025-09-17 09:31:37', '0'); INSERT INTO `f_drug` VALUES (14, '塞可新（有机酸）', '多卫捷（河北）生物科技有限公司', '2025-03-17', '2027-03-16', 0, NULL, 100, 1, '2025-09-17 09:32:40', 1, '2025-09-17 09:32:40', '0'); INSERT INTO `f_drug` VALUES (15, '磺胺氯吡嗪钠可溶性粉（安球生）', '南京惠牧生物科技有限公司', '2025-01-02', '2027-01-01', 0, NULL, 100, 1, '2025-09-17 09:33:38', 1, '2025-09-17 09:33:38', '0'); INSERT INTO `f_drug` VALUES (16, '肠治先锋', '南京生物科技有限公司', '2025-05-08', '2027-11-07', 0, NULL, 100, 1, '2025-09-17 09:35:06', 1, '2025-09-17 09:35:06', '0'); INSERT INTO `f_drug` VALUES (17, '百呼清', '南京生物科技有限公司', '2025-01-13', '2027-07-13', 0, NULL, 100, 1, '2025-09-17 09:36:13', 1, '2025-09-17 09:36:13', '0'); INSERT INTO `f_drug` VALUES (18, '山字', '礼蓝（上海）动物保健有限公司', '2024-07-01', '2026-06-30', 0, NULL, 100, 1, '2025-09-17 09:37:07', 1, '2025-09-17 09:37:07', '0'); INSERT INTO `f_drug` VALUES (19, '速服宁', '法国FC有限公司', '2024-07-01', '2026-06-30', 0, NULL, 100, 1, '2025-09-17 09:37:39', 1, '2025-09-17 09:37:39', '0'); INSERT INTO `f_drug` VALUES (20, '阿莫西林', '四川德成动物保健品有限公司', '2024-10-08', '2026-10-07', 0, NULL, 100, 1, '2025-09-17 09:38:28', 1, '2025-09-17 09:38:28', '0'); INSERT INTO `f_drug` VALUES (21, '沃尼妙林', '瑞普（天津）生物药业有限公司', '2025-03-04', '2027-03-03', 0, NULL, 100, 1, '2025-09-17 09:51:54', 1, '2025-09-17 09:51:54', '0'); INSERT INTO `f_drug` VALUES (22, '可安松', '荷兰鹰凯动物保健集团', '2024-11-19', '2026-11-19', 0, NULL, 100, 1, '2025-09-17 09:53:10', 1, '2025-09-17 09:53:10', '0'); INSERT INTO `f_drug` VALUES (23, '球易安', '南京惠环生物科技有限公司', '2025-08-15', '2027-08-15', 0, NULL, 100, 1, '2025-09-17 09:54:04', 1, '2025-09-17 09:54:04', '0'); INSERT INTO `f_drug` VALUES (24, '头孢喹肟', '瑞普生物', '2025-02-26', '2027-02-26', 0, NULL, 100, 1, '2025-09-17 09:55:07', 1, '2025-09-17 09:55:07', '0'); INSERT INTO `f_drug` VALUES (25, '利高', '硕螣动保', '2024-07-01', '2026-06-01', 0, NULL, 100, 1, '2025-09-17 09:56:15', 1, '2025-09-17 09:56:15', '0'); INSERT INTO `f_drug` VALUES (26, '亚易林', '瑞普生物', '2025-04-08', '2025-10-07', 0, NULL, 100, 1, '2025-09-17 09:56:58', 1, '2025-09-17 09:56:58', '0'); INSERT INTO `f_drug` VALUES (27, '乐培', '荷兰鹰凯动物保健集团', '2024-10-31', '2026-10-31', 1, NULL, 100, 1, '2025-09-17 09:58:06', 1, '2025-09-17 09:58:06', '0'); INSERT INTO `f_variety` VALUES (1, '白羽鸡', 'M', 6, '父系', 0, 100, 1, '2025-07-17 13:28:06', 1, '2025-09-06 10:20:30', NULL, '0'); INSERT INTO `f_variety` VALUES (2, '白羽鸡', 'N', 9, '母系', 0, 100, 1, '2025-07-17 13:28:19', 1, '2025-09-06 10:20:39', NULL, '0'); INSERT INTO `f_variety` VALUES (4, '白羽鸡', 'C', 4, '母系', 0, 100, 1, '2025-08-11 16:39:20', 1, '2025-09-06 10:20:51', NULL, '0'); INSERT INTO `f_variety` VALUES (6, '白羽鸡', 'D', 3, '母系', 0, 100, 1, '2025-08-21 12:56:01', 1, '2025-09-06 10:21:01', NULL, '0'); INSERT INTO `f_variety` VALUES (9, '白羽鸡', 'A', 2, '父系', 0, 100, 1, '2025-08-21 13:06:39', 1, '2025-09-06 10:21:15', NULL, '0'); SET FOREIGN_KEY_CHECKS = 1;