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