CompanyID | Name | Address | PhoneNumber |
---|---|---|---|
1 | TechCorp | 123 Tech St. | +123456789 |
2 | MedCo | 456 Med Ave. | +987654321 |
3 | FinCorp | 789 Fin Blvd., | +321654897 |
4 | EduInc | 123 Edu St. | +543219876 |
5 | GovAgency | 456 Gov Plaza | +789654321 |
DepartmentID | Name | Description | LocationID |
---|---|---|---|
(→ Companies.CompanyID) | |||
1 | Engineering | Research and Development | 1 |
2 | Marketing | Brand Management | 1 |
3 | HR | Recruitment and Onboarding | 2 |
4 | IT | System Administration | 2 |
5 | Accounting | Budget and Audit | 3 |
6 | Academics | Curriculum Design | 4 |
7 | Policy | Legislative Affairs | 5 |
PositionID | Title | Salary | DepartmentID |
---|---|---|---|
(→ Departments.DepartmentID) | |||
1 | Software Engineer | 80000 | 1 |
2 | Product Manager | 90000 | 1 |
3 | HR Specialist | 60000 | 2 |
4 | Network Administrator | 70000 | 2 |
5 | Accountant | 50000 | 3 |
6 | Professor | 85000 | 4 |
7 | Policy Analyst | 75000 | 5 |
EmployeeID | FirstName | LastName | BirthDate | HireDate | PositionID | Mental_Health_Career | Clinic |
---|---|---|---|---|---|---|---|
(→ Positions.PositionID) | |||||||
1 | John | Doe | 1990-01-01 | 2015-06-01 | 3 | Psychologist | Harmony Wellness Center |
2 | Jane | Smith | 1985-01-01 | 2017-08-01 | 4 | Psychologist | Serenity Center |
3 | Alice | Jackson | 1988-01-01 | 2018-12-01 | 1 | Psychiatrist | Harmony Wellness Center |
4 | Tom | Lee | 1992-01-01 | 2019-05-01 | 2 | Psychiatrist | Peaceful Haven |