| DoctorID | Name | Specialty | Founding_Year | Past_Owners | Healthcare_Facility |
|---|---|---|---|---|---|
| 1 | Dr. John Smith | Cardiology | 2005 | John Brown, Mary Johnson | St. Luke's Hospital |
| 2 | Dr. Jane Doe | Pediatrics | 2010 | James White, Michael Black | Children's Hospital |
| 3 | Dr. Susan Lee | Dermatology | 2015 | Emma Green, David Wilson | Sunshine Skin Clinic |
| PatientID | FirstName | LastName | DateOfBirth |
|---|---|---|---|
| 1 | Alice | Smith | 1987-06-15 |
| 2 | Bob | Johnson | 1990-02-20 |
| 3 | Carol | Williams | 1985-10-05 |
| AppointmentID | PatientID | DoctorID | Date | Time |
|---|---|---|---|---|
| (→ Patients.PatientID) | (→ Doctors.DoctorID) | |||
| 1 | 1 | 1 | 2022-07-10 | 10:00 AM |
| 2 | 2 | 2 | 2022-07-12 | 03:00 PM |
| 3 | 3 | 3 | 2022-07-14 | 11:00 AM |
| MedicationID | MedicineName | DrugClass | Instructions |
|---|---|---|---|
| 1 | Ibuprofen | Nonsteroidal Anti-Inflammatory Drugs (NSAIDs) | Take 200 mg every 4 to 6 hours as needed. |
| 2 | Acetaminophen | Analgesics and Antipyretics | Take 500 mg every 4 to 6 hours as needed. |
| PrescriptionID | PatientID | MedicationID | IssueDate | ExpiryDate | Quantity |
|---|---|---|---|---|---|
| (→ Patients.PatientID) | (→ Medications.MedicationID) | ||||
| 1 | 1 | 1 | 2022-06-20 | 2022-06-30 | 30 |
| 2 | 2 | 1 | 2022-06-25 | 2022-07-09 | 60 |
| 3 | 3 | 2 | 2022-07-05 | 2022-07-19 | 14 |
| InsuranceID | PolicyNumber | Provider | CoverageAmount | StartDate | EndDate | PatientID |
|---|---|---|---|---|---|---|
| (→ Patients.PatientID) | ||||||
| 1 | ABCD1234 | HealthPlus | 10000 | 2022-01-01 | 2023-12-31 | 1 |
| 2 | EFGH5678 | Wellness Care | 12000 | 2022-01-15 | 2023-12-14 | 2 |
| 3 | IJKL9012 | Family Plan | 15000 | 2022-02-01 | 2023-01-31 | 3 |