companyID | name | location |
---|---|---|
1 | Company A | New York |
2 | Company B | San Francisco |
3 | Company C | Boston |
4 | Company D | Chicago |
5 | Company E | Los Angeles |
deptID | deptName | companyID |
---|---|---|
(→ Companies.companyID) | ||
1 | Engineering | 1 |
2 | Marketing | 2 |
3 | Human Resources | 3 |
4 | Finance | 4 |
5 | Product Development | 5 |
teamID | teamName | deptID |
---|---|---|
(→ Departments.deptID) | ||
1 | Web Developers | 1 |
2 | Mobile App Developers | 1 |
3 | Graphic Designers | 2 |
4 | Content Writers | 2 |
5 | Data Analysts | 4 |
positionID | title | description | teamID |
---|---|---|---|
(→ Teams.teamID) | |||
1 | Software Engineer | Develop and maintain software applications. | 1 |
2 | Android Developer | Design and develop Android apps. | 2 |
3 | UX/UI Designer | Create user-centered designs. | 2 |
4 | Data Scientist | Analyze data to provide insights. | 4 |
5 | Accountant | Handle financial transactions and reports. | 5 |
employeeID | firstName | lastName | phoneNumber | hireDate | positionID | |
---|---|---|---|---|---|---|
(→ Positions.positionID) | ||||||
1 | John | Doe | john.doe@example.com | 123-456-7890 | 2021-01-15 | 1 |
2 | Alice | Johnson | alice.johnson@example.com | 098-765-4321 | 2020-02-10 | 2 |
3 | Tom | Brown | tom.brown@example.com | 555-555-5555 | 2019-03-05 | 3 |
4 | Linda | Green | linda.green@example.com | 555-123-4567 | 2018-04-01 | 4 |
5 | Kevin | Black | kevin.black@example.com | 111-222-3333 | 2017-05-15 | 5 |
roleID | PositionID | Supervisor |
---|---|---|
(→ Positions.positionID) | ||
1 | 1 | John Doe |
2 | 1 | Alice Johnson |
3 | 2 | Tom Brown |
4 | 3 | Linda Green |
5 | 4 | Kevin Black |