id | degree_level | certification | job_post |
---|---|---|---|
1 | Bachelor | CS101 Certification | Software Developer |
2 | Masters | Data Science Specialization | Data Analyst |
3 | PhD | Research Scientist | |
4 | Associate | Networking Fundamentals | Network Engineer |
5 | Doctorate | Machine Learning Engineering | AI Researcher |
id | company_name | location | industry |
---|---|---|---|
1 | TechCorp | New York | Technology |
2 | FinanceInc. | Los Angeles | Banking |
3 | HealthCare | Chicago | Healthcare |
4 | GreenEnergy | San Francisco | Renewable Energy |
5 | LogisticsCo | Houston | Transportation |
id | applicant_name | phone_number | |
---|---|---|---|
1 | John Doe | johndoe@example.com | +123-456-7890 |
2 | Jane Smith | janesmith@example.com | +098-765-4321 |
3 | Alice Brown | alicebrown@example.com | +456-789-0123 |
4 | Bob Johnson | bobjohnson@example.com | +789-456-1230 |
5 | Carol White | carolwhite@example.com | +123-098-7654 |
id | title | description | salary | posted_date |
---|---|---|---|---|
1 | Software Developer | Design and develop software applications. | 80000.0 | 2021-01-01 |
2 | Data Analyst | Analyze data to provide insights and support decision making. | 60000.0 | 2021-01-02 |
3 | Research Scientist | Conduct research on cutting edge technologies. | 100000.0 | 2021-01-03 |
4 | Network Engineer | Install, configure, and maintain computer networks. | 70000.0 | 2021-01-04 |
5 | AI Researcher | Develop AI algorithms and models. | 90000.0 | 2021-01-05 |
company_id | job_id |
---|---|
(→ Companies.id) | (→ Jobs.id) |
1 | 1 |
2 | 2 |
3 | 3 |
4 | 4 |
5 | 5 |
application_id | applicant_id | job_id | status | submission_date |
---|---|---|---|---|
(→ Applicants.id) | (→ Jobs.id) | |||
1 | 1 | 1 | Pending | 2021-01-01 |
2 | 1 | 2 | Rejected | 2021-01-02 |
3 | 2 | 3 | Interview Scheduled | 2021-01-03 |
4 | 3 | 4 | Offered | 2021-01-04 |
5 | 4 | 5 | Accepted | 2021-01-05 |