Versions Compared

Key

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

Table

cm_addresses

Description

Addresses

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement

 

street

varchar(400)

Street

X.520 via RFC 4519 organizationalPerson

 

room

varchar(64)

Room

X.520 via RFC 4519 organizationalPerson

 

locality

varchar(128)

Locality (eg: city)

X.520 via RFC 4519 organizationalPerson

 

state

varchar(128)

State or Province

X.520 via RFC 4519 organizationalPerson

 

postal_code

varchar(16)

Postal Code

X.520 via RFC 4519 organizationalPerson

 

country

varchar(128)

Country

X.521 via RFC 4519 country

 

descriptionvarchar(128)Description Added in Registry v3.1.0.

type

varchar(2)

Type of mail, as enumerated

 

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

language

varchar(16)

Language encoding of this address

RFC 5646

For supported values, see lang.php

co_person_role_id

integer, foreign key

CO Person Record ID

cm_co_person_roles:id

Only one

of

of co_person

_role

_id

or

org_identity_id, or co_department_id

may

 may be specified

org_identity_id

integer, foreign key

Org Identity Record ID

cm_org_identities:id

Only one

of

of co_person

_role_id

_idorg_identity_id, or co_department_id may be specified

co_department_idinteger, foreign keyCO Department Record IDcm_co_departments:idOnly one of co_person_idorg_identity_id, or co_department_id may be specified. Added in Registry v3.1.0.
source_address_idinteger, foreign keyIf Pipelines are in use, the Address ID for the Org Identity Address that created this record.cm_addresses:idAdded in Registry v2.0.0.
or org_identity_id may be specified