id | name | phoneNumber | address | |
---|---|---|---|---|
1 | John Doe | johndoe@example.com | 123-456-7890 | 123 Main St |
2 | Jane Smith | janesmith@example.com | 987-654-3210 | 456 Elm St |
id | departmentName | managerId |
---|---|---|
(→ Employees.id) | ||
1 | Sales | 1 |
2 | Marketing | 2 |
jobTitle | targetMarket | salary | departmentId |
---|---|---|---|
(→ Jobs.title) | (→ Departments.id) | ||
Sales Associate | B2B | 50000 | 1 |
Sales Associate | Retail | 40000 | 1 |
Marketing Specialist | B2B | 60000 | 2 |
Marketing Specialist | Consumer Goods | 55000 | 2 |
skillName | requiredForJobId |
---|---|
(→ Jobs.id) | |
Customer Service | 1 |
Digital Marketing | 2 |
employeeId | yearsOfExperience | jobTitle | companyName | startDate | endDate |
---|---|---|---|---|---|
(→ Employees.id) | |||||
1 | 5 | Account Manager | ABC Corporation | 2015-01-01 | 2020-01-01 |
2 | 3 | Graphic Designer | XYZ Company | 2017-01-01 | 2020-01-01 |
id | title | description | location | postedOn | closingDate | minimumYearsOfExperience | skillsRequiredId |
---|---|---|---|---|---|---|---|
(→ Skills.skillName) | |||||||
1 | Sales Associate | Responsible for selling products to B2B clients. | New York | 2021-01-01 | 2021-02-01 | 1 | 1 |
2 | Sales Associate | Assisting customers at a retail store. | Los Angeles | 2021-01-01 | 2021-02-01 | 0 | 2 |
3 | Marketing Specialist | Developing digital marketing campaigns. | San Francisco | 2021-01-01 | 2021-02-01 | 2 | 3 |
4 | Marketing Specialist | Creating traditional advertising materials. | Chicago | 2021-01-01 | 2021-02-01 | 1 | 4 |