| id | name | address | phone_number |
|---|---|---|---|
| 1 | Company A | Address A | Phone Number A |
| 2 | Company B | Address B | Phone Number B |
| 3 | Company C | Address C | Phone Number C |
| 4 | Company D | Address D | Phone Number D |
| 5 | Company E | Address E | Phone Number E |
| id | company_id | department_name |
|---|---|---|
| (→ Companies.id) | ||
| 1 | 1 | HR Department |
| 2 | 1 | IT Department |
| 3 | 2 | Marketing Department |
| 4 | 2 | Finance Department |
| 5 | 3 | Engineering Department |
| id | title | description | salary | post_date | department_id |
|---|---|---|---|---|---|
| (→ Departments.id) | |||||
| 1 | Software Engineer | Develop software solutions. | 70000 | 2022-06-01 | 1 |
| 2 | Data Analyst | Analyze data and provide insights. | 60000 | 2022-06-02 | 2 |
| 3 | Project Manager | Lead projects and coordinate teams. | 80000 | 2022-06-03 | 3 |
| 4 | Web Developer | Design and develop websites. | 65000 | 2022-06-04 | 4 |
| 5 | Graphic Designer | Create visual designs. | 50000 | 2022-06-05 | 5 |
| id | first_name | last_name | phone_number | |
|---|---|---|---|---|
| 1 | John | Smith | johnsmith@email.com | 123-456-7890 |
| 2 | Jane | Doe | janedoe@email.com | 098-765-4321 |
| 3 | Alice | Brown | alicebrown@email.com | 555-123-4567 |
| 4 | Charlie | White | charliewhite@email.com | 555-456-7890 |
| 5 | David | Green | davidgreen@email.com | 555-789-1234 |
| id | job_posting_id | applicant_id | status | application_date |
|---|---|---|---|---|
| (→ JobPostings.id) | (→ Applicants.id) | |||
| 1 | 1 | 1 | Pending | 2022-06-01 |
| 2 | 1 | 2 | Rejected | 2022-06-02 |
| 3 | 2 | 1 | Accepted | 2022-06-03 |
| 4 | 2 | 2 | Rejected | 2022-06-04 |
| 5 | 3 | 1 | Interview Scheduled | 2022-06-05 |
| id | career_option | university_id |
|---|---|---|
| (→ Universities.id) | ||
| 1 | Chemist | 1 |
| 2 | Chemist | 2 |
| 3 | Geoscientist | 1 |
| 4 | Geoscientist | 2 |
| 5 | Environmental Scientist | 1 |
| id | name |
|---|---|
| 1 | Massachusetts Institute of Technology (MIT) |
| 2 | Stanford University |
| 3 | California Institute of Technology (Caltech) |
| 4 | Harvard University |
| 5 | Princeton University |