...
Column | Format | Description | Definition | Comments | |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |
| |
line1street | varchar(128400) | Address line 1Street | X.520 via RFC 4519 organizationalPerson | May be street or postOfficeBox |
|
roomline2 | varchar(12864) | Address line 2Room | X.520 via RFC 4519 organizationalPerson | May be street or postOfficeBox | |
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 |
| |
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 |