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 |
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 |
id | company_name | location | industry |
---|---|---|---|
1 | TechCorp | New York | Technology |
2 | EcoCorp | San Francisco | Environmental Services |
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 |
application_id | applicant_name | 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 |