Employees

idfirstNamelastNameemailphoneNumberhireDate
1JohnDoejohn.doe@example.com123-456-78902021-01-01
2JaneSmithjane.smith@example.com098-765-43212021-02-01

Departments

idnamemanagerId
(→ Employees.id)
1Engineering1
2Human Resources2

Salaries

employeeIdsalaryeffectiveDate
(→ Employees.id)
1700002021-01-01
2600002021-02-01

Applications

applicationIdapplicantIdjobIdresumePathcoverLetterPathstatus
(→ Employees.id)(→ Positions.position)
111/path/to/resume1.pdf/path/to/coverletter1.docxPending
222/path/to/resume2.pdf/path/to/coverletter2.docxReviewed

Positions

Recruiterpositiondescription
TechCorpSoftware EngineerNone
HealthCoRegistered NurseNone