Chemists

idchemist_nameuniversitystart_dateend_date
1John DoeMIT2019-06-012021-08-31
2Jane SmithStanford University2017-09-012019-12-31

Geoscientists

idgeoscientist_nameuniversitystart_dateend_date
1David JohnsonMIT2018-05-012020-08-31
2Emily BrownCaltech2019-09-012021-12-31

Companies

idcompany_namelocationindustry
1TechCorpNew YorkTechnology
2EcoCorpSan FranciscoEnvironmental Services

Jobs

idjob_titledescriptionrequired_skillsposted_on
1Software EngineerDevelopment of new software products.Java, Python, JavaScript2021-06-15 10:00:00
2Data ScientistAnalysis and interpretation of large datasets.R, SQL, Machine Learning2021-06-15 10:00:00

Applications

application_idapplicant_nameemailphone_numberresumecover_letterapplied_atstatus
1Alice Cooperalice@example.com123-456-7890CooperResume.pdfCoverLetter.txt2021-06-15 10:00:00Pending
2Bob Smithbob@example.com098-765-4321SmithResume.pdfCoverLetter.txt2021-06-15 10:00:00Accepted