## Chemists

id | chemist_name | university | start_date | end_date
--- | --- | --- | --- | ---
1 | John Doe | MIT | 2019-06-01 | 2021-08-31
2 | Jane Smith | Stanford University | 2017-09-01 | 2019-12-31

## Geoscientists

id | geoscientist_name | university | start_date | end_date
--- | --- | --- | --- | ---
1 | David Johnson | MIT | 2018-05-01 | 2020-08-31
2 | Emily Brown | Caltech | 2019-09-01 | 2021-12-31

## Companies

id | company_name | location | industry
--- | --- | --- | ---
1 | TechCorp | New York | Technology
2 | EcoCorp | San Francisco | Environmental Services

## Jobs

id | job_title | description | required_skills | posted_on
--- | --- | --- | --- | ---
1 | Software Engineer | Development of new software products. | Java, Python, JavaScript | 2021-06-15 10:00:00
2 | Data Scientist | Analysis and interpretation of large datasets. | R, SQL, Machine Learning | 2021-06-15 10:00:00

## Applications

application_id | applicant_name | email | phone_number | resume | cover_letter | applied_at | status
--- | --- | --- | --- | --- | --- | --- | ---
1 | Alice Cooper | alice@example.com | 123-456-7890 | CooperResume.pdf | CoverLetter.txt | 2021-06-15 10:00:00 | Pending
2 | Bob Smith | bob@example.com | 098-765-4321 | SmithResume.pdf | CoverLetter.txt | 2021-06-15 10:00:00 | Accepted