dept_manager


Columns

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

Table contained 24 rows

Indexes

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

Relationships