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 |