## Patients

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

## Doctors

DoctorID | DoctorName | Specialty
--- | --- | ---
1 | Dr. Brown | Cardiology
2 | Dr. Green | Neurology
3 | Dr. White | Pulmonology
4 | Dr. Black | Gastroenterology
5 | Dr. Gray | Orthopedics

## Appointments

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

## Conditions

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

## Diagnoses

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

## Prescriptions

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.