Overview

The COmanage Match Data Model revolves around the Matchgrid, which is a single, dynamically managed table representing matching state.

  • COmanage Match is multi-tenant. Each tenant has its own Matchgrid.
  • Data is loaded into a Matchgrid from one or more Systems of Record (SOR). Each record from an SOR must have a key that is unique across all records from that SOR, this key is referred to as the System of Record Identifier (SORID).
  • Each unique individual identified by COmanage Match is assigned a Reference Identifier. A given Reference Identifier can be associated with one or more SORIDs from one or more SORs.

Tables

Additional Columns

In addition to the column definitions available for each table below, all tables have additional columns used by the framework and supporting code. These columns include

  • Timestamps managed by Cake (createdmodified)
  • Columns used in support of Changelog Behavior

Status

The statuses for each table are defined as

  • Stable: The table definition will not change in a backwards-incompatible manner across minor releases. Stable tables may only be removed in major releases.
  • Tentative: The table definition will likely become stable, but may change in a backwards-incompatible manner across minor and patch releases. Tentative tables may be refactored or removed without notice.
  • Experimental: No specific assertion is made about the stability of the table. It may be changed significantly or even removed without notice.
  • Obsolete: The table is no longer in use as of the specified version.
  • Not Implemented: The table definition is for planning purposes only.

Major, minor, and patch releases are as defined in semantic versioning.

Table NameDescriptionStatusIntroduced
api_users
Tentativev1.0.0
attribute_groupsAttribute GroupsTentativev1.0.0
attribute_maps
Tentativev1.0.0
attribute_mappings
Tentativev1.0.0
attributesAttributesTentativev1.0.0
endpointsEndpointsTentativev1.1.0
matchgrid_history_recordsMatchgrid History RecordsTentativev1.1.0
matchgrid_settingsMatchgrid SettingsTentativev1.0.0
matchgridsCatalog of MatchgridsTentativev1.0.0
meta
Tentativev1.0.0
mg_*
Tentativev1.0.0
permissions
Tentativev1.0.0
rule_attributesRule AttributesTentativev1.0.0
rulesRulesTentativev1.0.0
systems_of_recordSystem of RecordsTentativev1.0.0