id | address |
---|---|
1 | 2/7 London Street |
2 | 3/10 New York Avenue |
id | officeId | name | skills |
---|---|---|---|
(→ Office.id) | |||
1 | 1 | Alice Smith | Photoshop, Illustrator, InDesign |
2 | 2 | Bob Johnson | Photoshop, Illustrator, InDesign |
id | officeId | name | languages |
---|---|---|---|
(→ Office.id) | |||
1 | 1 | Carol Williams | JavaScript, HTML, CSS |
2 | 2 | David Brown | Python, Java, C++ |
id | fullName | phoneNumber | hireDate | |
---|---|---|---|---|
1 | Eve White | eve@example.com | +1234567890 | 2021-01-01 |
2 | Frank Black | frank@example.com | +0987654321 | 2021-02-01 |
skillId | description |
---|---|
1 | Proficient in Adobe Creative Suite |
2 | Experienced in frontend and backend development |
employeeId | skillId | level |
---|---|---|
(→ Employees.id) | (→ Skills.skillId) | |
1 | 1 | 5 |
1 | 2 | 7 |
2 | 1 | 8 |
2 | 2 | 6 |