## Locations

LocationID | Name
--- | ---
1 | University's Main Library
2 | City Library

## Positions

PositionID | PositionName
--- | ---
1 | Head Librarian
2 | Assistant Librarian

## Employees

EmployeeID | FirstName | LastName | Email | PhoneNumber
--- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | 123-456-7890
2 | Jane | Smith | jane.smith@example.com | 098-765-4321

## Applications

ApplicationID | PositionID | EmployeeID | DateApplied
--- | --- | --- | ---
| (→ Positions.PositionID) | (→ Employees.EmployeeID) |
1 | 1 | 1 | 2024-03-13 19:42:26
2 | 2 | 2 | 2024-03-13 19:42:26

## Libraries

LibraryID | LocationID | Description
--- | --- | ---
| (→ Locations.LocationID) |
1 | 1 | A large library with a vast collection of books.
2 | 2 | A smaller library with a focused collection of local history.

## Archivists

ArchivistID | EmployeeID | LibraryID | StartDate | EndDate
--- | --- | --- | --- | ---
| (→ Employees.EmployeeID) | (→ Libraries.LibraryID) |  |
1 | 1 | 1 | 2021-01-01 | 2021-12-31
2 | 2 | 2 | 2021-01-01 | 2021-12-31

## Librarians

LibrarianID | EmployeeID | LibraryID | StartDate | EndDate
--- | --- | --- | --- | ---
| (→ Employees.EmployeeID) | (→ Libraries.LibraryID) |  |
1 | 1 | 1 | 2021-01-01 | 2021-12-31
2 | 2 | 2 | 2021-01-01 | 2021-12-31