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 |