## Patients

ID | Name | Age | City
--- | --- | --- | ---
1 | Anne Buche | 32 | New York
2 | John Doe | 40 | Los Angeles
3 | Mary Smith | 28 | Chicago
4 | David Johnson | 36 | Houston
5 | Emma Brown | 25 | Phoenix

## Nurses

ID | Name | Experience | Specialty
--- | --- | --- | ---
1 | Alice Green | 10 | Cardiology
2 | Bob White | 7 | Neurology
3 | Carol Black | 12 | Orthopedics
4 | Dave Blue | 9 | Gastroenterology
5 | Eva Red | 8 | Urology

## Physicians_Assistants

ID | Name | Experience | Specialty
--- | --- | --- | ---
1 | Frank Grey | 5 | Endocrinology
2 | Grace Pink | 4 | Allergy and Immunology
3 | Helen Yellow | 6 | Infectious Disease
4 | Ian Purple | 7 | Rheumatology
5 | Jackie Orange | 10 | Oncology

## Job_Postings

ID | Position | Location | PostedDate | NurseID | PAID
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Nurses.ID) | (→ Physicians_Assistants.ID)
1 | Registered Nurse | San Francisco | 2024-03-13 19:49:18 | 1 | None
2 | Certified Registered Nurse Anesthetist | Seattle | 2024-03-13 19:49:18 | 2 | None
3 | Staff Nurse | Denver | 2024-03-13 19:49:18 | 3 | None
4 | Travel Nurse | Atlanta | 2024-03-13 19:49:18 | 4 | None
5 | Clinical Research Coordinator | Philadelphia | 2024-03-13 19:49:18 | 5 | 1

## Assigned_Jobs

ID | PatientID | JobID
--- | --- | ---
| (→ Patients.ID) | (→ Job_Postings.ID)
1 | 1 | 1
2 | 2 | 2
3 | 3 | 3
4 | 4 | 4
5 | 5 | 5