v_full_departments
Documentation | Employees (MySQL database) |
Name | v_full_departments |
Information about department with manager names.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | dept_no | char(4) | Departament identification number. | |||||
Departament identification number. |
||||||||
2 | dept_name | varchar(40) | Name of the department. | |||||
Name of the department. |
||||||||
3 | manager | varchar(32) | ID of recent manager(employeee) - (result from function current_manager ) | |||||
ID of recent manager(employeee) - (result from function current_manager ) |
Script
select `employees`.`departments`.`dept_no` AS `dept_no`,`employees`.`departments`.`dept_name` AS `dept_name`,`current_manager`(`employees`.`departments`.`dept_no`) AS `manager` from `employees`.`departments` |
Exported: 2018-11-09 14:32, Last imported: 2018-08-06 09:21