## Companies

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

## Departments

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

## JobPostings

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

## Applicants

id | first_name | last_name | email | 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

## ApplicationStatuses

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

## EarthScienceCareerOptions

id | career_option | university_id
--- | --- | ---
|  | (→ Universities.id)
1 | Chemist | 1
2 | Chemist | 2
3 | Geoscientist | 1
4 | Geoscientist | 2
5 | Environmental Scientist | 1

## Universities

id | name
--- | ---
1 | Massachusetts Institute of Technology (MIT)
2 | Stanford University
3 | California Institute of Technology (Caltech)
4 | Harvard University
5 | Princeton University