基于Mysql的智慧医疗管理系统

说一下基本流程：

需求分析--关联分析--数据库设计--Sql开发

需求分析需要知道要做什么？初衷是什么？

关联分析主要画E-R图，Mysql是关系数据库，关联分析很重要

数据库设计，建几个表？几个库？主键是什么？表和表怎么连上？

Sql是灵魂。

下面这些就是Sql代码块，需求分析，关联分析，可以联系博主。

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 80022
Source Host           : localhost:3306
Source Database       : treat3

Target Server Type    : MYSQL
Target Server Version : 80022
File Encoding         : 65001

Date: 2021-07-03 21:05:47
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for bingli
-- ----------------------------
DROP TABLE IF EXISTS `bingli`;
CREATE TABLE `bingli` (
  `BID` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `Gname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `PID` varchar(100) NOT NULL,
  `Bguo` varchar(50) DEFAULT NULL,
  `Psex` varchar(50) DEFAULT NULL,
  `Bsit` varchar(255) DEFAULT NULL,
  `Dname` varchar(255) DEFAULT NULL,
  `Btime` varchar(255) DEFAULT NULL,
  `Bif` varchar(50) DEFAULT NULL,
  `Bday` int DEFAULT NULL,
  `Mnoname` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `BMnonum` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`BID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bingli
-- ----------------------------
INSERT INTO `bingli` VALUES ('20210512100400562', '林康', '210100201602232710', '无', '男', '感冒', '张鹏', '202105121623', '否', '0', '感冒灵0005', '1盒');
INSERT INTO `bingli` VALUES ('20210512100700596', '安非', '210202199605122720', '有', '女', '肠癌', '高小小', '202105121652', '是', '15', null, null);
INSERT INTO `bingli` VALUES ('20210525100300001', '何必得', '150600200105022710', '无', '男', '骨折', '天天', '202105251123', '是', '1', '阿莫西林0001', '1盒');
INSERT INTO `bingli` VALUES ('20210530100500562', '安理', '211224199105022710', '无', '男', '白癜风', '石下', '202105231756', '否', '0', '斑鸠菊注射液0007', '1疗程');
INSERT INTO `bingli` VALUES ('20210601100100523', '韩即', '457845196102152710', '无', '男', '无', '张三', '202106010921', '否', '0', '无', null);
INSERT INTO `bingli` VALUES ('20210601100300011', '傲日格勒', '152127200105062710', null, null, null, null, null, null, null, null, null);
INSERT INTO `bingli` VALUES ('20210603100100011', '啊啊分', '152127200305072710', null, null, null, null, null, null, null, null, null);
INSERT INTO `bingli` VALUES ('202106060000100562', '何安', '150000199103032715', '无', '男', '肠炎', '张三', '202106061555', '否', '0', '诺氟沙星0022', '1盒');
INSERT INTO `bingli` VALUES ('20210608100300232', '王五', '460200200102122720', '无', '女', '擦伤', '刘六', '202106081652', '否', '0', '双氧水0002', '1瓶');
INSERT INTO `bingli` VALUES ('20210611100700065', '安体', '230000198702232820', '无', '男', '纤维瘤', '高小小', '202106110956', '是', '7', null, null);
INSERT INTO `bingli` VALUES ('20210612101000236', '李理', '150600198103252722', '有', '女', '无', '韩临', '202106121523', '否', '0', '无', null);
INSERT INTO `bingli` VALUES ('20210613100600001', '韩燚', '201100201102232720', '无', '女', '近视', '木目', '202106130956', '否', '0', '无', null);
INSERT INTO `bingli` VALUES ('20210615100600025', '马俩三', '210203200305162710', '无', '男', '耳炎', '火燚', '202106150959', '否', '0', '头孢006', '1瓶');
INSERT INTO `bingli` VALUES ('202106161001000001', '李四', '152127200105072711', '无', '男', '肠炎', '张三', '202106161455', '否', '0', '诺氟沙星0022', '1盒');
INSERT INTO `bingli` VALUES ('20210616100100002', '何安', '150000199103032715', '无', '男', '感冒', '张三', '202106161426', '否', '0', '感冒灵0005', '1盒');
INSERT INTO `bingli` VALUES ('20210618100900025', '安若', '220106198105152712', '无', '男', '轻微抑郁', '郑正', '202106181123', '否', '0', '无', null);
INSERT INTO `bingli` VALUES ('20210619100300001', '张叒叕', '152127199905322710', '无', '男', '伤口感染', '刘六', '202106190945', '否', '0', '阿莫西林0001', '2盒');
INSERT INTO `bingli` VALUES ('20210619100500002', '闫一', '152127200105072710', '无', '男', '过敏性皮肤病', '石下', '202106191123', '否', '0', '无', null);
INSERT INTO `bingli` VALUES ('20210620100800001', '吴安', '150800200212112720', '无', '女', '无', '任非', '202106200956', '否', '0', '无', null);
INSERT INTO `bingli` VALUES ('20210622100100025', '林琳', '211301201612232720', '无', '女', '肺炎', '张晓雪', '202106221023', '否', '0', '阿奇霉素分散片0008', '1疗程');
INSERT INTO `bingli` VALUES ('20210623100400233', '何必', '457845200103232710', '无', '男', '蛀牙', '张晓雪', '202106231532',