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 |