Company
id | name | address | website |
1 | Company A | Address A | www.companya.com |
2 | Company B | Address B | www.companyb.com |
3 | Company C | Address C | www.companys.com |
4 | Company D | Address D | www.companyd.com |
5 | Company E | Address E | www.companye.com |
Department
id | company_id | name |
| (→ Company.id) | |
1 | 1 | Department A |
2 | 1 | Department B |
3 | 2 | Department X |
4 | 3 | Department Y |
5 | 4 | Department Z |
Position
id | department_id | title | creative_industry_profession | office | salary |
| (→ Department.id) | | | | |
1 | 1 | Position A | Graphic Designer | 2/7 London Street | 60000 |
2 | 1 | Position B | Software Engineer | 2/9 London Street | 80000 |
3 | 2 | Position C | Graphic Designer | 3/4 New York Avenue | 55000 |
4 | 3 | Position D | Data Analyst | 3/2 San Francisco Way | 70000 |
5 | 4 | Position E | Web Developer | 2/7 London Street | 75000 |
Employee
id | position_id | employee_name | hire_date |
| (→ Position.id) | | |
1 | 1 | John Doe | 2021-01-01 |
2 | 2 | Jane Smith | 2021-02-01 |
3 | 3 | Alice Johnson | 2021-03-01 |
4 | 4 | Bob Brown | 2021-04-01 |
5 | 5 | Charlie Green | 2021-05-01 |