Registry Table: groups

Table	groups
Description	CO Groups

Column	Format	Description	Definition	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 System 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	true: Open false: Closed
status	varchar(2)	Group's status within CO	A: Active S: Suspended
group_type	varchar(2)	Group Type	A: Admins M: All Members MA: Active Members O: Owners S: Standard
nesting_mode_all	boolean	Nested Group Memberships calculation mode	true: Member must be a member of ALL nested groups false: Member may be a member of ANY nested group
owners_group_id	integer, foreign key	Group ID for corresponding Owners Group	groups:id	Null for Owners Groups
parent_id	integer, foreign key	Parent COU Record ID	cous:id	Added Registry v5.2.0
lft	integer	Tree left value	Tree Behavior	Added Registry v5.2.0 Automatically managed
rght	integer	Tree right value	Tree Behavior	Added Registry v5.2.0, Automatically managed

Space shortcuts