## 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