E-learning/hosp.sql at master · Theja4/E-learning · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
CREATE DATABASE  IF NOT EXISTS `Hospital`;
USE `Hospital`;


CREATE TABLE `Doctor` (
  `did` int not null,
   `availability` int default 1,
  `dname` varchar(45) DEFAULT NULL unique,
  `emailid` varchar(45) DEFAULT NULL,
  `password` varchar(45) DEFAULT NULL,
  `specialization` varchar(45) DEFAULT NULL,
  `slot` varchar(45) default NULL,
  PRIMARY KEY (`did`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


CREATE TABLE `patient` (
  `pid` int not null auto_increment,
  `pname` varchar(45),
  `emailid` varchar(45) DEFAULT NULL,
  `password` varchar(45) DEFAULT NULL,
  `symptoms` varchar(45) DEFAULT NULL,
  `slot1` int default NULL,
  `slot2` int  default NULL,
  `age` int not null,
  `prescription` text default null,
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

insert into doctor values(2,1,'doc','abcd@gmail.com','doc123','cardiac','ca');
insert into patient values(1,'yogi','abffcd@gmail.com','8d52299ch','cardiac pain',0,'0',8,'Paracetomal HCQ');
insert into patient values(3,'yogi','abffcd@gmaisl.com','8d52299ch','cardiac pain',0,'0',8,'Paracetomal HCQ');
insert into doctor values(4,1,'foc','abcd@dsdgmail.com','df852299ch','cardiac','A1');