v_full_employees
Documentation | Employees (MySQL database) |
Name | v_full_employees |
Information about employees, such as name, surname, date of birth and lastest department in which they work.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | emp_no | int(10, 0) | Employee identification number. | |||||
Employee identification number. |
||||||||
2 | first_name | varchar(14) | The employee's first name. | |||||
The employee's first name. |
||||||||
3 | last_name | varchar(16) | The employee's last name. | |||||
The employee's last name. |
||||||||
4 | birth_date | date | Date of birth. | |||||
Date of birth. |
||||||||
5 | gender | enum | M = Male, F = Female | |||||
M = Male, F = Female |
||||||||
6 | hire_date | date | Employee hired on this date. | |||||
Employee hired on this date. |
||||||||
7 | department | varchar(40) | Name of the department. (result from emp_dept_name function) | |||||
Name of the department. (result from emp_dept_name function) |
Script
select `employees`.`employees`.`emp_no` AS `emp_no`,`employees`.`employees`.`first_name` AS `first_name`,`employees`.`employees`.`last_name` AS `last_name`,`employees`.`employees`.`birth_date` AS `birth_date`,`employees`.`employees`.`gender` AS `gender`,`employees`.`employees`.`hire_date` AS `hire_date`,`emp_dept_name`(`employees`.`employees`.`emp_no`) AS `department` from `employees`.`employees` |
Exported: 2018-11-09 14:32, Last imported: 2018-08-06 09:21