Scribd
Upload
21 views2 pages

Int Varchar Varchar Varchar Varchar Varchar Int Varchar Varchar Date Varchar Varchar

The document outlines the database schema for a healthcare management system, detailing the tables for doctors, admins, patients, appointments, and medical records. Each table includes various fields such as IDs, names, contact information, and specific attributes related to appointments and medical records. This structure is designed to facilitate the management of patient care and administrative tasks within a medical setting.

Uploaded by

nkunalotricia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
21 views2 pages

Int Varchar Varchar Varchar Varchar Varchar Int Varchar Varchar Date Varchar Varchar

The document outlines the database schema for a healthcare management system, detailing the tables for doctors, admins, patients, appointments, and medical records. Each table includes various fields such as IDs, names, contact information, and specific attributes related to appointments and medical records. This structure is designed to facilitate the management of patient care and administrative tasks within a medical setting.

Uploaded by

nkunalotricia
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

doctor

* doctor_id int *

first_name varchar

last_name varchar

admin specialization varchar

admin_id int *
contact_number varchar

first_name varchar email varchar


patient
last_name varchar
* patient_id int 1

first_name varchar

last_name varchar

date_of_birth date

contact_number varchar

email varchar

appointment

appointment_id int medical_record

patient_id int 1
record_id int

doctor_id int 1 *
patient_id int

admin_id int 1 1 doctor_id int


doctor_schedule
appointment_time time 1 admin_id int
schedule_id int
status varchar record_date date
doctor_id int 1
reason_for_visit varchar diagnosis varchar
schedule_date date
date Date
start_time time

end_time time

availability_status varchar
doctor
* doctor_id int *

first_name varchar

last_name varchar

admin specialization varchar

admin_id int *
contact_number varchar

first_name varchar email varchar


patient
last_name varchar
* patient_id int 1

first_name varchar

last_name varchar

date_of_birth date

contact_number varchar

email varchar

appointment

appointment_id int medical_record

patient_id int 1
record_id int

doctor_id int 1 *
patient_id int

admin_id int 1 1 doctor_id int


doctor_schedule
appointment_time time 1 admin_id int
schedule_id int
status varchar record_date date
doctor_id int 1
reason_for_visit varchar diagnosis varchar
schedule_date date
date Date
start_time time

end_time time

availability_status varchar

You might also like