Recruiter

idnamelocation
1Tech SolutionsSan Francisco
2Software Inc.New York

Applicant

idfirstNamelastNameemailphoneNumberpositionId
(→ Position.id)
1JohnSmithjohnsmith@example.com+1-123-456-78901
2JaneDoejanedoe@example.com+1-987-654-32101

Interview

iddatetimeapplicantIdinterviewerIdpositionIdstatus
(→ Applicant.id)(→ Employee.id)(→ Position.id)
12023-01-1510:00 AM111Pending
22023-01-1611:00 AM221Completed

Employee

idfirstNamelastNameemailphoneNumberrolehireDate
1AliceWonderlandaliceland@example.com+1-123-456-7890HR Manager2022-01-01
2BobBuilderbobbuilder@example.com+1-987-654-3210Engineering Director2021-07-15

Position

idtitledescriptionsalarycompanyId
(→ Recruiter.id)
1Software EngineerDevelop and maintain software applications.900001
2Data AnalystAnalyze data to provide insights and recommendations.800001