Table | sp_addresses |
|---|---|
Description | Addresses for an Entity |
| Plugin | SQL Provisioner Plugin |
For column definitions, see Registry Table: addresses
Column | Format | Comments |
|---|---|---|
id | integer, primary key | |
| person_id | integer, foreign key | |
| person_role_id | integer, foreign key | |
| external_identity_id | integer, foreign key | |
| external_identity_role_id | integer, foreign key | |
| street | varchar(128) | |
| room | varchar(64) | |
| locality | varchar(128) | |
| state | varchar(128) | |
| postal_code | varchar(16) | |
| country | varchar(128) | |
description | varchar(128) | |
| type_id | integer, foreign key |