Versions Compared

Key

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

...

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement

 

country_codevarchar(3)Telephone Country CodeITU E.164 
area_codevarchar(8)Telephone Area (National Destination) CodeITU E.164  

number

varchar(64)

Telephone numberSubscriber NumberX.520 via RFC 4519 person

ITU E.164

 

extensionvarchar(16)Telephone ExtensionLocation specific 

type

varchar(2)

Type of telephone

 

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