YySxhE27

1drop database if exists Hospital;
2create database Hospital;
3use Hospital;
4
5create table doctors(
6id int auto_increment primary key,
7doctorName varchar(255) not null,
8mail varchar(255) not null,
9phoneNumber varchar(30) not null,
10specializations enum('eyes','nose','throat','GP'), 
11cabinet varchar(10) null,
12healthFund enum('yes','no')
13);
14
15
16create table patients(
17id int auto_increment primary key,
18patientName varchar(255) not null,
19adress varchar(100) not null,
20EGN varchar(10) not null unique,
21
22);