View Source

Overview

The COmanage Registry Data Model revolves around the CO Person, which conceptually represents one person associated with a CO.

In order for a person to become a CO Person, they must first have at least one Org Identity, which conceptually represents their identity as asserted by a "home" institution, such as their University or a social identity provider.
A CO Person record is created and one or more Org Identities are linked to it. The CO Person record maintains information that is unique to a person within the CO, such as names and identifiers.
A CO Person may have one or more CO Person Roles within the CO. A CO Person Role record maintains information that is unique to a role a person has within a CO, such as title and physical address.

Tables

Table Name	Description	Status
cm_addresses	Addresses	Tentative
cm_api_users	API (Programmatic) Users	To be refactored
cm_applications	Known applications	Not implemented
cm_cmp_enrollment_attributes	CMP enrollment attribute configuration	Tentative
cm_cmp_enrollment_configurations	CMP enrollment configuration	Tentative
cm_co_applications	Per-CO configured applications	Not implemented
cm_co_changelog_provisioner_targets	Per-CO Changelog provisioning target configurations	Tentative
cm_co_directory_permissions	Per-CO restrictions on publishing of directory information	Not implemented
cm_co_enrollment_attributes	Per-CO enrollment flow attribute configurations	Tentative
cm_co_enrollment_attribute_defaults	Default values for CO enrollment flow attributes configuration	Tentative
cm_co_enrollment_flows	Per-CO enrollment flow configurations	Tentative
cm_co_extended_attributes	Per-CO extended attributes	Tentative
cm_co_extended_types	Per-CO attribute type configurations	Tentative
cm_co_fifer_servers	Per-CO FIFER services	Experimental
cm_co_grouper_provisioner_groups	Per-CO per-Grouper target Grouper group map	Tentative
cm_co_grouper_provisioner_targets	Per-CO Grouper provisioning target configurations	Tentative
cm_co_groups	Per-CO groups	Tentative
cm_co_group_members	Per-CO group memberships	Tentative
cm_co_identifier_assignments	Per-CO rules for identifier assignment	Tentative
cm_co_invites	Per-CO invitations to join	To be refactored
cm_co_ldap_provisioner_attr_groupings	Per-CO per-LDAP target attribute grouping definitions	Tentative
cm_co_ldap_provisioner_attributes	Per-CO per-LDAP target attribute definitions	Tentative
cm_co_ldap_provisioner_dns	Per-CO per-LDAP target DN map	Tentative
cm_co_ldap_provisioner_targets	Per-CO LDAP provisioning target configurations	Tentative
cm_co_localizations	Per-CO Text Localizations	Tentative
cm_co_name_identifier_assignments	Per-Identifier tracking of assigned name-based sequences	Obsolete
cm_co_navigation_links	Per-CO Navigation Links	Tentative
cm_co_nsf_demographics	Demographics for statistics	Tentative
cm_co_org_identity_links	Per-CO link to org identity	Tentative
cm_co_people	Per-CO person identity	Tentative
cm_co_person_roles	Per-CO person role identity	Tentative
cm_co_person_sources	Per-CO link from person to org person	Obsolete as of v0.2
cm_co_petition_attributes	Per-CO enrollment petition attributes	Tentative
cm_co_petition_history_records	Per-CO enrollment petition history records	Tentative
cm_co_petitions	Per-CO enrollment petitions	Tentative
cm_co_provisioning_exports	Per-CO provisioning target export record	Tentative
cm_co_provisioning_queued_events	Per-CO provisioning events to process	Tentative
cm_co_provisioning_targets	Per-CO provisioning targets	Tentative
cm_co_role_assignments	Per-CO person role assignments	Not implemented
cm_co_role_groups	Per-CO group memberships implied by role	Not implemented
cm_co_roles	Per-CO role definitions	Not implemented
cm_co_sequential_identifier_assignments	Per-Identifier tracking of next values for sequentially assigned identifiers	Tentative
cm_co_tandc_agreements	Per-CO Person agreements to terms and conditions	Tentative
cm_co_terms_and_conditions	Per-CO terms and conditions	Tentative
cm_configuration	COordinate configuration values	Not implemented
cm_cos	Definitions of (virtual) organizations	Tentative
cm_cous	Definitions of (virtual) organization units	Tentative
cm_co_nsf_demographics	Demographics	Tentative
cm_email_addresses	Email Addresses	Tentative
cm_history_records	Transaction history (human readable)	Tentative
cm_identifiers	Person identifiers, from organizational source	Tentative
cm_names	Names	Tentative
cm_navigation_links	Navigation Links	Tentative
cm_org_identities	Person identity, from organizational source	Tentative
cm_organizations	Definitions of (real) organizations	To be refactored
cm_permissions	Permissions for COoordinate	Not implemented
cm_telephone_numbers	Telephone numbers	Tentative

View All Tables in a list or as a high level ERD.
Auditing: If enabled, each table will have a corresponding cma_ table with an additional timestamp column with all previous values.

Data	Potential Storage
Applications	SQL, LDAP?, Config file?
Changelog	SQL, Log files
Groups	SQL, Grouper
History	SQL, Log files
Invites	SQL, LDAP?
Mailing Lists	Mailman, Sympa, /etc/aliases, etc
Monitoring	Nagios, etc
Organizations	SQL, LDAP
People	SQL, LDAP
Permissions	SQL, Grouper, Config file?
Reports	JasperReports, etc
Roles	SQL, Grouper