Table | email_addresses |
|---|---|
Description | Email Addresses for a Person or External Identity |
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 | |
| external_identity_id | integer, foreign key | External Identity ID | external_identities:id | Exactly one entity foreign key is required | |
varchar(256) | Internet mail address | RFC 5321 Mailbox format | | ||
description | varchar(128) | Description | |||
verified | boolean | Whether this Email Address has been verified |
| ||
| type_id | integer, foreign key | Type of this Email Address | types:id | | |
| source_email_address_id | integer, foreign key | External Identity Email Address that was the source for this Email Address | email_addresses:id | ||
| frozen | boolean | Whether or not Pipeline processing will update this record |
|