departments


Columns

Column Type Size Nulls Auto Default Children Parents Comments
dept_no CHAR 4 null
current_dept_emp.dept_no Implied Constraint R
dept_emp.dept_no dept_emp_ibfk_2 C
dept_manager.dept_no dept_manager_ibfk_2 C
dept_name VARCHAR 40 null

Table contained 9 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc dept_no
dept_name Must be unique Asc dept_name

Relationships