Employees (MySQL database)

- Employees (MySQL database)

titles

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

Information about employee's title (job position).

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		title	varchar(50)				The job title.
The job title.
	3		from_date	date				Date of started of work on this position by the employee.
Date of started of work on this position by the employee.
	4		to_date	date				The date of ended of work on this position by the employee. '9999-01-01'= Current title.
The date of ended of work on this position by the employee. '9999-01-01'= Current title.

Relations

Foreign table		Primary table	Join	Title / Name / Description
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, title, from_date	Primary key constraint.
Primary key constraint.

Uses

Name
titles
employees

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