Employers

idnameemail
1Company Acompanya@example.com
2Company Bcompanyb@example.com
3Company Ccompanyc@example.com
4Company Dcompanyd@example.com
5Company Ecompanye@example.com

Benefits

idbenefit_namedescription
1Health InsuranceComprehensive health insurance coverage for employees
2Dental CoverageIncludes preventative care, basic restoratives, and major services
3Vision CareCovers annual eye exams, glasses, and contact lenses
4Retirement PlanMatching contributions up to 6% of employee earnings
5Paid Time OffAccrued PTO based on years of service

Employers_Benefits

employer_idbenefit_id
(→ Employers.id)(→ Benefits.id)
11
21
31
41
51
55

JobPostings

idtitledescriptionlocationsalaryposting_date
1Software EngineerDesign and develop software applications.New York90000CURRENT_TIMESTAMP
2Data AnalystAnalyze data sets to provide insights and recommendations.Los Angeles75000CURRENT_TIMESTAMP
3Marketing ManagerLead marketing strategies and campaigns.Chicago80000CURRENT_TIMESTAMP
4Product DesignerCreate user-centered designs for products.San Francisco85000CURRENT_TIMESTAMP
5HR SpecialistManage recruitment and onboarding processes.Boston60000CURRENT_TIMESTAMP

Applicants

idfirst_namelast_nameemailphone_numberresume
1JohnSmithjohnsmith@email.com555-123-4567file://path/to/resume.pdf
2JaneDoejanedoe@email.com555-987-6543file://path/to/resume.pdf
3MichaelJohnsonmichaeljohnson@email.com555-321-7654file://path/to/resume.pdf
4EmilyWilliamsemilywilliams@email.com555-555-5555file://path/to/resume.pdf
5DavidBrowndavidbrown@email.com555-111-2222file://path/to/resume.pdf

ApplicationStatuses

application_idstatusinterview_datefeedback
(→ Applicants.id)
1Pending InterviewNoneNone
2RejectedNoneNot a good fit.
3Accepted2022-09-15 10:00:00Excellent candidate!
4Interview Scheduled2022-09-17 14:00:00Thank you for applying.
5Offer MadeNoneWe would like to offer you the position.