HospitalID | Name | Location |
---|---|---|
1 | St. Mary's Hospital | New York |
2 | Mount Sinai Hospital | Chicago |
3 | Rush University Medical Center | Chicago |
4 | Yale New Haven Health | Connecticut |
5 | John Hopkins Medicine | Baltimore |
DepartmentID | DepartmentName | HospitalID |
---|---|---|
(→ Hospitals.HospitalID) | ||
1 | Cardiac Surgery | 1 |
2 | Neurosurgery | 2 |
3 | Orthopedics | 3 |
4 | Pediatrics | 4 |
5 | Emergency Medicine | 5 |
EmployeeID | FirstName | LastName | PhoneNumber | MedicalProfession | Patient | |
---|---|---|---|---|---|---|
1 | Jane | Doe | jane.doe@example.com | 555-1234 | Nurse | Anne Buche |
2 | Mike | Smith | mike.smith@example.com | 555-5678 | Nurse | Alice Johnson |
3 | Linda | Williams | linda.williams@example.com | 555-9012 | Physician's Assistant | Anne Buche |
4 | Tom | Brown | tom.brown@example.com | 555-1234 | Physician's Assistant | David Lee |
5 | Karen | Green | karen.green@example.com | 555-9876 | Doctor | None |
JobPostID | PositionTitle | Description | Requirements | StartDate | EndDate | Salary | Vacancy | DepartmentID |
---|---|---|---|---|---|---|---|---|
(→ Departments.DepartmentID) | ||||||||
1 | Cardiovascular Nurse | Experience in cardiac care. | BLS certification required. | 2023-01-01 | 2023-12-31 | 65000 | 3 | 1 |
2 | Neurology Nurse | Neurosurgical experience necessary. | ACLS certification required. | 2023-02-01 | 2023-12-31 | 60000 | 2 | 2 |
3 | Orthopaedic PA | Assisting with orthopaedic surgeries. | Certified PAs only. | 2023-03-01 | 2023-12-31 | 65000 | 1 | 3 |
4 | Pediatric Nurse | Pediatric nursing experience required. | CPR certified. | 2023-04-01 | 2023-12-31 | 60000 | 4 | 4 |
5 | EM Resident | ER experience essential. | MD degree required. | 2023-05-01 | 2023-12-31 | 55000 | 5 | 5 |