Patients

PatientIDFirstNameLastNameDateOfBirth
1JohnDoe2000-01-01
2JaneSmith1987-06-15
3MichaelJohnson1993-11-23
4EmilyWilliams1995-09-08
5DavidMartinez1981-02-12

Doctors

DoctorIDDoctorNameSpecialty
1Dr. BrownCardiology
2Dr. GreenNeurology
3Dr. WhitePulmonology
4Dr. BlackGastroenterology
5Dr. GrayOrthopedics

Appointments

AppointmentIDPatientIDDoctorIDDateAndTime
(→ Patients.PatientID)(→ Doctors.DoctorID)
1112023-01-10 14:00:00
2222023-02-12 10:00:00
3332023-03-15 16:00:00
4442023-04-05 11:00:00
5552023-05-10 09:00:00

Conditions

ConditionIDConditionNameBodyPartAffectedMedicationSeverity
1HypertensionHeartLisinoprilModerate
2EpilepsyBrainLamotrigineMild
3AsthmaLungsFluticasoneMild
4Inflammatory Bowel DiseaseDigestive SystemPrednisoneModerate
5OsteoarthritisJointsAcetaminophenMild

Diagnoses

DiagnosisIDPatientIDConditionIDDateOfDiagnosis
(→ Patients.PatientID)(→ Conditions.ConditionID)
1112022-12-01
2222022-12-15
3332023-01-05
4442023-02-20
5552023-03-05

Prescriptions

PrescriptionIDAppointmentIDMedicationQuantityInstructions
(→ Appointments.AppointmentID)
11Lisinopril30Take once daily.
22Lamotrigine60Take twice daily with food.
33Fluticasone30Use inhaler as directed by your doctor.
44Prednisone10Take as prescribed by your doctor.
55Acetaminophen30Take every 6 hours if needed.