| Column | Format | Nullable | Description | Definition | Comments |
|---|
| id | integer, primary key |  | Row identifier | autoincrement | |
| roleperson_record_id | integer, foreign key | | SOR Person this email address is attached to | prc_sor_persons:id | |
| prsstandardized_email_address_id | integer, foreign key |  | SOR email address that generated this calculated email address | | |
| address | varchar(5100) | | Email address | | |
| address_tvarchar | (100)integer, foreign key | | Type of this address | ctx_data_types:id | data_type=EMAIL
|
| verified | varchar(100)boolean | | Whether this address has been verified by the IdMS | | Verification via (eg) activation key delivery |
| primary | boolean | | Whether this is the primary email address for this person | | |