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