Employees (MySQL database)

- Employees (MySQL database)

salaries

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

Information about employee's salary.

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		salary	int(10, 0)				The amount of salary.
The amount of salary.
	3		from_date	date				The date when employee started earning a salary in this amount. "9999-01-01" = Current salary
The date when employee started earning a salary in this amount. "9999-01-01" = Current salary
	4		to_date	date				The date when employee finished earning a salary in this amount. "9999-01-01" = Current salary
The date when employee finished earning a salary in this amount. "9999-01-01" = Current salary

Relations

Foreign table		Primary table	Join	Title / Name / Description
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

Unique keys

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

Uses

Name
salaries
employees

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