Patients
PatientID | FirstName | LastName | DOB | PhoneNumber | EmailAddress |
1 | John | Doe | 1987-06-15 | +1234567890 | john.doe@example.com |
Doctors
DoctorID | FirstName | LastName | Specialty | LicenseNumber | OfficePhone |
1 | Jane | Smith | Cardiology | LIC001234567 | +0987654321 |
Medications
DrugID | Name | Classification | Manufacturer | Side_Effects | Effectiveness |
1 | Aspirin | Analgesic | Bayer | Gastrointestinal upset | High |
Prescriptions
PrescriptionID | PatientID | DoctorID | MedicationID | StartDate | EndDate | Quantity |
| (→ Patients.PatientID) | (→ Doctors.DoctorID) | (→ Medications.MedicationID) | | | |
1 | 1 | 1 | 1 | 2022-01-01 | 2022-01-31 | 10 |
Diagnoses
DiagnosisID | PatientID | DoctorID | Code | Description |
| (→ Patients.PatientID) | (→ Doctors.DoctorID) | | |
1 | 1 | 1 | A123 | Hypertension |
Appointments
AppointmentID | PatientID | DoctorID | AppointmentDateTime | ReasonForVisit | IsCancelled |
| (→ Patients.PatientID) | (→ Doctors.DoctorID) | | | |
1 | 1 | 1 | 2024-02-19 12:14:44 | Routine checkup | 0 |