基于python的藥物管理系統(tǒng)設計與實現(xiàn)-計算機畢業(yè)設計源碼+LW文檔
開發(fā)語言：Python
框架：django
Python版本：python3.7.7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：PyCharm?
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫：
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `name` varchar(100) NOT NULL COMMENT '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/1636082628989.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jianduyuan`
--
DROP TABLE IF EXISTS `jianduyuan`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jianduyuan` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `jianduyuanzhanghao` varchar(200) NOT NULL COMMENT '監(jiān)督員賬號',
? `jianduyuanxingming` varchar(200) NOT NULL COMMENT '監(jiān)督員姓名',
? `mima` varchar(200) NOT NULL COMMENT '密碼',
? `xingbie` varchar(200) DEFAULT NULL COMMENT '性別',
? `nianling` int(11) DEFAULT NULL COMMENT '年齡',
? `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',
? PRIMARY KEY (`id`),
? UNIQUE KEY `jianduyuanzhanghao` (`jianduyuanzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1636082361704 DEFAULT CHARSET=utf8 COMMENT='監(jiān)督員';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jianduyuan`
--
LOCK TABLES `jianduyuan` WRITE;
/*!40000 ALTER TABLE `jianduyuan` DISABLE KEYS */;
INSERT INTO `jianduyuan` VALUES (11,'2021-11-05 02:57:31','監(jiān)督員賬號1','監(jiān)督員姓名1','123456','男',1,'13823888881'),(12,'2021-11-05 02:57:31','監(jiān)督員賬號2','監(jiān)督員姓名2','123456','女',2,'13823888882'),(13,'2021-11-05 02:57:31','監(jiān)督員賬號3','監(jiān)督員姓名3','123456','男',3,'13823888883'),(14,'2021-11-05 02:57:31','監(jiān)督員賬號4','監(jiān)督員姓名4','123456','男',4,'13823888884'),(15,'2021-11-05 02:57:31','監(jiān)督員賬號5','監(jiān)督員姓名5','123456','男',5,'13823888885'),(16,'2021-11-05 02:57:31','監(jiān)督員賬號6','監(jiān)督員姓名6','123456','男',6,'13823888886'),(1636081983823,'2021-11-05 03:13:03','11','依依','111','女',25,'13823813811'),(1636082361703,'2021-11-05 03:19:21','88','楊毅','88','男',30,'13813813822');
/*!40000 ALTER TABLE `jianduyuan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `title` varchar(200) NOT NULL COMMENT '標題',
? `introduction` longtext COMMENT '簡介',
? `picture` varchar(200) NOT NULL COMMENT '圖片',
? `content` longtext NOT NULL COMMENT '內容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='藥物公告';
/*!40101 SET character_set_client = @saved_cs_client */;
