Doctors

DoctorIDNameSpecialtyFounding_YearPast_OwnersHealthcare_Facility
1Dr. John SmithCardiology2005John Brown, Mary JohnsonSt. Luke's Hospital
2Dr. Jane DoePediatrics2010James White, Michael BlackChildren's Hospital
3Dr. Susan LeeDermatology2015Emma Green, David WilsonSunshine Skin Clinic

Patients

PatientIDFirstNameLastNameDateOfBirth
1AliceSmith1987-06-15
2BobJohnson1990-02-20
3CarolWilliams1985-10-05

Appointments

AppointmentIDPatientIDDoctorIDDateTime
(→ Patients.PatientID)(→ Doctors.DoctorID)
1112022-07-1010:00 AM
2222022-07-1203:00 PM
3332022-07-1411:00 AM

Medications

MedicationIDMedicineNameDrugClassInstructions
1IbuprofenNonsteroidal Anti-Inflammatory Drugs (NSAIDs)Take 200 mg every 4 to 6 hours as needed.
2AcetaminophenAnalgesics and AntipyreticsTake 500 mg every 4 to 6 hours as needed.

Prescriptions

PrescriptionIDPatientIDMedicationIDIssueDateExpiryDateQuantity
(→ Patients.PatientID)(→ Medications.MedicationID)
1112022-06-202022-06-3030
2212022-06-252022-07-0960
3322022-07-052022-07-1914

Insurances

InsuranceIDPolicyNumberProviderCoverageAmountStartDateEndDatePatientID
(→ Patients.PatientID)
1ABCD1234HealthPlus100002022-01-012023-12-311
2EFGH5678Wellness Care120002022-01-152023-12-142
3IJKL9012Family Plan150002022-02-012023-01-313