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. |