## Employers

id | companyName | contactNumber
--- | --- | ---
1 | ABC Corp | 123-456-7890
2 | XYZ Inc | 234-567-8901
3 | PQR Ltd | 345-678-9012
4 | STU Co | 456-789-0123
5 | MNO Corp | 567-890-1234

## JobTypes

id | typeName
--- | ---
1 | Software Engineer
2 | Project Manager
3 | Data Analyst
4 | Product Designer
5 | Quality Assurance

## Locations

id | locationName
--- | ---
1 | New York City
2 | San Francisco
3 | Chicago
4 | Los Angeles
5 | Austin

## Jobs

id | employerId | jobTypeId | locationId | Base_Pay_Range | Benefits | Job_Post
--- | --- | --- | --- | --- | --- | ---
| (→ Employers.id) | (→ JobTypes.id) | (→ Locations.id) |  |  |
1 | 1 | 1 | 1 | 80000 | Health Insurance, Retirement Plan | We are looking for a Software Engineer with 3+ years experience...
2 | 2 | 2 | 2 | 90000 | Dental Coverage, Paid Time Off | Experienced Project Managers needed to lead our cross-functional teams...
3 | 3 | 3 | 3 | 70000 | Medical Insurance, Stock Options | Seeking Data Analysts to join our team and help us make data-driven decisions...
4 | 4 | 4 | 4 | 60000 | Vision Care, Gym Membership | Looking for creative Product Designers to work on our new product line...
5 | 5 | 5 | 5 | 50000 | Life Insurance, Flexible Hours | Join our QA team as we expand and improve our software quality...

## Applicants

id | fullName | emailAddress | phoneNumber
--- | --- | --- | ---
1 | John Doe | john.doe@example.com | 123-456-7890
2 | Jane Smith | jane.smith@example.com | 234-567-8901
3 | Bob Johnson | bob.johnson@example.com | 345-678-9012
4 | Alice Williams | alice.williams@example.com | 456-789-0123
5 | Tom Brown | tom.brown@example.com | 567-890-1234

## ApplicationStatuses

applicationId | applicantId | status | dateApplied
--- | --- | --- | ---
| (→ Applicants.id) |  |
1 | 1 | In Review | 2022-01-01
2 | 2 | Rejected | 2022-01-02
3 | 3 | Interview Scheduled | 2022-01-03
4 | 4 | Hired | 2022-01-04
5 | 5 | Waitlisted | 2022-01-05