...
| Column | Format | Nullable | Description | Definition | Comments |
|---|---|---|---|---|---|
| id | integer, primary key |  | Row identifier | autoincrement | |
| person_id | integer, foreign key | | Person this email address is attached to | prc_sor_persons:id | |
| prs_address_id | integer, foreign key |  | SOR address that generated this calculated address | prs_addresses:id | |
| line1 | varchar(100) | | Address line 1 |  Should address lines 1-3 be consolidated? | |
| line2 | varchar(100) | | Address line 2 | ||
| line3 | varchar(100) | | Address line 3 | ||
| building_id | integer, foreign key | | Building | drd_buildings:id | |
| room | varchar(20) | | Room | ||
| city | varchar(100) | | City | ||
| region_id | integer, foreign key | | State / Region | ctd_regions:id | |
| country_id | integer, foreign key | | Country | ctd_countries:id | |
| postal_code | varchar(20) | | Postal / ZIP Code | ||
| address_t | integer, foreign key | | Type of this address |
| |
| verified | boolean | | Whether this address has been verified by the IdMS | Verification via (eg) activation key delivery | |
| primary | boolean | | Whether this is the primary address for this person | ||
| language | varchar(16) | | Language encoding of this nameaddress | RFC 5646 |
Migration Notes From OR 1
...