功能介绍
用户端功能有:首页、科室信息查看及挂号,公告资讯查看、个人信息管理,登录后台有个人信息管理、挂号预约查看及支付费用
管理端功能有:医生管理、患者管理、科室管理、挂号管理、系统管理等
医生后台功能:个人信息管理、科室信息管理、挂号预约管理
更多功能请看运行截图!
使用技术
开发语言:python
使用框架:Django2.0
前端技术:JavaScript、VUE.js(2.X)、css3
数据库:MySQL 5.7
数据库管理工具:Navicat或sqlyog
开发工具:pycharm
python版本:python3.7及以上
数据库脚本
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost Database: djangokon84
-- ------------------------------------------------------
-- Server version 5.7.31
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Current Database: `djangokon84`
--
/*!40000 DROP DATABASE IF EXISTS `djangokon84`*/;
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `djangokon84` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `djangokon84`;
--
-- Table structure for table `bingren`
--
DROP TABLE IF EXISTS `bingren`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bingren` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`bingrenzhanghao` varchar(200) NOT NULL COMMENT '病人账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`bingrenxingming` varchar(200) NOT NULL COMMENT '病人姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`bingrendianhua` varchar(200) DEFAULT NULL COMMENT '病人电话',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
PRIMARY KEY (`id`),
UNIQUE KEY `bingrenzhanghao` (`bingrenzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='病人';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `bingren`
--
LOCK TABLES `bingren` WRITE;
/*!40000 ALTER TABLE `bingren` DISABLE KEYS */;
INSERT INTO `bingren` VALUES (11,'2022-03-01 01:16:54','病人账号1','123456','病人姓名1','男','13823888881','upload/bingren_touxiang1.jpg'),(12,'2022-03-01 01:16:54','病人账号2','123456','病人姓名2','男','13823888882','upload/bingren_touxiang2.jpg'),(13,'2022-03-01 01:16:54','病人账号3','123456','病人姓名3','男','13823888883','upload/bingren_touxiang3.jpg'),(14,'2022-03-01 01:16:54','病人账号4','123456','病人姓名4','男','13823888884','upload/bingren_touxiang4.jpg'),(15,'2022-03-01 01:16:54','病人账号5','123456','病人姓名5','男','13823888885','upload/bingren_touxiang5.jpg'),(16,'2022-03-01 01:16:54','病人账号6','123456','病人姓名6','男','13823888886','upload/bingren_touxiang6.jpg');
/*!40000 ALTER TABLE `bingren` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
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 '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
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/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `guahaoyuyue`
--
DROP TABLE IF EXISTS `guahaoyuyue`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `guahaoyuyue` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`guahaobianhao` varchar(200) DEFAULT NULL COMMENT '挂号编号',
`keshimingcheng` varchar(200) DEFAULT NULL COMMENT '科室名称',
`keshileixing` varchar(200) DEFAULT NULL COMMENT '科室类型',
`yishengzhanghao` varchar(200) DEFAULT NULL COMMENT '医生账号',
`yishengxingming` varchar(200) DEFAULT NULL COMMENT '医生姓名',
`guahaofei` float DEFAULT NULL COMMENT '挂号费',
`guahaoshijian` date DEFAULT NULL COMMENT '挂号时间',
`bingrenzhanghao` varchar(200) DEFAULT NULL COMMENT '病人账号',
`bingrenxingming` varchar(200) DEFAULT NULL COMMENT '病人姓名',
`beizhu` longtext COMMENT '备注',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',
PRIMARY KEY (`id`),
UNIQUE KEY `guahaobianhao` (`guahaobianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='挂号预约';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `guahaoyuyue`
--
LOCK TABLES `guahaoyuyue` WRITE;
/*!40000 ALTER TABLE `guahaoyuyue` DISABLE KEYS */;
/*!40000 ALTER TABLE `guahaoyuyue` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `keshileixing`
--
DROP TABLE IF EXISTS `keshileixing`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `keshileixing` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`keshileixing` varchar(200) DEFAULT NULL COMMENT '科室类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='科室类型';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `keshileixing`
--
LOCK TABLES `keshileixing` WRITE;
/*!40000 ALTER TABLE `keshileixing` DISABLE KEYS */;
INSERT INTO `keshileixing` VALUES (41,'2022-03-01 01:16:54','科室类型1'),(42,'2022-03-01 01:16:54','科室类型2'),(43,'2022-03-01 01:16:54','科室类型3'),(44,'2022-03-01 01:16:54','科室类型4'),(45,'2022-03-01 01:16:54','科室类型5'),(46,'2022-03-01 01:16:54','科室类型6');
/*!40000 ALTER TABLE `keshileixing` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `keshixinxi`
--
DROP TABLE IF EXISTS `keshixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `keshixinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yiyuanmingcheng` varchar(200) DEFAULT NULL COMMENT '医院名称',
`keshibianhao` varchar(200) DEFAULT NULL COMMENT '科室编号',
`keshileixing` varchar(200) DEFAULT NULL COMMENT '科室类型',
`keshimingcheng` varchar(200) DEFAULT NULL COMMENT '科室名称',
`keshijieshao` longtext COMMENT '科室介绍',
`guahaofei` int(11) DEFAULT NULL COMMENT '挂号费',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`yishengzhanghao` varchar(200) DEFAULT NULL COMMENT '医生账号',
`yishengxingming` varchar(200) DEFAULT NULL COMMENT '医生姓名',
`paibanbiao` longtext COMMENT '排班表',
PRIMARY KEY (`id`),
UNIQUE KEY `keshibianhao` (`keshibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='科室信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `keshixinxi`
--
LOCK TABLES `keshixinxi` WRITE;
/*!40000 ALTER TABLE `keshixinxi` DISABLE KEYS */;
/*!40000 ALTER TABLE `keshixinxi` 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 '创建时间',
`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 */;
--
-- Dumping data for table `news`
--
LOCK TABLES `news` WRITE;
/*!40000 ALTER TABLE `news` DISABLE KEYS */;
/*!40000 ALTER TABLE `news` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `storeup`
--
DROP TABLE IF EXISTS `storeup`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `storeup` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`refid` bigint(20) DEFAULT NULL COMMENT '收藏id',
`tablename` varchar(200) DEFAULT NULL COMMENT '表名',
`name` varchar(200) NOT NULL COMMENT '收藏名称',
`picture` varchar(200) NOT NULL COMMENT '收藏图片',
`type` varchar(200) DEFAULT '1' COMMENT '类型(1:收藏,21:赞,22:踩)',
`inteltype` varchar(200) DEFAULT NULL COMMENT '推荐类型',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收藏表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `storeup`
--
LOCK TABLES `storeup` WRITE;
/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;
/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) NOT NULL COMMENT '用户名',
`password` varchar(100) NOT NULL COMMENT '密码',
`role` varchar(100) DEFAULT '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `users`
--
LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'abo','abo','管理员','2022-03-01 01:16:54');
UNLOCK TABLES;
--
-- Table structure for table `yisheng`
--
DROP TABLE IF EXISTS `yisheng`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `yisheng` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`yishengzhanghao` varchar(200) NOT NULL COMMENT '医生账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`yishengxingming` varchar(200) NOT NULL COMMENT '医生姓名',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`yishengdianhua` varchar(200) DEFAULT NULL COMMENT '医生电话',
`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
PRIMARY KEY (`id`),
UNIQUE KEY `yishengzhanghao` (`yishengzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='医生';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `yisheng`
--
LOCK TABLES `yisheng` WRITE;
/*!40000 ALTER TABLE `yisheng` DISABLE KEYS */;
/*!40000 ALTER TABLE `yisheng` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2022-03-06 19:34:13
项目截图