| Поле | Тип | Null | Ключ | За замовчуванням | Додатково |
|---|---|---|---|---|---|
| dept_no | char(4) | NO | PRI | None | |
| dept_name | varchar(40) | NO | UNI | None |
| dept_no | dept_name |
|---|---|
| d009 | Customer Service |
| d005 | Development |
| d002 | Finance |
| d003 | Human Resources |
| d001 | Marketing |
| d004 | Production |
| d006 | Quality Management |
| d008 | Research |
| d007 | Sales |