Versions Compared

Old Version 91

changes.mady.by.user Benn Oshrin

Saved on

compared with

New Version 92

changes.mady.by.user Benn Oshrin

Saved on

Key

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

...

Info
titleAdditional 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 (created, modified)
  • Columns used in support of Changelog Behavior
Info
titleStatus

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 Name

Description

Status

cm_addresses

Addresses

TentativeStable

cm_api_users

API (Programmatic) Users

To be refactoredTentative

cm_applications

Known applications

Not implementedImplemented

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 implementedImplemented

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 implementedImplemented

cm_co_enrollment_attributes

Per-CO enrollment flow attribute configurations

TentativeStable

cm_co_enrollment_attribute_defaults

Default values for CO enrollment flow attributes configuration

TentativeStable

cm_co_enrollment_flows

Per-CO enrollment flow configurations

TentativeStable

cm_co_expiration_policies

Per-CO expiration policies

TentativeStable

cm_co_extended_attributes

Per-CO extended attributes

TentativeStable

cm_co_extended_types

Per-CO attribute type configurations

TentativeStable

cm_co_fifer_servers

Per-CO FIFER services

Not implementedImplemented

cm_co_github_provisioner_targets

Per-CO GitHub provisioning target configurations

Tentative

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

TentativeStable

cm_co_group_members

Per-CO group memberships

TentativeStable

cm_co_homedir_provisioner_targets

Per-CO Home Directory provisioning target configurations

Experimental

cm_co_identifier_assignments

Per-CO rules for identifier assignment

TentativeStable

cm_co_invites

Per-CO invitations to join

To be refactoredTentative

cm_co_ldap_provisioner_attr_groupings

Per-CO per-LDAP target attribute grouping definitions

TentativeStable

cm_co_ldap_provisioner_attributes

Per-CO per-LDAP target attribute definitions

TentativeStable

cm_co_ldap_provisioner_dns

Per-CO per-LDAP target DN map

TentativeStable

cm_co_ldap_provisioner_targets

Per-CO LDAP provisioning target configurations

TentativeStable

cm_co_localizations

Per-CO Text Localizations

TentativeStable

cm_co_name_identifier_assignments

Per-Identifier tracking of assigned name-based sequences

Obsolete

cm_co_navigation_links

Per-CO Navigation Links

TentativeStable

cm_co_notifications

Per-CO Notifications

TentativeStable

cm_co_nsf_demographics

Demographics for statistics

TentativeStable

cm_co_org_identity_links

Per-CO link to org identity

TentativeStable

cm_co_people

Per-CO person identity

TentativeStable

cm_co_person_roles

Per-CO person role identity

TentativeStable

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

TentativeStable

cm_co_petition_history_records

Per-CO enrollment petition history records

TentativeStable

cm_co_petitions

Per-CO enrollment petitions

TentativeStable

cm_co_provisioning_exports

Per-CO provisioning target export record

TentativeStable

cm_co_provisioning_queued_events

Per-CO provisioning events to process

TentativeNot Implemented

cm_co_provisioning_targets

Per-CO provisioning targets

TentativeStable

cm_co_role_assignments

Per-CO person role assignments

Not implementedImplemented

cm_co_role_groups

Per-CO group memberships implied by role

Not implemented

cm_co_roles

Per-CO role definitions

Not implementedImplemented

cm_co_self_service_permissions

Per-CO self service permissions

TentativeStable

cm_co_sequential_identifier_assignments

Per-Identifier tracking of next values for sequentially assigned identifiers

TentativeStable

cm_co_settings

Per-CO Settings

TentativeStable

cm_co_tandc_agreements

Per-CO Person agreements to terms and conditions

TentativeStable

cm_co_terms_and_conditions

Per-CO terms and conditions

TentativeStable

cm_configuration

COordinate configuration values

Not implementedObsolete

cm_cos

Definitions of (virtual) organizations

TentativeStable

cm_cous

Definitions of (virtual) organization units

TentativeStable

cm_co_nsf_demographics

Demographics

Tentative

cm_email_addresses

Email Addresses

TentativeStable

cm_history_records

Transaction history (human readable)

TentativeStable

cm_identifiers

Person identifiers, from organizational source

TentativeStable

cm_metaMeta (platform) informationTentative

cm_names

Names

TentativeStable

cm_navigation_links

Navigation Links

TentativeStable

cm_org_identities

Person identity, from organizational source

TentativeStable

cm_organizations

Definitions of (real) organizations

To be refactoredExperimental

cm_permissions

Permissions for COoordinate

Not implementedImplemented

cm_ssh_keys

SSH keys

TentativeStable

cm_telephone_numbers

Telephone numbers

TentativeStable

  • View All Tables in a list or
  • View data model 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

...