## Doctors

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

## Patients

PatientID | FirstName | LastName | DateOfBirth
--- | --- | --- | ---
1 | Alice | Smith | 1987-06-15
2 | Bob | Johnson | 1990-02-20
3 | Carol | Williams | 1985-10-05

## Appointments

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

## Medications

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.

## Prescriptions

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

## Insurances

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