开发语言：Python 框架：django Python版本：python3.7.7 数据库：mysql 5.7（一定要5.7版本） 数据库工具：Navicat11 开发软件：PyCharm 浏览器：谷歌浏览器
数据库设计：
DROP TABLE IF EXISTS chongwubaike;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE chongwubaike (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
chongwumingcheng varchar(200) DEFAULT NULL COMMENT '宠物名称',
chongwupinzhong varchar(200) DEFAULT NULL COMMENT '宠物品种',
chongwutezheng varchar(200) DEFAULT NULL COMMENT '宠物特征',
yinshixiguan varchar(200) DEFAULT NULL COMMENT '饮食习惯',
shiheyimiao varchar(200) DEFAULT NULL COMMENT '适合疫苗',
siyangfangfa longtext COMMENT '饲养方法',
chongwutupian longtext COMMENT '宠物图片',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1681374731921 DEFAULT CHARSET=utf8 COMMENT='宠物百科';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table chongwubaike
--
LOCK TABLES chongwubaike WRITE;
/*!40000 ALTER TABLE chongwubaike DISABLE KEYS /;
INSERT INTO chongwubaike VALUES (21,'2023-04-13 08:24:43','宠物名称1','宠物品种1','宠物特征1','饮食习惯1','适合疫苗1','饲养方法1','upload/chongwubaike_chongwutupian1.jpg,upload/chongwubaike_chongwutupian2.jpg,upload/chongwubaike_chongwutupian3.jpg'),(22,'2023-04-13 08:24:43','宠物名称2','宠物品种2','宠物特征2','饮食习惯2','适合疫苗2','饲养方法2','upload/chongwubaike_chongwutupian2.jpg,upload/chongwubaike_chongwutupian3.jpg,upload/chongwubaike_chongwutupian4.jpg'),(23,'2023-04-13 08:24:43','宠物名称3','宠物品种3','宠物特征3','饮食习惯3','适合疫苗3','饲养方法3','upload/chongwubaike_chongwutupian3.jpg,upload/chongwubaike_chongwutupian4.jpg,upload/chongwubaike_chongwutupian5.jpg'),(24,'2023-04-13 08:24:43','宠物名称4','宠物品种4','宠物特征4','饮食习惯4','适合疫苗4','饲养方法4','upload/chongwubaike_chongwutupian4.jpg,upload/chongwubaike_chongwutupian5.jpg,upload/chongwubaike_chongwutupian6.jpg'),(25,'2023-04-13 08:24:43','宠物名称5','宠物品种5','宠物特征5','饮食习惯5','适合疫苗5','饲养方法5','upload/chongwubaike_chongwutupian5.jpg,upload/chongwubaike_chongwutupian6.jpg,upload/chongwubaike_chongwutupian7.jpg'),(26,'2023-04-13 08:24:43','宠物名称6','宠物品种6','宠物特征6','饮食习惯6','适合疫苗6','饲养方法6','upload/chongwubaike_chongwutupian6.jpg,upload/chongwubaike_chongwutupian7.jpg,upload/chongwubaike_chongwutupian8.jpg'),(27,'2023-04-13 08:24:43','宠物名称7','宠物品种7','宠物特征7','饮食习惯7','适合疫苗7','饲养方法7','upload/chongwubaike_chongwutupian7.jpg,upload/chongwubaike_chongwutupian8.jpg,upload/chongwubaike_chongwutupian9.jpg'),(28,'2023-04-13 08:24:43','宠物名称8','宠物品种8','宠物特征8','饮食习惯8','适合疫苗8','饲养方法8','upload/chongwubaike_chongwutupian8.jpg,upload/chongwubaike_chongwutupian9.jpg,upload/chongwubaike_chongwutupian10.jpg'),(1681374731920,'2023-04-13 08:32:11','XXX','宠物品种3','XXX','XXX','XXX','
XXXXXXXXXXXXXXXX
','upload/1681374729079.jpg');
/!40000 ALTER TABLE chongwubaike ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table chongwupinzhong
--
DROP TABLE IF EXISTS chongwupinzhong;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE chongwupinzhong (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
chongwupinzhong varchar(200) DEFAULT NULL COMMENT '宠物品种',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1681374750774 DEFAULT CHARSET=utf8 COMMENT='宠物品种';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table chongwupinzhong
--
LOCK TABLES chongwupinzhong WRITE;
/*!40000 ALTER TABLE chongwupinzhong DISABLE KEYS /;
INSERT INTO chongwupinzhong VALUES (31,'2023-04-13 08:24:43','宠物品种1'),(32,'2023-04-13 08:24:43','宠物品种2'),(33,'2023-04-13 08:24:43','宠物品种3'),(34,'2023-04-13 08:24:43','宠物品种4'),(35,'2023-04-13 08:24:43','宠物品种5'),(36,'2023-04-13 08:24:43','宠物品种6'),(37,'2023-04-13 08:24:43','宠物品种7'),(38,'2023-04-13 08:24:43','宠物品种8'),(1681374750773,'2023-04-13 08:32:30','XX品种');
/!40000 ALTER TABLE chongwupinzhong ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table chongwushenling
--
DROP TABLE IF EXISTS chongwushenling;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE chongwushenling (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
chongwumingcheng varchar(200) DEFAULT NULL COMMENT '宠物名称',
chongwupinzhong varchar(200) DEFAULT NULL COMMENT '宠物品种',
chongwulaiyuan varchar(200) DEFAULT NULL COMMENT '宠物来源',
shenqingshijian datetime DEFAULT NULL COMMENT '申请时间',
shenqingshuoming varchar(200) DEFAULT NULL COMMENT '申请说明',
zhanghao varchar(200) DEFAULT NULL COMMENT '账号',
xingming varchar(200) DEFAULT NULL COMMENT '姓名',
sfsh varchar(200) DEFAULT '待审核' COMMENT '是否审核',
shhf longtext COMMENT '审核回复',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1681374632044 DEFAULT CHARSET=utf8 COMMENT='宠物申领';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table chongwushenling
--
LOCK TABLES chongwushenling WRITE;
/*!40000 ALTER TABLE chongwushenling DISABLE KEYS /;
INSERT INTO chongwushenling VALUES (51,'2023-04-13 08:24:43','宠物名称1','宠物品种1','宠物来源1','2023-04-13 16:24:43','申请说明1','账号1','姓名1','是',''),(52,'2023-04-13 08:24:43','宠物名称2','宠物品种2','宠物来源2','2023-04-13 16:24:43','申请说明2','账号2','姓名2','是',''),(53,'2023-04-13 08:24:43','宠物名称3','宠物品种3','宠物来源3','2023-04-13 16:24:43','申请说明3','账号3','姓名3','是',''),(54,'2023-04-13 08:24:43','宠物名称4','宠物品种4','宠物来源4','2023-04-13 16:24:43','申请说明4','账号4','姓名4','是',''),(55,'2023-04-13 08:24:43','宠物名称5','宠物品种5','宠物来源5','2023-04-13 16:24:43','申请说明5','账号5','姓名5','是',''),(56,'2023-04-13 08:24:43','宠物名称6','宠物品种6','宠物来源6','2023-04-13 16:24:43','申请说明6','账号6','姓名6','是',''),(57,'2023-04-13 08:24:43','宠物名称7','宠物品种7','宠物来源7','2023-04-13 16:24:43','申请说明7','账号7','姓名7','是',''),(58,'2023-04-13 08:24:43','宠物名称8','宠物品种8','宠物来源8','2023-04-13 16:24:43','申请说明8','账号8','姓名8','是',''),(1681374632043,'2023-04-13 08:30:32','宠物名称1','宠物品种1','家养','2023-04-13 16:30:31','XXXX','111','张三','是','111');
/!40000 ALTER TABLE chongwushenling ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table chongwushiwu
--
DROP TABLE IF EXISTS chongwushiwu;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE chongwushiwu (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
shiwumingcheng varchar(200) DEFAULT NULL COMMENT '食物名称',
shiwuleixing varchar(200) DEFAULT NULL COMMENT '食物类型',
pinpai varchar(200) DEFAULT NULL COMMENT '品牌',
shengchanshang varchar(200) DEFAULT NULL COMMENT '生产商',
shengchanriqi date DEFAULT NULL COMMENT '生产日期',
baozhiqi varchar(200) DEFAULT NULL COMMENT '保质期',
shuliang int(11) DEFAULT NULL COMMENT '数量',
shoujia int(11) DEFAULT NULL COMMENT '售价',
shiwutupian longtext COMMENT '食物图片',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=1681374822071 DEFAULT CHARSET=utf8 COMMENT='宠物食物';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table chongwushiwu
--
LOCK TABLES chongwushiwu WRITE;
/*!40000 ALTER TABLE chongwushiwu DISABLE KEYS /;
INSERT INTO chongwushiwu VALUES (81,'2023-04-13 08:24:43','食物名称1','食物类型1','品牌1','生产商1','2023-04-13','保质期1',0,1,'upload/chongwushiwu_shiwutupian1.jpg,upload/chongwushiwu_shiwutupian2.jpg,upload/chongwushiwu_shiwutupian3.jpg'),(82,'2023-04-13 08:24:43','食物名称2','食物类型2','品牌2','生产商2','2023-04-13','保质期2',2,2,'upload/chongwushiwu_shiwutupian2.jpg,upload/chongwushiwu_shiwutupian3.jpg,upload/chongwushiwu_shiwutupian4.jpg'),(83,'2023-04-13 08:24:43','食物名称3','食物类型3','品牌3','生产商3','2023-04-13','保质期3',3,3,'upload/chongwushiwu_shiwutupian3.jpg,upload/chongwushiwu_shiwutupian4.jpg,upload/chongwushiwu_shiwutupian5.jpg'),(84,'2023-04-13 08:24:43','食物名称4','食物类型4','品牌4','生产商4','2023-04-13','保质期4',4,4,'upload/chongwushiwu_shiwutupian4.jpg,upload/chongwushiwu_shiwutupian5.jpg,upload/chongwushiwu_shiwutupian6.jpg'),(85,'2023-04-13 08:24:43','食物名称5','食物类型5','品牌5','生产商5','2023-04-13','保质期5',5,5,'upload/chongwushiwu_shiwutupian5.jpg,upload/chongwushiwu_shiwutupian6.jpg,upload/chongwushiwu_shiwutupian7.jpg'),(86,'2023-04-13 08:24:43','食物名称6','食物类型6','品牌6','生产商6','2023-04-13','保质期6',6,6,'upload/chongwushiwu_shiwutupian6.jpg,upload/chongwushiwu_shiwutupian7.jpg,upload/chongwushiwu_shiwutupian8.jpg'),(87,'2023-04-13 08:24:43','食物名称7','食物类型7','品牌7','生产商7','2023-04-13','保质期7',7,7,'upload/chongwushiwu_shiwutupian7.jpg,upload/chongwushiwu_shiwutupian8.jpg,upload/chongwushiwu_shiwutupian9.jpg'),(88,'2023-04-13 08:24:43','食物名称8','食物类型8','品牌8','生产商8','2023-04-13','保质期8',8,8,'upload/chongwushiwu_shiwutupian8.jpg,upload/chongwushiwu_shiwutupian9.jpg,upload/chongwushiwu_shiwutupian10.jpg'),(1681374822070,'2023-04-13 08:33:42','XXX','XXX','XXX','XXX','2023-04-13','2个月',50,80,'upload/1681374821184.jpg');
/!40000 ALTER TABLE chongwushiwu ENABLE KEYS */;
