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

		Name	Data type	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`

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