Employees (MySQL database)

- Employees (MySQL database)

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_2 Foreign 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_2 Foreign 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
dept_emp
dept_manager

Exported: 2018-11-09 14:32, Last imported: 2018-08-06 09:21