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 |