dept_emp


Columns

Column Type Size Nulls Auto Default Children Parents Comments
emp_no INT 10 null
employees.emp_no dept_emp_ibfk_1 C
dept_no CHAR 4 null
departments.dept_no dept_emp_ibfk_2 C
from_date DATE 10 null
to_date DATE 10 null

Table contained 323263 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc emp_no + dept_no
idx_deptn Performance Asc dept_no
idx_emp Performance Asc emp_no

Relationships