DepartmentID | Name |
---|---|
1 | Human Resources |
2 | IT |
3 | Finance |
4 | Marketing |
5 | Sales |
EmployeeID | FirstName | LastName | PhoneNumber | HireDate | Salary | DepartmentID | |
---|---|---|---|---|---|---|---|
(→ Departments.DepartmentID) | |||||||
1 | John | Doe | john.doe@example.com | 123-456-7890 | 2020-01-01 | 60000.0 | 1 |
2 | Jane | Smith | jane.smith@example.com | 987-654-3210 | 2019-02-01 | 50000.0 | 2 |
3 | Alice | Brown | alice.brown@example.com | 456-789-0123 | 2018-03-01 | 55000.0 | 3 |
4 | Bob | White | bob.white@example.com | 246-865-1357 | 2017-04-01 | 65000.0 | 4 |
5 | Charlie | Black | charlie.black@example.com | 654-321-0987 | 2016-05-01 | 70000.0 | 5 |
ArrangementID | Description |
---|---|
1 | Remote |
2 | Onsite |
3 | Hybrid |
4 | Flexible |
5 | Rotational |
PositionID | Title | MinimumQualifications | MaximumSalary | MINumberOfYearsExperience | ForeignKey_PositionType |
---|---|---|---|---|---|
(→ PositionTypes.PositionTypeID) | |||||
1 | Software Engineer | Bachelor's degree in Computer Science | 100000.0 | 2 | 1 |
2 | Data Analyst | Bachelor's degree in Mathematics or Statistics | 80000.0 | 2 | 2 |
3 | Product Manager | MBA or equivalent experience | 120000.0 | 4 | 3 |
4 | UX Designer | Bachelor's degree in Graphic Design or Interaction Design | 90000.0 | 3 | 4 |
5 | HR Generalist | Bachelor's degree in Human Resources | 60000.0 | 2 | 5 |
JobID | PositionID | CompanyId | OpeningDate | ClosingDate | Description | Location | ApplicationInstructions | RequisitionNumber | IsActive |
---|---|---|---|---|---|---|---|---|---|
(→ Positions.PositionID) | (→ Companies.CompanyId) | ||||||||
1 | 1 | 1 | 2021-01-01 | 2021-12-31 | Seeking a software engineer... | New York | Apply online at our website. | REQ12345 | 1 |
2 | 2 | 2 | 2021-02-01 | 2021-12-31 | Looking for an experienced product manager... | San Francisco | Submit resume and cover letter via email. | REQ67890 | 1 |
3 | 3 | 3 | 2021-03-01 | 2021-12-31 | We are hiring a UX designer... | Los Angeles | Apply through our careers portal. | REQ13579 | 1 |
4 | 4 | 4 | 2021-04-01 | 2021-12-31 | A HR generalist is needed for our team... | Chicago | Email resume to hr@company.com. | REQ24680 | 1 |
5 | 5 | 5 | 2021-05-01 | 2021-12-31 | Join us as a data analyst... | Dallas | Complete this form on our website. | REQ36901 | 1 |
ManagerID | EmployeeID | DepartmentID |
---|---|---|
(→ Employees.EmployeeID) | (→ Departments.DepartmentID) | |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 1 |
4 | 4 | 2 |
5 | 5 | 1 |
SpecialistID | EmployeeID | DepartmentID |
---|---|---|
(→ Employees.EmployeeID) | (→ Departments.DepartmentID) | |
1 | 1 | 3 |
2 | 2 | 4 |
3 | 3 | 3 |
4 | 4 | 4 |
5 | 5 | 3 |
EmpArrangementID | EmployeeID | ArrangementID | StartDate | EndDate |
---|---|---|---|---|
(→ Employees.EmployeeID) | (→ WorkingArrangements.ArrangementID) | |||
1 | 1 | 1 | 2020-06-01 | 2022-06-01 |
2 | 2 | 2 | 2019-07-01 | 2021-07-01 |
3 | 3 | 3 | 2018-08-01 | 2020-08-01 |
4 | 4 | 4 | 2017-09-01 | 2019-09-01 |
5 | 5 | 5 | 2016-10-01 | 2018-10-01 |