Departments

DepartmentIDName
1Human Resources
2IT
3Finance
4Marketing
5Sales

Employees

EmployeeIDFirstNameLastNameEmailPhoneNumberHireDateSalaryDepartmentID
(→ Departments.DepartmentID)
1JohnDoejohn.doe@example.com123-456-78902020-01-0160000.01
2JaneSmithjane.smith@example.com987-654-32102019-02-0150000.02
3AliceBrownalice.brown@example.com456-789-01232018-03-0155000.03
4BobWhitebob.white@example.com246-865-13572017-04-0165000.04
5CharlieBlackcharlie.black@example.com654-321-09872016-05-0170000.05

WorkingArrangements

ArrangementIDDescription
1Remote
2Onsite
3Hybrid
4Flexible
5Rotational

Positions

PositionIDTitleMinimumQualificationsMaximumSalaryMINumberOfYearsExperienceForeignKey_PositionType
(→ PositionTypes.PositionTypeID)
1Software EngineerBachelor's degree in Computer Science100000.021
2Data AnalystBachelor's degree in Mathematics or Statistics80000.022
3Product ManagerMBA or equivalent experience120000.043
4UX DesignerBachelor's degree in Graphic Design or Interaction Design90000.034
5HR GeneralistBachelor's degree in Human Resources60000.025

JobPostings

JobIDPositionIDCompanyIdOpeningDateClosingDateDescriptionLocationApplicationInstructionsRequisitionNumberIsActive
(→ Positions.PositionID)(→ Companies.CompanyId)
1112021-01-012021-12-31Seeking a software engineer...New YorkApply online at our website.REQ123451
2222021-02-012021-12-31Looking for an experienced product manager...San FranciscoSubmit resume and cover letter via email.REQ678901
3332021-03-012021-12-31We are hiring a UX designer...Los AngelesApply through our careers portal.REQ135791
4442021-04-012021-12-31A HR generalist is needed for our team...ChicagoEmail resume to hr@company.com.REQ246801
5552021-05-012021-12-31Join us as a data analyst...DallasComplete this form on our website.REQ369011

SalesManagers

ManagerIDEmployeeIDDepartmentID
(→ Employees.EmployeeID)(→ Departments.DepartmentID)
111
222
331
442
551

MarketingSpecialists

SpecialistIDEmployeeIDDepartmentID
(→ Employees.EmployeeID)(→ Departments.DepartmentID)
113
224
333
444
553

EmploymentArrangements

EmpArrangementIDEmployeeIDArrangementIDStartDateEndDate
(→ Employees.EmployeeID)(→ WorkingArrangements.ArrangementID)
1112020-06-012022-06-01
2222019-07-012021-07-01
3332018-08-012020-08-01
4442017-09-012019-09-01
5552016-10-012018-10-01