Patients

IDNameAgeCity
1Anne Buche32New York
2John Doe40Los Angeles
3Mary Smith28Chicago
4David Johnson36Houston
5Emma Brown25Phoenix

Nurses

IDNameExperienceSpecialty
1Alice Green10Cardiology
2Bob White7Neurology
3Carol Black12Orthopedics
4Dave Blue9Gastroenterology
5Eva Red8Urology

Physicians_Assistants

IDNameExperienceSpecialty
1Frank Grey5Endocrinology
2Grace Pink4Allergy and Immunology
3Helen Yellow6Infectious Disease
4Ian Purple7Rheumatology
5Jackie Orange10Oncology

Job_Postings

IDPositionLocationPostedDateNurseIDPAID
(→ Nurses.ID)(→ Physicians_Assistants.ID)
1Registered NurseSan Francisco2024-03-13 19:49:181None
2Certified Registered Nurse AnesthetistSeattle2024-03-13 19:49:182None
3Staff NurseDenver2024-03-13 19:49:183None
4Travel NurseAtlanta2024-03-13 19:49:184None
5Clinical Research CoordinatorPhiladelphia2024-03-13 19:49:1851

Assigned_Jobs

IDPatientIDJobID
(→ Patients.ID)(→ Job_Postings.ID)
111
222
333
444
555