Librarians

idnameageexperiencelocation
1John Doe302University's Main Library
2Jane Smith315New York Public Library

Archivists

idnameageexperiencelocation
1Michael Johnson287University's Main Library
2Emily Davis336British Museum

Employers

idcompany_nameaddresscontact_info
1ABC Company123 Street, City+1234567890
2XYZ Company456 Avenue, Town+0987654321

Applicants

idfirst_namelast_nameemailphone
1AlexanderAndersonalex@email.com+1234567890
2LauraGarcialaura@email.com+0987654321

JobsPosted

idemployer_idpositiondescriptionstart_dateend_date
(→ Employers.id)
11LibrarianResponsible for managing library resources.2022-01-012023-12-31
22CuratorManage museum exhibits and collections.2022-07-012023-06-30

ApplicationsSubmitted

application_idapplicant_idjob_posting_idresumecover_letter
(→ Applicants.id)(→ JobsPosted.id)
111resume1.pdfcover_letter1.txt
222resume2.pdfcover_letter2.txt