| ID | Name | Location |
|---|---|---|
| 1 | St. Johns Hospital | New York |
| 2 | Mercy General Hospital | Chicago |
| 3 | Mount Sinai Hospital | Los Angeles |
| 4 | Memorial Hermann Hospital | Houston |
| 5 | Mayo Clinic | Rochester |
| ID | Type |
|---|---|
| 1 | Emergency Medicine |
| 2 | Cardiology |
| 3 | Gastroenterology |
| 4 | Neurology |
| 5 | Orthopedics |
| Medical_Center_ID | Specialty_ID |
|---|---|
| (→ Medical_Center.ID) | (→ Specialty.ID) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 2 |
| ID | FirstName | LastName | LicenseNumber |
|---|---|---|---|
| 1 | John | Doe | MD123456789 |
| 2 | Jane | Smith | MD987654321 |
| 3 | Michael | Johnson | MD345678901 |
| 4 | Emily | Williams | MD789012345 |
| 5 | David | Brown | MD234567890 |
| ID | FirstName | LastName | DateOfBirth | PhoneNumber |
|---|---|---|---|---|
| 1 | Alice | Wilson | 1990-01-01 | 555-123-4567 |
| 2 | Bob | Thompson | 1985-02-02 | 555-987-6543 |
| 3 | Carol | Jackson | 1975-03-03 | 555-432-1234 |
| 4 | Daniel | Martin | 1992-04-04 | 555-654-3210 |
| 5 | Elizabeth | Taylor | 1988-05-05 | 555-132-4568 |
| ID | Patient_ID | Doctor_ID | StartTime | EndTime |
|---|---|---|---|---|
| (→ Patient.ID) | (→ Doctor.ID) | |||
| 1 | 1 | 1 | 2022-01-01 09:00:00 | 2022-01-01 10:00:00 |
| 2 | 2 | 2 | 2022-01-02 09:00:00 | 2022-01-02 10:00:00 |
| 3 | 3 | 3 | 2022-01-03 09:00:00 | 2022-01-03 10:00:00 |
| 4 | 4 | 4 | 2022-01-04 09:00:00 | 2022-01-04 10:00:00 |
| 5 | 5 | 5 | 2022-01-05 09:00:00 | 2022-01-05 10:00:00 |