Laboratory

idnameaddress
1Central Lab
2South Lab
3East Lab
4West Lab
5North Lab

Equipment

idtypedescription
1Microscope
2CT Scanner
3MRI Machine
4X-Ray Machine
5Ultrasound

Laboratory_Equipment

laboratory_idequipment_type_id
(→ Laboratory.id)(→ Equipment.id)
11
21
31
41
51
54

Doctors

idnamespecialization
1Dr. SmithCardiology
2Dr. JohnsonNeurology
3Dr. BrownPediatrics
4Dr. DavisGastroenterology
5Dr. GarciaOrthopedics

Patients

idnameagegender
1John Doe30M
2Jane Smith28F
3Tom Johnson45M
4Emily Williams35F
5Robert Davis60M

Appointments

appointment_iddoctor_idpatient_iddatetime
(→ Doctors.id)(→ Patients.id)
1112023-09-0110:00
2222023-09-0211:00
3332023-09-0314:00
4442023-09-0415:00
5552023-09-0509:00