All Tables

Table	cm_applications
Description	Known applications

Column	Format	Description	Definition
id	integer, primary key	Row identifier	autoincrement
name	varchar(256)	Application name
enabled	boolean	Enabled applications are available to COs	0: No 1: Yes

Table	cm_co_applications
Description	Per-CO configured applications

Column	Format	Description	Definition
id	integer, primary key	Row identifier	autoincrement
co_id	integer, foreign key	CO Record ID	cm_cos:id
name	varchar(256)	Application name
provisioned	boolean	Provisioned applications are available in the CO	0: No 1: Yes

Table	cm_co_directory_permissions
Description	Per-CO restrictions on publishing of directory information

Column	Format	Description	Definition	Comments
id	integer, primary key	Row identifier	autoincrement
cm_org_person_id	integer, foreign key	Org Person Record ID	cm_org_identities:id
attribute	varchar(256)	Schema attribute name	Correlate to cm_co_person_roles columns	Use attribute '*' to apply to entire record
release	boolean	Released attributes are public	0: No 1: Yes

Table	cm_co_groups
Description	Per-CO group definitions

Column	Format	Description	Definition	Comments
id	integer, primary key	Row identifier	autoincrement
co_id	integer, foreign key	CO Record ID	cm_cos:id
cou_id	integer, foreign key	COU Record ID	cm_cous:id	Added 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_type	varchar(2)	Group Type	A: Admins M: All Members MA: Active Members S: Standard	Added v2.0.0.
auto	boolean	Automatic Group	true: Group is automatically managed false: Group is manually managed	Added v2.0.0.
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	Added v4.0.0.

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_id	integer, foreign key	If Pipelines are in use, the Org Identity ID of record that created this Group Membership	cm_org_identities:id
co_group_nesting_id	integer, foreign key	If set, this membership was created via a Nested Group and cannot be manually edited	cm_co_group_nestings:id	Added in v3.3.0

Table	cm_co_invites
Description	Per-CO invitations to join

Column	Format	Description	Definition	Comments
id	integer, primary key	Row identifier	autoincrement
co_person_id	integer, foreign key	CO Person Record ID	cm_co_people:id
mail	varchar(256)	Email address invited	cm_email_addresses:mail	Copied rather than linked since the linked reference could change
skip_invite	boolean	Whether to skip the invitation step due to an already verified email address being present		Added in Registry v4.0.0 as a workaround for `SkipIfVerified` mode
email_address_id	integer, foreign key	Email Address ID to confirm	cm_email_addresses:id	If set, the invite is intended to verify the linked email address
invitation	varchar(16)	Randomly generated activation key
expires	datetime	Time at which invitation is no longer valid

Unable to render {include} The included page could not be found.

Table	cm_co_person_sources
Description	Link from CO person role to Org identity *This table is obsolete*

Column	Format	Description	Definition
id	integer, primary key	Row identifier	autoincrement
co_id	integer, foreign key	CO ID	cm_cos:id
co_person_id	integer, foreign key	CO Person Record ID	cm_co_person_roles:id
cou_id	integer, foreign key	COU ID	cm_cous:id
org_person_id	integer, foreign key	Organization Person Record ID	cm_org_identities:id

Table	cm_co_role_assignments
Description	Per-CO person role assignments

Column	Format	Description	Definition
id	integer, primary key	Row identifier	autoincrement
co_role_id	integer, foreign key	CO Role Record ID	cm_co_roles:id
co_person_id	integer, foreign key	CO Person Record ID	cm_co_person_roles:id
percent_time	integer	Percent time Person is allocated to Role	0 (none) to 100 (full)

Table	cm_co_role_groups
Description	Per-CO group memberships implied by role

Column	Format	Description	Definition
id	integer, primary key	Row identifier	autoincrement
co_role_id	integer, foreign key	CO Role Record ID	cm_co_roles:id
co_group_id	integer, foreign key	CO Group Record ID	cm_co_groups:id

Table	cm_co_roles
Description	Per-CO role definitions

Column	Format	Description	Definition
id	integer, primary key	Row identifier	autoincrement
co_id	integer, foreign key	CO Record ID	cm_cos:id
description	varchar(256)	Description
status	varchar(2)	Role's status within CO	A: Active D: Deleted

Table	cm_configuration
Description	COordinate configuration values This table was not implemented and is obsolete

Column	Format	Description	Definition
id	integer, primary key	Row identifier	autoincrement
attribute	varchar(256)	Configuration item
value	varchar(256)	Configuration value

Table	cm_cos
Description	Definitions of (virtual) organizations

Column	Format	Description	Definition	Comments
id	integer, primary key	Row identifier	autoincrement
name	varchar(128)	CO Name
description	varchar(256)	Description
status	varchar(2)	CO's status	A: Active S: Suspended T: Template	Template added Registry v3.2.0

Unable to render {include} The included page could not be found.

Table	cm_organizations
Description	Definitions of (external) organizations

Column	Format	Description	Definition	Comments
id	integer, primary key	Row identifier	autoincrement
co_id	integer, foreign key	CO Record ID	cm_cos:id
name	varchar(128)	Name
description	varchar(128)	Description
type	varchar(32)	Organization type		May be configured on a per-CO basis. See Extending the Registry Data Model.

Table	cm_permissions
Description	Permissions for COoordinate

Special CO with id "1" and name "COmanage" (linked via cm_co_person_roles:co_id) is where COordinate Admins are listed

Column	Format	Description	Definition
id	integer, primary key	Row identifier	autoincrement
co_person_id	integer, foreign key	CO Person Record ID	cm_co_person_roles:id
permission	varchar(2)	Permission	A: Admin for CO

Space shortcuts