Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
salaries Table to_date DATE 10 null
dept_emp_latest_date View emp_no INT 10 null
current_dept_emp View dept_no CHAR 4 null
salaries Table salary INT 10 null
employees Table last_name VARCHAR 16 null
titles Table emp_no INT 10 null
salaries Table emp_no INT 10 null
dept_manager Table dept_no CHAR 4 null
employees Table first_name VARCHAR 14 null
departments Table dept_no CHAR 4 null
titles Table to_date DATE 10 null
dept_emp_latest_date View from_date DATE 10 null
titles Table from_date DATE 10 null
dept_manager Table to_date DATE 10 null
employees Table emp_no INT 10 null
current_dept_emp View emp_no INT 10 null
dept_emp Table dept_no CHAR 4 null
departments Table dept_name VARCHAR 40 null
employees Table hire_date DATE 10 null
titles Table title VARCHAR 50 null
salaries Table from_date DATE 10 null
dept_manager Table from_date DATE 10 null
current_dept_emp View from_date DATE 10 null
dept_emp Table emp_no INT 10 null
dept_emp Table from_date DATE 10 null
employees Table gender enum('M', 'F') 2 null
employees Table birth_date DATE 10 null
dept_emp Table to_date DATE 10 null
titlelist View title VARCHAR 50 null
dept_emp_latest_date View to_date DATE 10 null
current_dept_emp View to_date DATE 10 null
dept_manager Table emp_no INT 10 null