PlanID | PlanName | MonthlyPremium |
---|---|---|
1 | Basic | 30.99 |
2 | Standard | 61.98 |
3 | Deluxe | 120.97 |
4 | Premier | 180.95 |
5 | Ultimate | 240.92 |
CoverageID | Description |
---|---|
1 | Prescription Drugs |
2 | Preventive Care |
3 | Hospitalization |
4 | Mental Health Services |
5 | Laboratory Tests |
PlanID | CoverageID |
---|---|
(→ Insurance_Plan.PlanID) | (→ Coverage.CoverageID) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 2 |
PatientID | Name | DOB |
---|---|---|
1 | John Doe | 1990-01-01 |
2 | Jane Smith | 1992-02-02 |
3 | Tom Johnson | 1988-03-03 |
4 | Emily Brown | 1994-04-04 |
5 | William Davis | 1996-05-05 |
DoctorID | Name | Specialty |
---|---|---|
1 | Dr. John Wilson | Cardiology |
2 | Dr. Jane Thompson | Gastroenterology |
3 | Dr. Tom Harris | Neurology |
4 | Dr. Emily Martin | Orthopedics |
5 | Dr. William Lee | Endocrinology |
AppointmentID | Date | Reason | PatientID | DoctorID |
---|---|---|---|---|
(→ Patient.PatientID) | (→ Doctor.DoctorID) | |||
1 | 2022-01-01 10:00:00 | Annual checkup | 1 | 1 |
2 | 2022-02-01 14:00:00 | Follow-up visit | 2 | 2 |
3 | 2022-03-01 09:00:00 | Consultation | 3 | 3 |
4 | 2022-04-01 11:00:00 | Wound care | 4 | 4 |
5 | 2022-05-01 13:00:00 | Diabetes management | 5 | 5 |