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 |
|