## Laboratory

id | name | address
--- | --- | ---
1 | Central Lab |
2 | South Lab |
3 | East Lab |
4 | West Lab |
5 | North Lab |

## Equipment

id | type | description
--- | --- | ---
1 | Microscope |
2 | CT Scanner |
3 | MRI Machine |
4 | X-Ray Machine |
5 | Ultrasound |

## Laboratory_Equipment

laboratory_id | equipment_type_id
--- | ---
(→ Laboratory.id) | (→ Equipment.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 4

## Doctors

id | name | specialization
--- | --- | ---
1 | Dr. Smith | Cardiology
2 | Dr. Johnson | Neurology
3 | Dr. Brown | Pediatrics
4 | Dr. Davis | Gastroenterology
5 | Dr. Garcia | Orthopedics

## Patients

id | name | age | gender
--- | --- | --- | ---
1 | John Doe | 30 | M
2 | Jane Smith | 28 | F
3 | Tom Johnson | 45 | M
4 | Emily Williams | 35 | F
5 | Robert Davis | 60 | M

## Appointments

appointment_id | doctor_id | patient_id | date | time
--- | --- | --- | --- | ---
| (→ Doctors.id) | (→ Patients.id) |  |
1 | 1 | 1 | 2023-09-01 | 10:00
2 | 2 | 2 | 2023-09-02 | 11:00
3 | 3 | 3 | 2023-09-03 | 14:00
4 | 4 | 4 | 2023-09-04 | 15:00
5 | 5 | 5 | 2023-09-05 | 09:00