Table

addresses

Description

Addresses for an Entity


Column

Format

Description

Definition

Required

Comments

id

integer, primary key

Row identifier

autoincrement

(tick)


person_idinteger, foreign keyPerson IDpeople:idExactly one entity foreign key is required
person_role_idinteger, foreign keyPerson Role IDperson_roles:idExactly one entity foreign key is required
external_identity_idinteger, foreign keyExternal Identity IDexternal_identities:idExactly one entity foreign key is required
external_identity_role_idinteger, foreign keyExternal Identity Role IDexternal_identity_roles:idExactly one entity foreign key is required
streetvarchar(128)StreetX.520 via RFC 4519 organizationalPersonGoverned by co_settings
roomvarchar(64)RoomX.520 via RFC 4519 organizationalPerson

localityvarchar(128)Locality (eg: city)X.520 via RFC 4519 organizationalPersonGoverned by co_settings
statevarchar(128)State or ProvinceX.520 via RFC 4519 organizationalPersonGoverned by co_settings
postal_codevarchar(16)Postal CodeX.520 via RFC 4519 organizationalPersonGoverned by co_settings
countryvarchar(128)Country

X.521 via RFC 4519 country

Governed by co_settings

description

varchar(128)

Description




type_idinteger, foreign keyType of this Addresstypes:id(tick)
source_address_idinteger, foreign keyExternal Identity Address that was the source for this Addressaddresses:id

frozenbooleanWhether or not Pipeline processing will update this record
  • true: No updates
  • false: Updates


  • No labels