Table

cm_co_identifier_assignments

Description

Per-CO rules for identifier assignment

  • There is currently no REST interface to this table.

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement


co_id

integer, foreign key

CO ID

cm_cos:id


statusvarchar(2)Identifier Assignment status
  • A: Active
  • S: Suspended
Added v3.3.0
contextvarchar(2)Context (object type) this Identifier Assignment applies to
  • CD: CoDepartment
  • CG: CoGroup
  • CP: CoPerson
Added v3.3.0
co_group_idinteger, foreign keyIf set, subject CO Person must be a member of this CO Group ID for for this Identifier Assignment to runcm_co_groups:idAdded v4.1.0

identifier_type

varchar(32)

Type of identifier

cm_identifiers:type

A given identifier type may be used more than once

email_type

varchar(32)

Type of email address to assign, if identifier_type is email

cm_email_addresses:type

If not blank and identifier type to be assigned is email, then an entry in cm_email_addresses will also be created, of this type

description

varchar(256)

Description



login

boolean

Registry login flag


Will be used to populate cm_identifiers:login

algorithm

varchar(2)

Algorithm to use to assign this identifier

  • R: Random assignment
  • S: Sequential assignment


pluginvarchar(64)Plugin to use for identifier assignment, if set
Added v4.1.0

format

varchar(256)

Format to use for this identifier



permitted

varchar(2)

Valid characters permitted to substitute into format

  • AD: Alphanumeric characters, dot, dash, and underscore
  • AL: All characters
  • AN: Alphanumeric characters
  • AQ: Alphanumeric characters, dot, dash, underscore, and apostrophe (single quote)


minimum

integer

Minimum value to assign (for numeric identifiers). For sequential, this is the first number to assign.



maximum

integer

Maximum value to assign. For sequential, if this number is reached identifier assignment will fail.



collision_resolution

varchar(64)

Collision resolution mechanism


Not implemented

exclusions

varchar(8)

Characters and words to avoid in assignments

  • C: Confusing (0 vs O, 1 vs l)
  • O: Offensive
  • S: Superstitions (4, 13, etc)

Not implemented

ordr

integer

Order identifier assignment is run (lower numbers = earlier)


Added v3.3.0, need only be unique within context
  • No labels