COordinate Data Model

Table Name	Description
cm_addresses	Addresses
cm_api_users	API (Programmtic) Users
cm_applications	Known applications
cm_co_applications	Per-CO configured applications
cm_co_directory_permissions	Per-CO restrictions on publishing of directory information
cm_co_extended_attributes	Per-CO extended attributes
cm_co_groups	Per-CO groups
cm_co_group_members	Per-CO group memberships
cm_co_invites	Per-CO invitations to join
cm_co_people	Per-CO person identity
cm_co_person_sources	Per-CO link from person to org person
cm_co_role_assignments	Per-CO person role assignments
cm_co_role_groups	Per-CO group memberships implied by role
cm_co_roles	Per-CO role definitions
cm_configuration	COordinate configuration values
cm_cos	Definitions of (virtual) organizations
cm_email_addresses	Email Addresses
cm_history	Transaction history (human readable)
cm_identifiers	Person identifiers, from organizational source
cm_names	Names
cm_org_people	Person identity, from organizational source
cm_organizations	Definitions of (real) organizations
cm_permissions	Permissions for COoordinate
cm_telephone_numbers	Telephone numbers

View All Tables.
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

Space shortcuts