Table

cm_co_group_members

Description

Per-CO group memberships

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement


co_group_id

integer, foreign key

CO Group Record ID

cm_co_groups:id


co_person_id

integer, foreign key

CO Person Record ID

cm_co_people:id


member

boolean

Person is a member of the group

  • true: Member
  • false: Not a member


owner

boolean

Person is an owner of the group

  • true: Owner
  • false: Not an owner


valid_from

datetime

CO Group Membership is considered valid from this time

If null, valid any time through valid_through

Added in v3.2.0

valid_through

datetime

CO Group Membership is considered valid through (but not past) this time

If null, valid any time from valid_from

Added in v3.2.0
source_org_identity_idinteger, foreign keyIf Pipelines are in use, the Org Identity ID of record that created this Group Membershipcm_org_identities:id
co_group_nesting_idinteger, foreign keyIf set, this membership was created via a Nested Group and cannot be manually editedcm_co_group_nestings:idAdded in v3.3.0
  • No labels