开发语言：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','<p>XXXXXXXXXXXXXXXX</p>','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 */;
如需定做或者获取更多资料，请联系QQ：375279829
客服QQ