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 |
|
| description | varchar(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 | For supported values, see | |
co_person_role_id | integer, foreign key | CO Person Record ID | Only one of | |
org_identity_id | integer, foreign key | Org Identity Record ID | Only one of | |
| co_department_id | integer, foreign key | CO Department Record ID | cm_co_departments:id | Only one of co_person_id, org_identity_id, or co_department_id may be specified. Added in Registry v3.1.0. |
| source_address_id | integer, foreign key | If Pipelines are in use, the Address ID for the Org Identity Address that created this record. | cm_addresses:id | Added in Registry v2.0.0. |