Table

cm_co_groups

Description

Per-CO group definitions

Category

Secondary Object

Status

Stable

Introduced

v0.2

Last Updated

v4.0.0

Future: v5.0.0

groups

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement


co_id

integer, foreign key

CO Record ID

cm_cos:id


cou_idinteger, foreign keyCOU Record IDcm_cous:idAdded v2.0.0. Initially intended for special groups, may be used for manual groups in the future.

name

varchar(128)

Group name



description

varchar(256)

Description



open

boolean

An open group allows anyone to self-subscribe

  • true: Open
  • false: Closed


status

varchar(2)

Group's status within CO

  • A: Active
  • S: Suspended


group_typevarchar(2)Group Type
  • A: Admins
  • M: All Members
  • MA: Active Members
  • S: Standard
Added v2.0.0.
autobooleanAutomatic Group
  • true: Group is automatically managed
  • false: Group is manually managed
Added v2.0.0.
nesting_mode_allbooleanNested Group Memberships calculation mode
  • true: Member must be a member of ALL nested groups
  • false: Member may be a member of ANY nested group
Added v4.0.0.