| id | name | age | experience | location |
|---|---|---|---|---|
| 1 | John Doe | 30 | 2 | University's Main Library |
| 2 | Jane Smith | 31 | 5 | New York Public Library |
| id | name | age | experience | location |
|---|---|---|---|---|
| 1 | Michael Johnson | 28 | 7 | University's Main Library |
| 2 | Emily Davis | 33 | 6 | British Museum |
| id | company_name | address | contact_info |
|---|---|---|---|
| 1 | ABC Company | 123 Street, City | +1234567890 |
| 2 | XYZ Company | 456 Avenue, Town | +0987654321 |
| id | first_name | last_name | phone | |
|---|---|---|---|---|
| 1 | Alexander | Anderson | alex@email.com | +1234567890 |
| 2 | Laura | Garcia | laura@email.com | +0987654321 |
| 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 |
| 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 |