Versions Compared

Key

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

Table

cm_telephone_numbers

Description

Telephone Numbers

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement

 

number

varchar(64)

Telephone number

X.520 via RFC 4519 person

 

type

varchar(2)

Type of telephone, as enumerated

  • F: Fax
  • H: Home
  • M: Mobile
  • O: Office

 

When attached to a CO Person Role, types may be configured on a per-CO basis. See Extending the Registry Data Model. 

co_person_role_id

integer, foreign key

CO Person Role Record ID

cm_co_person_roles:id

Only one of co_person_role_id or org_identity_id may be specified

org_identity_id

integer, foreign key

Org Identity Record ID

cm_org_identities:id

Only one of co_person_role_id or org_identity_id may be specified