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_1Foreign 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
|
Exported: 2018-11-09 14:32, Last imported: 2018-08-06 09:21