dept_manager
Documentation | Employees (MySQL database) |
Name | dept_manager |
Module | Employees database diagram |
Information about department manager.
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 | dept_no | char(4) | departments | Department identification number. (reference to departaments.dept_no) | ||||
Department identification number. (reference to departaments.dept_no) References: departments |
||||||||
3 | from_date | date | Date the employee started work as the department manager. | |||||
Date the employee started work as the department manager. |
||||||||
4 | to_date | date | Date the employee ended work as the department manager. '9999-01-01'= Current department manager. | |||||
Date the employee ended work as the department manager. '9999-01-01'= Current department manager. |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
dept_manager | departments | dept_manager.dept_no = departments.dept_no | dept_manager_ibfk_2 Foreign key constraint referencing departments.dept_no |
|
dept_manager.dept_no = departments.dept_no Name: dept_manager_ibfk_2Foreign key constraint referencing departments.dept_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_1Foreign key constraint referencing employees.emp_no |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PRIMARY | emp_no, dept_no | Primary key constraint. | |
Primary key constraint. |
Uses
Name |
---|
dept_manager
|
Exported: 2018-11-09 14:32, Last imported: 2018-08-06 09:21