Company

idnamelocation
1Tech SolutionsSan Francisco
2Software Inc.New York

Recruitment_Agency

idagencyNamecontactEmailcontactPhone
1Top Talent Agencytoptalent@example.com+1-800-123-4567
2Job Connectjobconnect@example.com+1-900-987-6543

Position

idtitledescriptionsalarycompanyIdrecruitmentAgencyId
(→ Company.id)(→ Recruitment_Agency.id)
1Software EngineerDevelop and maintain software applications.9000011
2Data AnalystAnalyze data to provide insights and recommendations.8000012

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