Employees (MySQL database)

- Employees (MySQL database)

employees

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

Employee information such as first name, last name, date of birth.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		emp_no	int(10, 0)				Employee identification number.Primary key for employee table.
Employee identification number.Primary key for employee table.
	2		birth_date	date				Date of birth.
Date of birth.
	3		first_name	varchar(14)				The employee's first name.
The employee's first name.
	4		last_name	varchar(16)				The employee's last name.
The employee's last name.
	5		gender	enum				M = Male, F = Female
M = Male, F = Female
	6		hire_date	date				Employee hired on this date.
Employee hired on this date.

Relations

Foreign table		Primary table	Join	Title / Name / Description
dept_emp		employees	dept_emp.emp_no = employees.emp_no	dept_emp_ibfk_1 Foreign key constraint referencing employees.emp_no
dept_emp.emp_no = employees.emp_no Name: dept_emp_ibfk_1 Foreign key constraint referencing employees.emp_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
salaries		employees	salaries.emp_no = employees.emp_no	salaries_ibfk_1 Foreign key constraint referencing employees.emp_no
salaries.emp_no = employees.emp_no Name: salaries_ibfk_1 Foreign key constraint referencing employees.emp_no
titles		employees	titles.emp_no = employees.emp_no	titles_ibfk_1 Foreign key constraint referencing employees.emp_no
titles.emp_no = employees.emp_no Name: titles_ibfk_1 Foreign key constraint referencing employees.emp_no

Unique keys

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

Used by

Name
employees
dept_emp
dept_manager
salaries
titles

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