## Employers

id | name | email
--- | --- | ---
1 | Company A | companya@example.com
2 | Company B | companyb@example.com
3 | Company C | companyc@example.com
4 | Company D | companyd@example.com
5 | Company E | companye@example.com

## Benefits

id | benefit_name | description
--- | --- | ---
1 | Health Insurance | Comprehensive health insurance coverage for employees
2 | Dental Coverage | Includes preventative care, basic restoratives, and major services
3 | Vision Care | Covers annual eye exams, glasses, and contact lenses
4 | Retirement Plan | Matching contributions up to 6% of employee earnings
5 | Paid Time Off | Accrued PTO based on years of service

## Employers_Benefits

employer_id | benefit_id
--- | ---
(→ Employers.id) | (→ Benefits.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 5

## JobPostings

id | title | description | location | salary | posting_date
--- | --- | --- | --- | --- | ---
1 | Software Engineer | Design and develop software applications. | New York | 90000 | CURRENT_TIMESTAMP
2 | Data Analyst | Analyze data sets to provide insights and recommendations. | Los Angeles | 75000 | CURRENT_TIMESTAMP
3 | Marketing Manager | Lead marketing strategies and campaigns. | Chicago | 80000 | CURRENT_TIMESTAMP
4 | Product Designer | Create user-centered designs for products. | San Francisco | 85000 | CURRENT_TIMESTAMP
5 | HR Specialist | Manage recruitment and onboarding processes. | Boston | 60000 | CURRENT_TIMESTAMP

## Applicants

id | first_name | last_name | email | phone_number | resume
--- | --- | --- | --- | --- | ---
1 | John | Smith | johnsmith@email.com | 555-123-4567 | file://path/to/resume.pdf
2 | Jane | Doe | janedoe@email.com | 555-987-6543 | file://path/to/resume.pdf
3 | Michael | Johnson | michaeljohnson@email.com | 555-321-7654 | file://path/to/resume.pdf
4 | Emily | Williams | emilywilliams@email.com | 555-555-5555 | file://path/to/resume.pdf
5 | David | Brown | davidbrown@email.com | 555-111-2222 | file://path/to/resume.pdf

## ApplicationStatuses

application_id | status | interview_date | feedback
--- | --- | --- | ---
(→ Applicants.id) |  |  |
1 | Pending Interview | None | None
2 | Rejected | None | Not a good fit.
3 | Accepted | 2022-09-15 10:00:00 | Excellent candidate!
4 | Interview Scheduled | 2022-09-17 14:00:00 | Thank you for applying.
5 | Offer Made | None | We would like to offer you the position.