Doctors

idnamespecialtyhospital_id
(→ Hospitals.id)
1Dr. John SmithCardiology1
2Dr. Jane DoeGeneral Practice2
3Dr. Mike JohnsonOrthopedics3
4Dr. Sarah BrownPediatrics4
5Dr. Emily DavisNeurology5

Hospitals

idnamecityneighborhoodphone_number
1St. Mary's HospitalNew York CityMidtown+1-212-500-1111
2Mount Sinai Medical CenterMiamiDowntown+1-305-555-2222
3Memorial Hermann HospitalHoustonMedical Center+1-713-244-6000
4Cleveland ClinicClevelandGates Mills Boulevard+1-216-444-1000
5Mayo ClinicRochesterFirst Street SW+1-507-538-0000

InsurancePlans

idplan_namepremiumcoverage_detailsprovider_id
(→ Providers.id)
1Basic Plan100Covers essential medical services1
2Standard Plan200Includes preventive care and routine checkups2
3Deluxe Plan300Comprehensive coverage with no out-of-pocket costs3
4Ultimate Plan400Most extensive coverage available4
5VIP Plan500Exclusive benefits and concierge service5

Patients

idfirst_namelast_namebirthdateinsurance_plan_id
(→ InsurancePlans.id)
1JohnDoe1980-01-011
2JaneSmith1985-02-022
3EmilyBrown1990-03-033
4MikeJohnson1995-04-044
5SarahDavis2000-05-055

Prescriptions

idpatient_iddoctor_idmedicationdosagequantityrefillableprescription_date
(→ Patients.id)(→ Doctors.id)
111Lisinopril5mg3012021-01-01 10:00:00
222Metformin500mg3002021-02-01 11:00:00
333Codeine60mg3012021-03-01 12:00:00
444Albuterol9mg3012021-04-01 13:00:00
555Azathioprine50mg3002021-05-01 14:00:00