JOBS

IDTITLELOCATIONSALARYPOSTED_DATE
1Software EngineerNew York90000.02021-08-30
2Data ScientistSan Francisco100000.02021-07-30
3Product ManagerLos Angeles80000.02021-06-30
4Graphic DesignerChicago60000.02021-05-30
5Marketing SpecialistMiami50000.02021-04-30

HEALTHCARE_JOBS

IDJOB_TITLESHIFT_HOURS_ID
(→ JOBS.TITLE)(→ SHIFT_HOURS.ID)
1Nurse1
2Nurse2
3Physical Therapist1
4Physical Therapist3

SHIFT_HOURS

IDHOURSTYPE
18 hoursFull Time
212 hoursPart Time
3Night ShiftNight Shift
4Afternoon ShiftDay Shift

APPLICANTS

IDFIRST_NAMELAST_NAMEEMAILPHONE_NUMBERAPPLICATION_DATE
1JohnDoejohn.doe@example.com+12345678902024-03-13 13:34:15
2JaneSmithjane.smith@example.com+98765432102024-03-13 13:34:15
3AliceBrownalice.brown@example.com+55555555552024-03-13 13:34:15
4BobWhitebob.white@example.com+66666666662024-03-13 13:34:15
5EmmaBlackemma.black@example.com+77777777772024-03-13 13:34:15

APPLICATIONS

APPLICANT_IDJOB_IDSTATUSCOMMENTS
(→ APPLICANTS.ID)(→ JOBS.ID)
11AppliedGood experience
22RejectedNot a good fit
33PendingWaiting for interview
44AcceptedGreat skills
55InterviewedVery impressed