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. |