Companies

CompanyIDNameLocation
1Healthcare Inc.New York
2Tech SolutionsCalifornia

Jobs

JobIDTitleDescriptionSalaryPostedDateMedicalProfessionalCompanyID
(→ Companies.CompanyID)
1Registered NurseCare for patients in a hospital setting.70000.02024-03-13 12:50:44Yes1
2Software DeveloperDesign and develop software applications.80000.02024-03-13 12:50:44No2

Applicants

ApplicantIDFirstNameLastNameEmailPhoneNumberApplicationDate
1JohnDoejohn.doe@example.com555-12342024-03-13 12:50:44
2JaneSmithjane.smith@example.com555-56782024-03-13 12:50:44

JobApplications

ApplicationIDJobIDApplicantIDStatus
(→ Jobs.JobID)(→ Applicants.ApplicantID)
111Pending
222Rejected

Patients

PatientIDFullNameDateOfBirthContactInfo
1Anne Buche1990-01-01anne.buche@example.com
2Michael Johnson1988-02-15michael.johnson@example.com

MedicalProfessionals

ProfessionIDProfessionCertificationNo
1NurseA12345
2Physician's AssistantB67890

MedicalHistory

HistoryIDPatientIDProfessionIDTreatmentPlan
(→ Patients.PatientID)(→ MedicalProfessionals.ProfessionID)
111Monitor blood pressure.
212Manage diabetes.
321Prescribe medication.
422Perform routine checkups.