| PatientID | FirstName | LastName | DateOfBirth |
|---|---|---|---|
| 1 | John | Doe | 2000-01-01 |
| 2 | Jane | Smith | 1987-06-15 |
| 3 | Michael | Johnson | 1993-11-23 |
| 4 | Emily | Williams | 1995-09-08 |
| 5 | David | Martinez | 1981-02-12 |
| DoctorID | DoctorName | Specialty |
|---|---|---|
| 1 | Dr. Brown | Cardiology |
| 2 | Dr. Green | Neurology |
| 3 | Dr. White | Pulmonology |
| 4 | Dr. Black | Gastroenterology |
| 5 | Dr. Gray | Orthopedics |
| AppointmentID | PatientID | DoctorID | DateAndTime |
|---|---|---|---|
| (→ Patients.PatientID) | (→ Doctors.DoctorID) | ||
| 1 | 1 | 1 | 2023-01-10 14:00:00 |
| 2 | 2 | 2 | 2023-02-12 10:00:00 |
| 3 | 3 | 3 | 2023-03-15 16:00:00 |
| 4 | 4 | 4 | 2023-04-05 11:00:00 |
| 5 | 5 | 5 | 2023-05-10 09:00:00 |
| ConditionID | ConditionName | BodyPartAffected | Medication | Severity |
|---|---|---|---|---|
| 1 | Hypertension | Heart | Lisinopril | Moderate |
| 2 | Epilepsy | Brain | Lamotrigine | Mild |
| 3 | Asthma | Lungs | Fluticasone | Mild |
| 4 | Inflammatory Bowel Disease | Digestive System | Prednisone | Moderate |
| 5 | Osteoarthritis | Joints | Acetaminophen | Mild |
| DiagnosisID | PatientID | ConditionID | DateOfDiagnosis |
|---|---|---|---|
| (→ Patients.PatientID) | (→ Conditions.ConditionID) | ||
| 1 | 1 | 1 | 2022-12-01 |
| 2 | 2 | 2 | 2022-12-15 |
| 3 | 3 | 3 | 2023-01-05 |
| 4 | 4 | 4 | 2023-02-20 |
| 5 | 5 | 5 | 2023-03-05 |
| PrescriptionID | AppointmentID | Medication | Quantity | Instructions |
|---|---|---|---|---|
| (→ Appointments.AppointmentID) | ||||
| 1 | 1 | Lisinopril | 30 | Take once daily. |
| 2 | 2 | Lamotrigine | 60 | Take twice daily with food. |
| 3 | 3 | Fluticasone | 30 | Use inhaler as directed by your doctor. |
| 4 | 4 | Prednisone | 10 | Take as prescribed by your doctor. |
| 5 | 5 | Acetaminophen | 30 | Take every 6 hours if needed. |