Hospitals

idname
1Western Medical Center
2Eastern General Hospital
3Northern Healthcare
4Central Care Clinic
5City Urgent Care

Specialties

idname
1Cardiology
2Gastroenterology
3Neurology
4Orthopedics
5Pulmonology

Doctors

idnamespecialist_doctorhospital_id
(→ Specialties.name)(→ Hospitals.id)
1Dr. Jane SmithRadiologist1
2Dr. John BrownRadiologist2
3Ms. Mary JohnsonUltrasound Technician1
4Mr. Mike DavisUltrasound Technician2
5Dr. Sarah WilsonCardiologist3
6Dr. James WhiteGastroenterologist4
7Dr. Jennifer GreenNeurologist1
8Dr. David BlackOrthopedic Surgeon2

Jobs

idtitledescriptionlocationsalaryhospital_id
(→ Hospitals.id)
1CT Scan TechnicianPerform CT scans on patients.New York City900001
2MRI TechOperate MRI machines.New York City850001
3ER PhysicianTreat emergency cases.New York City2000001
4Anesthesia NurseMonitor patient during surgeries.New York City1000001
5PharmacistDispense medications.New York City950001
6Family Medicine DoctorDiagnose and treat illnesses.Chicago1600002
7DietitianCreate diet plans for patients.Chicago700002

JobApplications

application_iddoctor_idjob_idstatus
(→ Doctors.id)(→ Jobs.id)
111Accepted
225Rejected
336In Review
447Interviewing
551Rejected
662Accepted
773In Review
884Rejected