Table

groups

Description

CO Groups


Column

Format

Description

Definition

Required

Comments

id

integer, primary key

Row identifier

autoincrement

(tick)


co_idinteger, foreign keyCO Record IDcos:id(tick)
cou_idinteger, foreign keyCOU Record IDcous:id
Currently only intended for System groups, may be used for Standard groups in the future

name

varchar(128)

Group name


(tick)


description

varchar(256)

Description




openbooleanAn open group allows anyone to self-subscribe
  • true: Open
  • false: Closed
(tick)
statusvarchar(2)

Group's status within CO

  • A: Active
  • S: Suspended
(tick)
group_typevarchar(2)Group Type
  • A: Admins
  • M: All Members
  • MA: Active Members
  • O: Owners
  • S: Standard
(tick)
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
(tick)
owners_group_idinteger, foreign keyGroup ID for corresponding Owners Groupgroups:id
Null for Owners Groups