Table | addresses |
|---|---|
Description | Addresses for an Entity |
Column | Format | Description | Definition | Required | Comments |
|---|---|---|---|---|---|
id | integer, primary key | Row identifier | autoincrement |  | |
| person_id | integer, foreign key | Person ID | people:id | Exactly one entity foreign key is required | |
| person_role_id | integer, foreign key | Person Role ID | person_roles:id | Exactly one entity foreign key is required | |
| external_identity_id | integer, foreign key | External Identity ID | external_identities:id | Exactly one entity foreign key is required | |
| external_identity_role_id | integer, foreign key | External Identity Role ID | external_identity_roles:id | Exactly one entity foreign key is required | |
| street | varchar(128) | Street | X.520 via RFC 4519 organizationalPerson | Governed by co_settings | |
| room | varchar(64) | Room | X.520 via RFC 4519 organizationalPerson | ||
| locality | varchar(128) | Locality (eg: city) | X.520 via RFC 4519 organizationalPerson | Governed by co_settings | |
| state | varchar(128) | State or Province | X.520 via RFC 4519 organizationalPerson | Governed by co_settings | |
| postal_code | varchar(16) | Postal Code | X.520 via RFC 4519 organizationalPerson | Governed by co_settings | |
| country | varchar(128) | Country | X.521 via RFC 4519 country | Governed by co_settings | |
description | varchar(128) | Description | |||
| type_id | integer, foreign key | Type of this Address | types:id | | |
| source_address_id | integer, foreign key | External Identity Address that was the source for this Address | addresses:id | ||
| frozen | boolean | Whether or not Pipeline processing will update this record |
|