| CompanyID | Name | Location |
|---|---|---|
| 1 | Healthcare Inc. | New York |
| 2 | Tech Solutions | California |
| 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 |
| ApplicantID | FirstName | LastName | 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 |
| ApplicationID | JobID | ApplicantID | Status |
|---|---|---|---|
| (→ Jobs.JobID) | (→ Applicants.ApplicantID) | ||
| 1 | 1 | 1 | Pending |
| 2 | 2 | 2 | Rejected |
| PatientID | FullName | DateOfBirth | ContactInfo |
|---|---|---|---|
| 1 | Anne Buche | 1990-01-01 | anne.buche@example.com |
| 2 | Michael Johnson | 1988-02-15 | michael.johnson@example.com |
| ProfessionID | Profession | CertificationNo |
|---|---|---|
| 1 | Nurse | A12345 |
| 2 | Physician's Assistant | B67890 |
| 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. |