| 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 |
| id | typeName |
|---|---|
| 1 | Software Engineer |
| 2 | Project Manager |
| 3 | Data Analyst |
| 4 | Product Designer |
| 5 | Quality Assurance |
| id | locationName |
|---|---|
| 1 | New York City |
| 2 | San Francisco |
| 3 | Chicago |
| 4 | Los Angeles |
| 5 | Austin |
| 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... |
| 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 |
| 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 |