Locations

LocationIDName
1University's Main Library
2City Library

Positions

PositionIDPositionName
1Head Librarian
2Assistant Librarian

Employees

EmployeeIDFirstNameLastNameEmailPhoneNumber
1JohnDoejohn.doe@example.com123-456-7890
2JaneSmithjane.smith@example.com098-765-4321

Applications

ApplicationIDPositionIDEmployeeIDDateApplied
(→ Positions.PositionID)(→ Employees.EmployeeID)
1112024-03-13 19:42:26
2222024-03-13 19:42:26

Libraries

LibraryIDLocationIDDescription
(→ Locations.LocationID)
11A large library with a vast collection of books.
22A smaller library with a focused collection of local history.

Archivists

ArchivistIDEmployeeIDLibraryIDStartDateEndDate
(→ Employees.EmployeeID)(→ Libraries.LibraryID)
1112021-01-012021-12-31
2222021-01-012021-12-31

Librarians

LibrarianIDEmployeeIDLibraryIDStartDateEndDate
(→ Employees.EmployeeID)(→ Libraries.LibraryID)
1112021-01-012021-12-31
2222021-01-012021-12-31