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. |