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 |