Diagnostic_Centers
CenterID | Name | Address |
1 | Center A | 123 Main St |
2 | Center B | 456 Elm St |
3 | Center C | 789 Oak St |
4 | Center D | 01 Second Ave |
5 | Center E | Last St 23 |
Tests
TestTypeID | TestName |
1 | Blood_Test |
2 | X-Ray |
3 | Ultrasound |
4 | MRI |
5 | CT Scan |
Patients
PatientID | FirstName | LastName | DateOfBirth | PhoneNumber |
1 | John | Doe | 2000-01-01 | 555-123-4567 |
2 | Jane | Smith | 1999-02-02 | 555-987-6543 |
3 | Alice | Brown | 2001-03-03 | 555-000-0000 |
4 | Bob | White | 1998-04-04 | 555-111-2222 |
5 | Emma | Green | 2002-05-05 | 555-333-4444 |
Appointments
AppointmentID | CenterID | PatientID | AppointmentDate |
| (→ Diagnostic_Centers.CenterID) | (→ Patients.PatientID) | |
1 | 1 | 1 | 2022-06-01 |
2 | 2 | 2 | 2022-06-02 |
3 | 3 | 3 | 2022-06-03 |
4 | 4 | 4 | 2022-06-04 |
5 | 5 | 5 | 2022-06-05 |
Results
ResultID | AppointmentID | TestResultText | ResultDate |
| (→ Appointments.AppointmentID) | | |
1 | 1 | Normal | 2022-06-01 |
2 | 2 | Abnormal | 2022-06-02 |
3 | 3 | Positive | 2022-06-03 |
4 | 4 | Negative | 2022-06-04 |
5 | 5 | Inconclusive | 2022-06-05 |
Diagnostic_Centers_Tests
DiagnosticCenterID | TestTypeID |
(→ Diagnostic_Centers.CenterID) | (→ Tests.TestTypeID) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 4 |