employees


Columns

Column Type Size Nulls Auto Default Children Parents Comments
emp_no INT 10 null
current_dept_emp.emp_no Implied Constraint R
dept_emp.emp_no dept_emp_ibfk_1 C
dept_emp_latest_date.emp_no Implied Constraint R
dept_manager.emp_no dept_manager_ibfk_1 C
salaries.emp_no salaries_ibfk_1 C
titles.emp_no titles_ibfk_1 C
birth_date DATE 10 null
first_name VARCHAR 14 null
last_name VARCHAR 16 null
gender enum('M', 'F') 2 null
hire_date DATE 10 null

Table contained 299290 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc emp_no

Relationships