Design database for doctor appointment for hospital

Vote count:

0

I want to model a doctor appointment scheduling system for a hospital in MySQL. The hospital has several doctors. And each doctor has different work timings. So I am trying to break each day to several slots of length 1 hour each. And for each doctor there are maximum number of patients that he can see in the hour. It can be different for different doctors.

I have created a doctor information table which just has details of the doctor. I was first trying to write the model in paper, but i could hardly write anything.

DoctorInformation 
-----------------
DoctorId        int (PK)
Firstname       varchar
Lastname        varchar
Specialization  varchar


DoctorAvailability
------------------
DoctorId     int (FK)
Day          varchar(PK)


Slots
-----
Day  varchar (FK)
9-10  
10-11

9-10 , 10-11 ...... are different slots that I want to add to the table. Also how to add put date and appointment into consideration?

asked 41 secs ago

Sanchit Jain

6

Design database for doctor appointment for hospital