Table departments

Table departments holds a list of departments used to help organize the employee list. They can be grouped by fields derived in the departments_type table.

Table Type: MyISAM

Field Type Default Description
id char (15) NOT NULL PRIMARY KEY - Holds unique department ID.
description varchar(30) NOT NULL Textual description of the department.
subdepartment enum (0,1) 0 Flag indicating if this is a sub-department of another department. Nesting is unlimited.
primary_dept_id char(15) NULL If sub-department flase set, this hold the id of the parent department
department_type tinyint 0 Holds the department tye as defined in table department_types
department_inactive enum (0,1) 0 Flag indicating if the department is inactive.