## Companies

CompanyID | Name | Location
--- | --- | ---
1 | Healthcare Inc. | New York
2 | Tech Solutions | California

## Jobs

JobID | Title | Description | Salary | PostedDate | MedicalProfessional | CompanyID
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  | (→ Companies.CompanyID)
1 | Registered Nurse | Care for patients in a hospital setting. | 70000.0 | 2024-03-13 12:50:44 | Yes | 1
2 | Software Developer | Design and develop software applications. | 80000.0 | 2024-03-13 12:50:44 | No | 2

## Applicants

ApplicantID | FirstName | LastName | Email | PhoneNumber | ApplicationDate
--- | --- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | 555-1234 | 2024-03-13 12:50:44
2 | Jane | Smith | jane.smith@example.com | 555-5678 | 2024-03-13 12:50:44

## JobApplications

ApplicationID | JobID | ApplicantID | Status
--- | --- | --- | ---
| (→ Jobs.JobID) | (→ Applicants.ApplicantID) |
1 | 1 | 1 | Pending
2 | 2 | 2 | Rejected

## Patients

PatientID | FullName | DateOfBirth | ContactInfo
--- | --- | --- | ---
1 | Anne Buche | 1990-01-01 | anne.buche@example.com
2 | Michael Johnson | 1988-02-15 | michael.johnson@example.com

## MedicalProfessionals

ProfessionID | Profession | CertificationNo
--- | --- | ---
1 | Nurse | A12345
2 | Physician's Assistant | B67890

## MedicalHistory

HistoryID | PatientID | ProfessionID | TreatmentPlan
--- | --- | --- | ---
| (→ Patients.PatientID) | (→ MedicalProfessionals.ProfessionID) |
1 | 1 | 1 | Monitor blood pressure.
2 | 1 | 2 | Manage diabetes.
3 | 2 | 1 | Prescribe medication.
4 | 2 | 2 | Perform routine checkups.