Table

cm_api_users

Description

API (Programmatic) Users

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement


co_idinteger, foreign keyCO IDcm_cos:id

If co_id is 1 (COmanage CO), the API User is a Platform API User

Added Registry v3.3.0

username

varchar(50)

User (login) name



password

varchar(40)

Hashed password

SHA1, as used by CakePHP

Will be renamed api_key in Registry v5.0.0

privilegedbooleanIf this API User is a "superuser" within its CO
  • true: API User is privileged
  • false: API User is not privileged
Added Registry v3.3.0
statusvarchar(2)API User status
  • A: Active
  • S: Suspended
Added Registry v3.3.0

valid_from

datetime

API User is valid from this time

If null, valid any time through valid_through

Added Registry v3.3.0

valid_through

datetime

API User is valid through (but not past) this time

If null, valid any time from valid_from

Added Registry v3.3.0
remote_ipvarchar(80)IP addresses this API User may connect fromDefined as regular expression, or null for any IP addressAdded Registry v3.3.0
  • No labels