...
Column | Format | Description | Definition | Required | Comments | |
|---|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | ||
| co_id | integer, foreign key | CO Record ID | cos:id | | ||
| cou_id | integer, foreign key | COU Record ID | cous:id | Currently only intended for | specialSystem groups, may be used for Standard groups in the future | |
name | varchar(128) | Group name | | |||
description | varchar(256) | Description | ||||
| open | boolean | An open group allows anyone to self-subscribe |
| | ||
| status | varchar(2) | Group's status within CO |
| | ||
| group_type | varchar(2) | Group Type |
| | ||
| nesting_mode_all | boolean | Nested Group Memberships calculation mode |
| | ||
| owners_group_id | integer, foreign key | Group ID for corresponding Owners Group | groups:id | Null for Owners Groups |