Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.1.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.1.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