## Librarians

id | name | age | experience | location
--- | --- | --- | --- | ---
1 | John Doe | 30 | 2 | University's Main Library
2 | Jane Smith | 31 | 5 | New York Public Library

## Archivists

id | name | age | experience | location
--- | --- | --- | --- | ---
1 | Michael Johnson | 28 | 7 | University's Main Library
2 | Emily Davis | 33 | 6 | British Museum

## Employers

id | company_name | address | contact_info
--- | --- | --- | ---
1 | ABC Company | 123 Street, City | +1234567890
2 | XYZ Company | 456 Avenue, Town | +0987654321

## Applicants

id | first_name | last_name | email | phone
--- | --- | --- | --- | ---
1 | Alexander | Anderson | alex@email.com | +1234567890
2 | Laura | Garcia | laura@email.com | +0987654321

## JobsPosted

id | employer_id | position | description | start_date | end_date
--- | --- | --- | --- | --- | ---
| (→ Employers.id) |  |  |  |
1 | 1 | Librarian | Responsible for managing library resources. | 2022-01-01 | 2023-12-31
2 | 2 | Curator | Manage museum exhibits and collections. | 2022-07-01 | 2023-06-30

## ApplicationsSubmitted

application_id | applicant_id | job_posting_id | resume | cover_letter
--- | --- | --- | --- | ---
| (→ Applicants.id) | (→ JobsPosted.id) |  |
1 | 1 | 1 | resume1.pdf | cover_letter1.txt
2 | 2 | 2 | resume2.pdf | cover_letter2.txt