Healthcare_Centers
CenterID | CenterName | Address |
1 | Center1 | Address1 |
2 | Center2 | Address2 |
3 | Center3 | Address3 |
4 | Center4 | Address4 |
5 | Center5 | Address5 |
Programs
ProgramID | ProgramType |
1 | Wellness_Initiatives |
2 | Disease_Prevention |
3 | Hospitality |
4 | Fitness |
5 | Emergency |
Patients
PatientID | FirstName | LastName | Age | CenterID |
| | | | (→ Healthcare_Centers.CenterID) |
1 | John | Doe | 30 | 1 |
2 | Jane | Smith | 28 | 2 |
3 | Mike | Brown | 26 | 3 |
4 | Emma | Wilson | 32 | 4 |
5 | David | Jackson | 40 | 5 |
Doctors
DoctorID | Name | Specialization | CenterID |
| | | (→ Healthcare_Centers.CenterID) |
1 | Dr. Smith | Cardiology | 1 |
2 | Dr. Johnson | Neurology | 2 |
3 | Dr. Williams | Orthopedics | 3 |
4 | Dr. Thompson | Pediatrics | 4 |
5 | Dr. Brown | Gastroenterology | 5 |
Appointments
AppointmentID | PatientID | DoctorID | Date |
| (→ Patients.PatientID) | (→ Doctors.DoctorID) | |
1 | 1 | 1 | 2022-07-15 10:00:00 |
2 | 2 | 2 | 2022-07-18 14:00:00 |
3 | 3 | 3 | 2022-07-20 09:00:00 |
4 | 4 | 4 | 2022-07-22 15:00:00 |
5 | 5 | 5 | 2022-07-24 16:00:00 |
MedicalHistory
HistoryID | PatientID | Diagnosis | Treatment |
| (→ Patients.PatientID) | | |
1 | 1 | Diabetes | Insulin Injections |
2 | 2 | High Blood Pressure | Medication |
3 | 3 | Asthma | Inhaler |
4 | 4 | Broken Arm | Cast |
5 | 5 | Anemia | Iron Supplements |
Healthcare_Centers_Programs
CenterID | ProgramID | StartDate | EndDate |
(→ Healthcare_Centers.CenterID) | (→ Programs.ProgramID) | | |
1 | 1 | 2022-06-01 | 2022-08-31 |
1 | 2 | 2022-09-01 | 2022-11-30 |
2 | 1 | 2022-06-01 | 2022-08-31 |
2 | 2 | 2022-09-01 | 2022-11-30 |
3 | 1 | 2022-06-01 | 2022-08-31 |
3 | 2 | 2022-09-01 | 2022-11-30 |
4 | 1 | 2022-06-01 | 2022-08-31 |
4 | 2 | 2022-09-01 | 2022-11-30 |
5 | 1 | 2022-06-01 | 2022-08-31 |
5 | 2 | 2022-09-01 | 2022-11-30 |