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