Employees (MySQL database)

- Employees (MySQL database)

dept_manager

Documentation	Employees (MySQL database)
Name	dept_manager
Module	Employees database diagram

Information about department manager.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		emp_no	int(10, 0)			employees	Employee identification number. (referens to employees.emp_no)
Employee identification number. (referens to employees.emp_no) References: employees
	2		dept_no	char(4)			departments	Department identification number. (reference to departaments.dept_no)
Department identification number. (reference to departaments.dept_no) References: departments
	3		from_date	date				Date the employee started work as the department manager.
Date the employee started work as the department manager.
	4		to_date	date				Date the employee ended work as the department manager. '9999-01-01'= Current department manager.
Date the employee ended work as the department manager. '9999-01-01'= Current department manager.

Relations

Foreign table		Primary table	Join	Title / Name / Description
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
dept_manager		employees	dept_manager.emp_no = employees.emp_no	dept_manager_ibfk_1 Foreign key constraint referencing employees.emp_no
dept_manager.emp_no = employees.emp_no Name: dept_manager_ibfk_1 Foreign key constraint referencing employees.emp_no

Unique keys

	Key name	Columns	Description
	PRIMARY	emp_no, dept_no	Primary key constraint.
Primary key constraint.

Uses

Name
dept_manager
departments
employees

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