Table | cm_co_departments |
|---|---|
Description | Per-CO Departments |
Column | Format | Description | Definition | Comments |
|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement | |
co_id | integer, foreign key | CO Record ID | cm_cos:id | |
| cou_id | integer, foreign key | COU Record ID | cm_cous:id | |
| name | varchar(128) | Name | ||
description | varchar(128) | Description | ||
| type | varchar(32) | CO Department type | Added in Registry v3.3.0. May be configured on a per-CO basis. See Extending the Registry Data Model. | |
| introduction | text(4000) | Brief introduction describing department | Intended for rendering in Service Portal or Department Directory | |
leadership_co_group_id | integer, foreign key | CO Group ID describing the leadership (eg: chairs, VPs, etc) of the Department | cm_co_groups:id | |
| administrative_co_group_id | integer, foreign key | CO Group ID describing the administrators (eg: department admin) of the Department | cm_co_groups:id | |
| support_co_group_id | integer, foreign key | CO Group ID describing the support staff (eg: technical or administrative assistants) of the Department | cm_co_groups:id |