ID | Name |
---|---|
1 | Western Medical Center |
2 | Eastern General Hospital |
ID | Name | Department | HospitalName |
---|---|---|---|
(→ Departments.ID) | (→ Hospitals.Name) | ||
1 | John Doe | 1 | Western Medical Center |
2 | Jane Smith | 1 | Eastern General Hospital |
3 | Alice Johnson | 2 | Western Medical Center |
4 | Bob Brown | 3 | Eastern General Hospital |
5 | Charlie Davis | 4 | Western Medical Center |
6 | Diana Miller | 5 | Eastern General Hospital |
ID | Name | Department | HospitalName |
---|---|---|---|
(→ Departments.ID) | (→ Hospitals.Name) | ||
1 | Mike White | 1 | Western Medical Center |
2 | Emily Green | 2 | Eastern General Hospital |
3 | Paul Black | 3 | Western Medical Center |
4 | Kelly Red | 4 | Eastern General Hospital |
5 | Robert Blue | 5 | Western Medical Center |
6 | Nancy Silver | 6 | Eastern General Hospital |
ID | Type |
---|---|
1 | Diagnostic Imaging |
2 | Cardiac Care Unit |
3 | Neurology |
4 | Orthopedics |
5 | Pediatrics |
JobId | Title | Description | StartDate | EndDate | Requirements | Salary | DepartmentID |
---|---|---|---|---|---|---|---|
(→ Departments.ID) | |||||||
1 | Radiology Technician | Assist radiologists in performing medical imaging examinations. | 2022-09-01 | 2023-08-31 | Bachelor's degree in Radiologic Technology required. | 75000 | 1 |
2 | Ultrasonographer | Operate ultrasound equipment to visualize internal organs and structures. | 2022-09-01 | 2023-08-31 | Associates degree in Diagnostic Medical Sonography required. | 60000 | 2 |
3 | Cardiovascular Perfusionist | Perform cardiopulmonary bypass procedures during open heart surgery. | 2022-09-01 | 2023-08-31 | Certified Clinical Perfusionist credential required. | 85000 | 3 |
4 | Neurosonographer | Use ultrasound technology to assess neurological conditions. | 2022-09-01 | 2023-08-31 | Bachelors Degree in Neurodiagnostics required. | 70000 | 4 |
5 | Physical Therapist | Design and implement treatment plans for patients recovering from injuries. | 2022-09-01 | 2023-08-31 | Doctor of Physical Therapy degree required. | 80000 | 5 |
6 | Occupational Therapist | Help patients develop, recover, and improve skills needed for daily living activities. | 2022-09-01 | 2023-08-31 | Master's degree in Occupational Therapy required. | 75000 | 6 |
ApplicantId | Fullname | PhoneNumber | Application | |
---|---|---|---|---|
1 | Alexander Anderson | alex@email.com | +1 555-123-4567 | Attached CV |
2 | Grace Kim | grace@email.com | +1 555-987-6543 | Attached CV |
3 | William Lee | william@email.com | +1 555-555-5555 | Attached CV |
4 | Samantha Martinez | samantha@email.com | +1 555-123-4567 | Attached CV |
5 | Daniel Wilson | daniel@email.com | +1 555-987-6543 | Attached CV |
6 | David Harris | david@email.com | +1 555-555-5555 | Attached CV |