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. |