| id | name | |
|---|---|---|
| 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 |
| 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 |
| employer_id | benefit_id |
|---|---|
| (→ Employers.id) | (→ Benefits.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 5 |
| 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 |
| id | first_name | last_name | 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 |
| 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. |