departments
Documentation | Employees (MySQL database) |
Name | departments |
Module | Employees database diagram |
Information about departments - name and number.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | dept_no | char(4) | Department identification number. Primary key for department table. | |||||
Department identification number. Primary key for department table. |
||||||||
2 | dept_name | varchar(40) | Name of the department. (unique key) | |||||
Name of the department. (unique key) |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
dept_emp | departments | dept_emp.dept_no = departments.dept_no | dept_emp_ibfk_2 Foreign key constraint referencing departments.dept_no |
|
dept_emp.dept_no = departments.dept_no Name: dept_emp_ibfk_2Foreign key constraint referencing departments.dept_no |
||||
dept_manager | departments | dept_manager.dept_no = departments.dept_no | dept_manager_ibfk_2 Foreign key constraint referencing departments.dept_no |
|
dept_manager.dept_no = departments.dept_no Name: dept_manager_ibfk_2Foreign key constraint referencing departments.dept_no |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PRIMARY | dept_no | Primary key constraint. | |
Primary key constraint. | |||
dept_name | dept_name | Unique index. | |
Unique index. |
Used by
Name |
---|
departments
|
Exported: 2018-11-09 14:32, Last imported: 2018-08-06 09:21