| 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 |