DROP DATABASE IF EXISTS `beef`;
CREATE DATABASE `beef`;
use `beef`;
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`username` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '账号',
`password` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '密码',
`name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '名称',
`avatar` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '头像',
`role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'admin' COMMENT '角色标识',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='管理员表';
INSERT INTO `admin` (username, password, name, avatar, role) VALUES ('admin', '123456', '管理员', 'http://localhost:9090/files/qy-default.png', 'admin');
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`username` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '账号',
`password` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '密码',
`name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '名称',
`avatar` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '头像',
`phone` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '手机',
`email` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '邮箱',
`role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'user' COMMENT '角色标识',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='员工表';
DROP TABLE IF EXISTS `business`;
CREATE TABLE `business` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`username` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '账号',
`password` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '密码',
`name` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '名称',
`avatar` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '头像',
`phone` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '手机',
`email` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '邮箱',
`role` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT 'business' COMMENT '角色标识',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='商家表';
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`number` int(10) DEFAULT 0 COMMENT '肉牛编号',
`rntz` int(10) DEFAULT 0 COMMENT '肉牛体重（kg）',
`sex` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '性别',
`type` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '肉牛类别',
`ly` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '肉牛来源',
`img` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '肉牛图片',
`date` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '引入日期',
`user_id` int(10) DEFAULT NULL COMMENT '员工ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='肉牛信息表';
DROP TABLE IF EXISTS `beefcare`;
CREATE TABLE `beefcare` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`mqym` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '样貌信息',
`yzch` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '养殖场号',
`weight` int(10) DEFAULT 0 COMMENT '体重(kg)',
`scqk` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '审查情况',
`date1` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '审查日期',
`ymjz` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '接种情况',
`date2` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '接种日期',
`baby` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '繁育情况',
`mess` text COMMENT '备注信息',
`message_id` int(10) DEFAULT NULL COMMENT '肉牛信息ID',
`user_id` int(10) DEFAULT NULL COMMENT '员工ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='肉牛管理表';
DROP TABLE IF EXISTS `fit`;
CREATE TABLE `fit` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`sfys` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '是否一审',
`yssj` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '一审时间',
`sfes` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '是否二审',
`essj` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '二审时间',
`sfss` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '是否三审',
`sssj` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '三审时间',
`mqjg` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '目前结果',
`message_id` int(10) DEFAULT NULL COMMENT '肉牛信息ID',
`user_id` int(10) DEFAULT NULL COMMENT '员工ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='健康审查情况表';
DROP TABLE IF EXISTS `safety`;
CREATE TABLE `safety` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`ycjz` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '一次接种',
`ycsj` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '一次时间',
`ecjz` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '二次接种',
`ecsj` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '二次时间',
`scjz` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '三次接种',
`scsj` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '三次时间',
`mqqk` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '目前情况',
`message_id` int(10) DEFAULT NULL COMMENT '肉牛信息ID',
`user_id` int(10) DEFAULT NULL COMMENT '员工ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='疫苗接种情况表';
DROP TABLE IF EXISTS `foodstore`;
CREATE TABLE `foodstore` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`slbh` int(10) DEFAULT 0 COMMENT '饲料编号',
`slmc` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '饲料名称',
`slly` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '饲料来源',
`cgrq` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '采购日期',
`cgsl` int(10) DEFAULT 0 COMMENT '采购数量',
`rksj` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '入库时间',
`kcsl` int(10) DEFAULT 0 COMMENT '库存数量',
`user_id` int(10) DEFAULT NULL COMMENT '员工ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='饲料库存表';
DROP TABLE IF EXISTS `foods`;
CREATE TABLE `foods` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`sllx` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '饲料类型',
`foodstore_id` int(10) DEFAULT NULL COMMENT '饲料库存ID',
`message_id` int(10) DEFAULT NULL COMMENT '肉牛信息ID',
`user_id` int(10) DEFAULT NULL COMMENT '员工ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='饲养管理表';
DROP TABLE IF EXISTS `environment`;
CREATE TABLE `environment` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`xljc` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '心率检查',
`tw` int(10) DEFAULT 0 COMMENT '体温(摄氏度)',
`hjwd` int(10) DEFAULT 0 COMMENT '环境温度(摄氏度)',
`hjsd` int(10) DEFAULT 0 COMMENT '环境湿度',
`kqzl` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '空气质量',
`message_id` int(10) DEFAULT NULL COMMENT '肉牛信息ID',
`beefcare_id` int(10) DEFAULT NULL COMMENT '肉牛管理ID',
`user_id` int(10) DEFAULT NULL COMMENT '员工ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='肉牛生长环境表';
DROP TABLE IF EXISTS `sale`;
CREATE TABLE `sale` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`rnjg` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '价格(元/kg)',
`scqk` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '售出情况',
`bz` text COMMENT '备注',
`message_id` int(10) DEFAULT NULL COMMENT '肉牛信息ID',
`beefcare_id` int(10) DEFAULT NULL COMMENT '肉牛管理ID',
`user_id` int(10) DEFAULT NULL COMMENT '员工ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='肉牛销售信息表';
DROP TABLE IF EXISTS `shop`;
CREATE TABLE `shop` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`shjj` text COMMENT '商户简介',
`date` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '加入日期',
`business_id` int(10) DEFAULT NULL COMMENT '商家ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='商户信息表';
DROP TABLE IF EXISTS `buybeef`;
CREATE TABLE `buybeef` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`czsj` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '操作时间',
`yysj` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '预约商家',
`yygm` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '预约购买',
`message_id` int(10) DEFAULT NULL COMMENT '肉牛信息ID',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='预约购买表';
DROP TABLE IF EXISTS `ggxx`;
CREATE TABLE `ggxx` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`fbr` varchar(255) COLLATE utf8mb4_unicode_ci COMMENT '公告发布人',
`ggnr` text COMMENT '公告内容',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='公告信息表';